Hi Andre, I'm not seeing that here. I just tried it out with sqlite and revexecuteSQL gave me the number of deleted rows, not zero. This is on LC 5.5.1 and OSX Lion. I think it does return zero for anything other than INSERT/UPDATE/DELETE statements - could there be another revexecuteSQL call in your code getting ion the way? Pete lcSQL Software <http://www.lcsql.com>
On Mon, Aug 27, 2012 at 1:11 PM, Andre Garzia <an...@andregarzia.com> wrote: > On Mon, Aug 27, 2012 at 1:53 PM, Bob Sneidar <b...@twft.com> 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 > > > hawkinslawf...@gmail.com > > > 3025 S. Maryland Parkway > > > Suite A > > > Las Vegas, NV 89109 > > > _______________________________________________ > > > 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 > > > > > > -- > http://www.andregarzia.com -- All We Do Is Code. > http://fon.nu -- minimalist url shortening service. > _______________________________________________ > 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
