Enhancing Applications Using SQL Pass-Through Technology

  • 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.

The following topics discuss techniques for implementing client/server technology in a working application that uses remote views.

In This Section

  • Setting 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.
  • Using Visual FoxPro
    Describes Visual FoxPro programming features designed to improve developer productivity, including Access and Assign methods, support for more graphic file formats, and language to simplify programming tasks.
  • Developing Visual FoxPro Applications
    Includes conceptual information about how to develop Visual FoxPro applications, instructions for creating databases and the user interface, and other tasks needed to create Visual FoxPro applications.
  • Application Planning
    Describes how careful planning saves time, effort, and money and how many of the decisions you make during the planning phase will impact how you create elements of the application.
  • Creating the Application
    Discusses how to create a Visual FoxPro application, which may include one or more databases, a main program that sets up the application's system environment, and a user interface comprised of forms, toolbars, and menus.
  • Creating Web Services and Components
    Explains how you can extend your Visual FoxPro application to work for multiple users, and take advantage of Microsoft ActiveX controls and automation-enabled applications.
  • Working with Data
    Describes how to create effective applications with indexes, tables, and databases based on your data requirements.
  • Working with Projects
    Defines a project a configuration and a group of files that produce a program or final binary file or files.
  • Creating Help
    Describes how you can include Help files in your application to provide valuable information for users of your application.
  • Compiling an Application
    Explains how to use the modular approach so you can verify the functionality of each component you create before you compile them into an application, which assembles the executable components of your project.
  • Testing and Debugging Applications
    Describes Visual FoxPro debugging tools that help you find and correct any errors you discover in your applications.
  • Distributing Applications
    Explains how to prepare to distribute your application by including all required files and creating distribution disks, after you have completed developing and testing your application.