revDataFromQuery and DELETE FROM

[Bob Sneidar]

I just put all calls to database functions inside a try/catch construct. 

Bob S


On Aug 20, 2014, at 15:09 , Dr. Hawkins <dochawk at gmail.com> wrote:

> On Sun, Aug 17, 2014 at 8:33 PM, Dan Friedman <dan at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode