mysql and anonymous db errors

[Andre Garzia]

On Mon, Aug 27, 2012 at 1:53 PM, Bob Sneidar <bobs at 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
> > 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
>
>
> _______________________________________________
> 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
>



-- 
http://www.andregarzia.com -- All We Do Is Code.
http://fon.nu -- minimalist url shortening service.