Anomoly when storing empty values into SQLite integer fields

Mark Smith Mark_Smith at cpe.umanitoba.ca
Tue Feb 21 22:19:07 EST 2012


Peter Haworth-2 wrote
> 
> Yes, it causes a headache, you're right.  You would have to  build the
> UPDATE command in a variable by examining each field for empty and adding
> it to the variable list if not empty.  Don't have time to give some
> example
> code right now, but will try to do something tomorrow.
> Pete
> 

Thats ok, thats enough of a hint... I can work something up from there. If
fld"one" is not empty then
    put "some string" after "the string I'm trying to build"
should do it.

Thanks

-- M

--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/Anomoly-when-storing-empty-values-into-SQLite-integer-fields-tp4408942p4409145.html
Sent from the Revolution - User mailing list archive at Nabble.com.




More information about the use-livecode mailing list