>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