Re: mysql and anonymous db errors

2012-08-27 Thread Peter Haworth
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

Re: mysql and anonymous db errors

2012-08-27 Thread Mark Wieder
Andre Garzia writes: > 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. "Prior to SQLite version 3.6.5, the truncate optimizatio

Re: mysql and anonymous db errors

2012-08-27 Thread Andre Garzia
On Mon, Aug 27, 2012 at 1:53 PM, Bob Sneidar 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 a

Re: mysql and anonymous db errors

2012-08-27 Thread Bob Sneidar
Whoa I just received a post that I sent. I thot that wasn't supposed to happen? On Aug 27, 2012, at 9:53 AM, Bob Sneidar wrote: > I think Peter is right. The result should be the number of rows affected if > successful. > > Bob > > ___ use-livec

Re: mysql and anonymous db errors

2012-08-27 Thread 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

Re: mysql and anonymous db errors

2012-08-26 Thread Dr. Hawkins
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 le

Re: mysql and anonymous db errors

2012-08-26 Thread Peter Haworth
What is the text after "revdberr"? 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. Wouldn't surprise me if using revDataFromQuery didn't work