Bob Sneidar <bobs@...> writes: > > I just tested this with a numeric column in mySQL. The column has NOT NULL unchecked and the default value set > to NULL. When I updated from LC setting the column to NULL that is the value that the column was set to. > HOWEVER if I updated the column with an empty string, I got 0 just as you say. We good so far? Okay. > > So I wanted to see what would happen if I bypassed LC altogether and did the same updates in a mySQL utility. I > got THE EXACT SAME RESULTS!!! When I updated a numeric column with an empty string, I got the number 0. What > does this all mean? It means that LC is NOT borking the update. It is just the way SQL reacts when you send an > empty string to a numeric field! > > They only real issue left is that LC converts a NULL value to an empty string in it's queries for the reason I > explained, that LC abhors an ASCII 0 in a string. I hope I have made this clear now. I have screen snapshots to > verify my results if you would like me to send them to you off list.
What happens if you use numtochar(0) instead of NULL or an empty string? -- Mark Wieder _______________________________________________ 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
