Anomoly when storing empty values into SQLite integer fields
Mark_Smith at cpe.umanitoba.ca
Tue Feb 21 21:19:07 CST 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
> code right now, but will try to do something tomorrow.
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.
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