On Mon, Aug 27, 2012 at 1:53 PM, Bob Sneidar <[email protected]> wrote: > I think Peter is right. The result should be the number of rows affected > if successful. >
It depends, on 5.5.1 I am receiving back 0 from RevExecuteSQL with a DELETE call that removes 12 records on a SQLite database... then in this case 0 apparently means success and not the amount of records deleted. > > Bob > > > On Aug 26, 2012, at 11:52 AM, Dr. Hawkins wrote: > > > On Sunday, August 26, 2012, Peter Haworth wrote: > > > >> What is the text after "revdberr"? > > > > > > That's why I called it an anonymous error--there *is* no more. > > > >> I notice that you mentioned INSERT and UPDATE along with > revDataFromQuery. > >> You should be using revExecuteSQL to do INSERTs and UPDATEs, at least > >> theoretically, as there is no data from an INSERT/UPDATE. > > > > > > with sqlite, I was getting either empty for success, and the error > message > > as the result if thre was an error. > > > > > > > >> > >> Wouldn't > >> surprise me if using revDataFromQuery didn't work quite as expected for > >> anything other than SELECT statements since the SQLite internal > statements > >> to execute an INSERT/UPDATE or a lot different than executing a SELECT. > > > > > > I'll try swapping the statement and see if I get the same thing in the > > result. > > > > the statements are apparently successful, though, in spite of the erro. > > > > > > -- > > The Hawkins Law Firm > > Richard E. Hawkins, Esq. > > (702) 508-8462 > > [email protected] > > 3025 S. Maryland Parkway > > Suite A > > Las Vegas, NV 89109 > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- http://www.andregarzia.com -- All We Do Is Code. http://fon.nu -- minimalist url shortening service. _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
