mysql and anonymous db errors

[Bob Sneidar]

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
> HawkinsLawFirm at gmail.com
> 3025 S. Maryland Parkway
> Suite A
> Las Vegas, NV  89109
> _______________________________________________
> 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