Share via


Handling SQL Pass-Through Errors

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.

Warning

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

Concepts

Data Type Conversion Control

Processing Multiple Result Sets

Working with Remote Data Using SQL Pass-Through

Other Resources

Enhancing Applications Using SQL Pass-Through Technology

Planning Client/Server Applications

Upsizing Visual FoxPro Databases

Creating Views