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