I just put all calls to database functions inside a try/catch construct. Bob S
On Aug 20, 2014, at 15:09 , Dr. Hawkins <doch...@gmail.com> wrote: > On Sun, Aug 17, 2014 at 8:33 PM, Dan Friedman <d...@clearvisiontech.com> > wrote: > >> Thanks for the reply. The entire error string is "revdberr," (with the >> comma). I tried your suggestion of using revExecuteSQL instead of >> revDataFromQuery() and I did not get the error. So at least I have a >> suitable workaround. Thanks for the assist! >> > > I try to always check my results and trigger a "panic" that shows the > returned error when a query fails. > > For this one, I just take an exact match of "revdberr," as a success code. > So > > if theRes <> "revdberr" then > panic "bad delete in someFunction" & cr & cr & theRes > end if > > If you're *not* checking your return codes, you're asking for pain . . . > > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode