FoxPro Client Server Handbook

FoxPro Client Server Handbook

This book is now available online.

This 64 page book is an essential guide for Visual FoxPro programmers implementing client-server applications and has been updated for Visual FoxPro 7.0. The table of contents is shown below. Please contact us if you need a hard copy reprint.

TUTORIAL
Create a Connection 6
Create a Remote View 6
Updating Data 7
Table Buffering 7
Using Parameterised Remote Views 7
Executing a Stored Procedure 8
Creating a client-server Form 8
Summary 10

CONNECTIONS 
ODBC 11
ODBC String Connection 11
ODBC Data Source Administrator 12
ODBC Performance Tips 13
CREATE CONNECTION 14
CONNECTION DESIGNER 14
Data Source 15
Data Processing Options 15
Asynchronous Connections 16
TimeOut Intervals 16
Connection Properties 16

REMOTE VIEWS
VIEW DESIGNER 18
Creating a Remote View 18
Fields 19
Filter 20
Join 21
Order By 22
Group By 22
Update Criteria 23
PARAMETERISED VIEWS 25
CREATE SQL VIEW 26
VIEW PROPERTIES 27
OPTIMISING REMOTE VIEWS 28
Shared Connections 28
Update Criteria 28
Advanced Options 29
Remote View Properties 30
Recommended Settings 31
WORKING WITH REMOTE VIEWS 31
PARAMETERISED VIEWS 32

 

DATA BUFFERING
SPECIFYING DATA BUFFERING 34
SAVING CHANGES 35
REVERTING CHANGES 36
DETERMINING UPDATES 36
ERROR HANDLING 38
FORM AND DATA ENVIRONMENT BUFFERING PROPERTIES 39
COMMIT AND ROLLBACK 40
SETTING DEFAULTS 41
OFFLINE VIEWS 42

SQL PASS THROUGH
Asynchronous Mode 45
Batch Mode 45
SQL PASS THROUGH AND DATA BUFFERING 46
PREPARING SQL STATEMENTS 47
ODBC EXTENSIONS 48
STORED PROCEDURES 49

CLIENT-SERVER APPLICATION DESIGN
PERFORMANCE BOTTLENECKS 50
PARAMETERISED VIEWS 50
LOCAL VALIDATIONS 51
TRANSACTIONS 52
STORED PROCEDURES 52
SQL PASS THROUGH 52
CONNECTIONS 53
MICROSOFT TRANSACTION SERVER 53

DATABASE MAINTENANCE
UPSIZING A FOXPRO DATABASE 54
Visual FoxPro Upsizing Wizard 54
Upsizing Considerations 58
DATA MANIPULATION LANGUAGE 60
CREATE TABLE 61
ALTER TABLE 62
CREATE INDEX 62
GENDBC.PRG 62

 

23/06/2017 07:43:50