sqlca Error handling

Good development has always good error handling

In beas Script you can use  <sqlca.sqlcode> and <sqlca.sqlerrtext> you can check last result

 

sqlca.sqlcode

100        = entry not found

-1        = Syntax error

0        = all ok

 

Example

 

setvar=ls_itemcode=RM
sqlca.select "ItemName","OnHand" from "OITM" where "ItemCode"=<ls_itemcode,dbstring>

// Push information. We don't want to overwrite this by sub functions
setvar=ll_sqlcode=<sqlca.sqlcode>
if <ll_sqlcode> = 100 then
messagebox=error$$Entry not found
end if
if <ll_sqlcode> = -1 then
messagebox=error$$Sql Syntax error <sqlca.sqlerrtext>
end if
// continue script