sqlca.result.x

returns the result of the last SQL command

 

select "ItemCode","ItemName" from "OITM" where "ItemCode"='1111'

 

Returns values in Variables <sqlca.result.1>

messagebox=ItemCode: <sqlca.result.1>, ItemName: <sqlca.result.2>