Implementing a Client/Server Application

  • Article

Whether you have created and upsized a working local prototype or developed your application against remote data using remote views, you have gained 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 server stored procedures, and execute commands using native server syntax.

This section discusses techniques for implementing client/server technology in a working application that uses remote views.

In This Section

  • Using SQL Pass-Through Technology
    Remote views provide the most common and easiest 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
    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
    If a SQL pass-through function returns an error, Microsoft® Visual FoxPro® stores the error message in an array.
  • Creating Client/Server Solutions
    Client/server applications combine the functionality of Microsoft® Visual FoxPro® on your local computer with the storage and security benefits provided by a remote server.
  • Client/Server Application Design
    Building on multi-user development technologies, learn how to design a powerful client/server application.
  • Upsizing Visual FoxPro Databases
    Creating local prototypes of your design can reduce development time and costs. When you have a tested local prototype, it is easy and beneficial to upsize your application, so it can take advantage of all the features provided by the remote server.
  • Client/Server Performance Optimization
    After upsizing and implementing, you can take additional steps to optimize the performance of your application. Find out what you can do in Microsoft® Visual FoxPro® and on the remote server to optimize your client/server application.