Re: numric data truncated

[Grigore Dolghin]

Hi. Your way to do it is not exactly right. What happens if A3 contains "O'Hara"? I tell you what will happen: you'll get synthax errors because of the inner apostrophe.

The right way to do it is to use a variable prefixed with "?". Your code should look like this:

=SQLExec(Nc, "Insert Into MyTable(X1,X2,X3,X4);
VALUES (?A1, ?A2, ?A3, ?A4)

Tis should take care of everything (unless the table doesn't really accomodate the values, such as sending 6 into a TINY field).