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_sm...@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@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> _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
