>>Hi,
>>
>>When in my code the Tableupdate() fails (when updating a table in SQL Server database) I get the error using AERROR(aErrorInfo). The VFP 9 help on AERROR says that the element 4 of the array will have "Character. The current ODBC SQL State" What would be an example of such a value? I am trying to see if saving/capturing the value of this element 4 is useful. Also, element 3 says "Character. The text of the ODBC error message". Is this different from element 2 "The text of the error message"?
>
>To answer your second question first, yes, they're different, but not a lot. In my experience, element 2 gives you the same string as element 3, but preceded by "Connectivity error: " That's with SQL Server.
>
>As for element 4, http://msdn.microsoft.com/en-us/library/ms131387.aspx.
>
>Tamar

Thank you for your help. I was hoping that at least one of these elements would show me the actual values user entered that triggered the problem (in my case it is mostly the foreign key constraint violation).