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