I have a text field in the sql table.
In vfp6, I've got a form with an edit box for the user to input a long string of data. Then I use SPT to Insert or Update the SQL Table. As long as the text in the edit box is only about 20 characters long or less, it works great. But other than that the sqlexec() statement returns -1 with the following error message:
"Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated."
Any help greatly appreciated.
P.S. I don't know if it matters, but on the form I store the text in a form variable and the form variable is the control source for the edit box. I then pass that form variable in the Insert/Update statement.
Thanks
Kirk