>I am using API Functions which will in turn calls the MSSQL functions. I am trying to return the error code of the SQL function to a local VFP variable. I am getting am 8 gidit value. How can I get the actual SQL Error code to the stored in to a VFP variable.
Have you looked at the AERROR() function?
AERROR( laError )
will create an array called laError. I think that laError[1,4] is the ODBC error, if any, and laError[1,5] is the SQL Server error.
Chris McCandless
Red Sky Software