I think Peter is right. The result should be the number of rows affected if successful.
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
