Enhancing Applications Using SQL Pass-Through Technology

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.

Related Sections

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 Applications

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.

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.

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.

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic