Handling SQL Pass-Through Errors

  • Article

If a SQL pass-through function returns an error, Visual FoxPro stores the error message in an array. The AERROR( ) function provides information about errors that are detected in any of the component levels: Visual FoxPro, the ODBC data source, or the remote server. By examining the values returned by AERROR( ), you can determine the server error that occurred and its error message text.

Caution   You must call AERROR( ) immediately to obtain error information. If you generate any other error before you call AERROR( ), the error information is lost.

See Also

Data Type Conversion Control | Processing of Multiple Result Sets | Working with Remote Data Using SQL Pass-Through | Implementing a Client/Server Application | Designing Client/Server Applications | Upsizing Visual FoxPro Databases | Creating Views