>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.