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