Contents

Contents

1.       Objectives

2.       Tutorial

Create a Connection

Create a Remote View

Updating Data

Table Buffering

Using Parameterised Remote Views

Executing a Stored Procedure

Creating a client server Form

Create a Cursor with the CursorAdapter Object

Summary

3.       Connections

ODBC Open DataBase Connectivity

ODBC String Connection

ODBC Data Source Administrator

ODBC Performance Tips

Connection Designer

Data Source

Data Processing Options

TimeOut Intervals

CREATE CONNECTION

Programming Connections

Connection Properties

Setting Defaults

Asynchronous Connections

4.       Remote Views

View Designer

Creating a Remote View

Fields

Filter

Join

Order By

Group By

Update Criteria

Parameterised Views

CREATE SQL VIEW

View Properties

Shared Connections

Update Criteria

Working with Remote Views

Parameterised Views

5.       CursorAdapter Class

CursorAdapter

Using parameters to filter data

Updating data

CursorAdapter Event Model

Attaching an Existing Cursor

Using the CursorAdapter Builder

Building a CursorAdapter with cabuilder.prg

Using CursorAdapter Objects in a Form

6.       Data Buffering

Specifying Data Buffering

Saving Changes

Reverting Changes

Determining Updates

Error Handling

Commit and Rollback

7.       Form and Data Environment Properties

8.       Optimising Views and CursorAdapters

Advanced Options

Remote View Properties

Recommended Settings

9.       SQL pass-through

Asynchronous Mode

Batch Mode

SQL Pass Through and Data Buffering

Preparing SQL Statements

ODBC Extensions

Stored Procedures

10.     Offline Views

11.     Client-Server Application Design

Performance Bottlenecks

Parameterised Views

Local Validations

Transactions

Stored Procedures

SQL Pass Through

Connections

Microsoft Transaction Server

12.     Database Maintenance

Upsizing a FoxPro Database

Visual FoxPro Upsizing Wizard

Upsizing Considerations

Data Manipulation Language

CREATE TABLE

ALTER TABLE

CREATE INDEX

GENDBC.PRG