VFP limit for a string is 16Mb so it cannot be a reason for truncating character array items. If truncation occurs, most likely ODBC driver is responsible.
>According to VFP help, when an odbc error occurs, the array generated by aerror contains two or more rows. I have only seen one row. I wonder what odbc error will return 2 rows.
>
>For some odbc errors, the error message is very long and get truncated since the 2nd and 3rd elements are character which can only hold 255 characters each. How can I get the entire error message?
>
>I'm using VFP 8 SP1 and MS SQL Server 7 and 2000.
>
>
>Thank you for any help.
--sb--