Whether you create and upsize a working local prototype or develop your application against remote data using remote views, you gain access to the large data stores typically available in a server database. In addition, you can take advantage of the security and transaction processing capabilities of the remote server. While remote views handle the main data management tasks, you can enhance your application by using SQL pass-through (SPT) technology to create objects on the server, run stored procedures on a server, and execute commands using native server syntax.
The following topics discuss techniques for implementing client/server technology in a working application that uses remote views.
In This Section
- How to: Set Up an ODBC Data Source
- Describes how to install an ODBC driver and set up an ODBC data source so you can create remote views or use SQL pass-through.
- Using SQL Pass-Through Technology
- Describes how remote views provide the easiest and most common method for accessing and updating remote data. The upsizing wizards can create remote views automatically in your database as part of upsizing, or you can use Microsoft Visual FoxPro to create remote views after upsizing.
- Working with Remote Data Using SQL Pass-Through
- Explains that after you retrieve a result set using SQL pass-through, you can view and control the properties of your result set cursor using the Microsoft Visual FoxPro functions CURSORGETPROP(В ) and CURSORSETPROP(В ).
- Handling SQL Pass-Through Errors
- Explains that Microsoft Visual FoxPro stores an error returned by a SQL pass-through function error message in an array.