>> 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 > entered. > > 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. Cheers, Sarah _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
