mysql and anonymous db errors

Peter Haworth pete at lcsql.com
Mon Aug 27 17:05:35 EDT 2012


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 <andre at andregarzia.com> wrote:

> 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.
> _______________________________________________
> 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
>



More information about the use-livecode mailing list