Anomoly when storing empty values into SQLite integer fields

Pete pete at mollysrevenge.com
Wed Feb 22 12:43:19 EST 2012


No problem Mark.  I've come across other anomalies in the way LC handles
databases over the last few months.

The bug report numbers are 10022 for the empty/zero problem and 10023 for
the incorrect handling of the reserved keyword NULL.

Pete

On Wed, Feb 22, 2012 at 7:07 AM, Mark Smith <Mark_Smith at cpe.umanitoba.ca>wrote:

> Peter, very cool. I'm going to have fun with that one. LC is very powerful
> at
> times. Oh, and thanks for posting to the bug list. While it is possible
> that
> RR will say this behavior conforms to a particular standard and you just
> have to code for it (as you have below) its still way, way to much work for
> a supposed high level rapid application development environment. My 2 cents
> anyway.
>
> Cheers,
>
> -- Mark
>
>
> Peter Haworth-2 wrote
> >
> > Hi Mark,
> > I think this may not be difficult.  Turns out you can use an array with
> > numbered keys instead of a list of variables with revExecuteSQL, so
> here's
> > some code ( completely untested)
> >
> > put 1 into x
> > put "UPDATE test SET " into mySQL
> > repeat for each item myField in "One,Two,Three"
> >    if field myField is not empty then
> >       put myField & "=:" & x & comma after mySQL
> >       put field myField into myArray[x]
> >       add 1 to x
> >    end if
> > end repeat
> > put space into char -1 of mySQL
> > put "where ID=" & tID after mySQL
> > revExecuteSQL gConnectID, mySQL, myArray
> >
> > Shouldn't be too hard to generalise it as a command/function if
> necessary.
> >
> >
>
>
> --
> View this message in context:
> http://runtime-revolution.278305.n4.nabble.com/Anomoly-when-storing-empty-values-into-SQLite-integer-fields-tp4408942p4410631.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
>
> _______________________________________________
> 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
>
>


-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>



More information about the use-livecode mailing list