Re: revDataFromQuery and DELETE FROM

Works so long as you are certain the affected rows will never be 0. Bob S On Aug 20, 2014, at 15:16 , Ralph DiMola mailto:rdim...@evergreeninfo.net>> wrote: Using the revExecuteSQL returns the number of deleted/inserted/updated rows in the result. Then the test is: If the result is not a numb

Re: revDataFromQuery and DELETE FROM

I just put all calls to database functions inside a try/catch construct. Bob S On Aug 20, 2014, at 15:09 , Dr. Hawkins wrote: > On Sun, Aug 17, 2014 at 8:33 PM, Dan Friedman > wrote: > >> Thanks for the reply. The entire error string is "revdberr," (with the >> comma). I tried your sugge

RE: revDataFromQuery and DELETE FROM

: revDataFromQuery and DELETE FROM Yes, but there is no "panic" here it's a false error seemingly caused by using revDataFromQuery for something other than a SELECT statement. I know it shouldn't do that and that you have a bug at the QCC about it but bottom line is, using revDataFromQuery

Re: revDataFromQuery and DELETE FROM

Yes, but there is no "panic" here it's a false error seemingly caused by using revDataFromQuery for something other than a SELECT statement. I know it shouldn't do that and that you have a bug at the QCC about it but bottom line is, using revDataFromQuery or revQueryDatabase to execute anything ot

RE: revDataFromQuery and DELETE FROM

-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Dr. Hawkins Sent: Wednesday, August 20, 2014 6:09 PM To: How to use LiveCode Subject: Re: revDataFromQuery and DELETE FROM On Sun, Aug 17, 2014 at 8:33 PM, Dan Friedman wrote: > Thanks for the reply. The entire error string

Re: revDataFromQuery and DELETE FROM

On Sun, Aug 17, 2014 at 8:33 PM, Dan Friedman 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. Thank

Re: revDataFromQuery and DELETE FROM

Or use sqlYoga! ;-) Bob S On Aug 18, 2014, at 02:43 , John Craig wrote: > Peter's correct - use revExecuteSQL since no records are returned > > > On 17/08/2014 19:20, Peter Haworth wrote: >> Hi Dan, >> What is the text after "revdberr"? >> >> Strange that the row is being deleted but here's

Re: revDataFromQuery and DELETE FROM

Peter's correct - use revExecuteSQL since no records are returned On 17/08/2014 19:20, Peter Haworth wrote: Hi Dan, What is the text after "revdberr"? Strange that the row is being deleted but here's a couple of things that come to mind. You've probably already checked that tTableName and ent

Re: revDataFromQuery and DELETE FROM

Pete, 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! - Dan > Hi Dan, > What is the tex

Re: revDataFromQuery and DELETE FROM

On Sun, Aug 17, 2014 at 2:33 PM, Peter Haworth wrote: > I remember that but wasn't it something to do with multiple SQL statements > in one call? Could be the same issue I guess. > I want to say that it's any delete from in-memory mySQL, but my memory is fuzzy. -- Dr. Richard E. Hawkins, Esq

Re: revDataFromQuery and DELETE FROM

I remember that but wasn't it something to do with multiple SQL statements in one call? Could be the same issue I guess. Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Sun, A

Re: revDataFromQuery and DELETE FROM

On Sun, Aug 17, 2014 at 11:20 AM, Peter Haworth wrote: > What is the text after "revdberr"? > THere is a known issue of livecode returning a bare "revdberr" (i think there's a comma; I'd have to check) on certain types of successful transactions. Its been repeatable for me; my error checks look

Re: revDataFromQuery and DELETE FROM

Hi Dan, What is the text after "revdberr"? Strange that the row is being deleted but here's a couple of things that come to mind. You've probably already checked that tTableName and entryID contain valid information but one other thing to check is if the tablename includes any special characters

revDataFromQuery and DELETE FROM

Hello, Can anyone tell me why this results in "revdberr"? put "DELETE FROM" && tTableName && "WHERE entryID=" & entryID into tSQL put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData What's interesting is that the record is being removed from the database. So it's all working server s