With an SQLite database in memory, and a "real" database either on machine or remote, I need to sync the two.
I'm trying to find a clever & fast way to create a SELECT query that produces the corresponding UPDATE query. I can do something like "SELECT " & 'UPDATE sometable SET col1=''" & col1 & "'' WHERE key=''" & keyval & "'';" WHERE key =' & keyval & "';" to return UPDATE sometable SET col1='thevalue' WHERE key='keyval'; but this doesn't accommodate NULL values, which would come back as empty but need to become NULL rather than '' I suppose I could do a replace "''" with "NULL" in myQuery --for null strings replace ",," with ",NULL," in myQuery --for null numbers (and,f or that matter, null strings don't matter much. Am I on to something, or am I missing something big here? -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ 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
