Rev DB errors
sarah.reichelt at gmail.com
Mon Feb 9 20:34:26 CST 2009
>> I found that the result returned by a faulty
>> call to revExecuteSQL, did NOT include either "revdberr" or "syntax
>> error", but just a text description of the error.
> This appears to along the same lines as Shao Sean's post "issues with rev
> comparing a returned string" 30 Jan, where he wrote the following script was
> not giving the expected results:
> put revDataFromQuery(TAB, LF, tConnID, tSQL) into tColumnInfo
> if (tColumnInfo contains "revdberr") then
> put tColumnInfo
> end if
> Your current experience would suggest that in certain circumstances errors
> do not post "revdberr" to the result so the 'then' structure is never
> This will certainly make error trapping far more laborious :-(
I THINK that revDataFromQuery will still return revdberr, but
revExecuteSQL does not. For that, you have to check for a number.
Anything other than a nmber will indicate an error.
More information about the use-livecode