RED Visual FoxPro SQL Server Handbook

This Handbook is an essential read for the experienced Visual FoxPro programmer beginning his or her first SQL Server project. Over 150 pages explain the principal technologies that must be mastered in order to create strong client-server applications with Visual FoxPro and SQL Server.

Practical explanations and examples are given with full notes on the use of graphical SQL Executive to create database objects directly on the server. The implementation of sever-side validation and processing is covered with implementation details for referential integrity and Rule and Trigger based validation as well as programming Stored Procedures using Transact-SQL.

The FoxPro chapters fully describe the use and optimisation of remote views. Examples of two chapters are available on this chapter with thanks to Val Matison who formatted the html for the FoxTeach conference. The sample chapters introduce data buffering and the SQL Enterprise Manager.

The Handbook costs £ 60 (US$ 90) and is available directly from RED on our order form.

Key Benefits

Get up to speed with SQL Server in Days.

All the information you need is located in one reference volume.

Hints and tips on performance and application design.

Contents

Part I Visual FoxPro

Views

• ODBC
• Connections
• View Designer
• View Properties

Data Buffering

• Specifying Data Buffering
• Saving Changes
• Reverting Changes
• Determining Updated Fields
• Determining Updated Records
• Error Handling
• Form and Data Environment Buffering Properties
• Offline Views

Optimising Remote Views

• ODBC Drivers
• Connection Optimisation
• Remote Views
• USE … NODATA … NOREQUERY
• Parameterised Views
• Commit and Rollback
• Setting Defaults

Pass Through Queries

• Asynchronous Mode
• Batch Mode
• SQL Pass Through and Data Buffering
• Preparing SQL Statements
• ODBC Extensions

Upsizing a FoxPro Database

• Upsizing to SQL Server
• Visual FoxPro Upsizing Wizard
• Upsizing Considerations
• Data Manipulation Language

Client-Server Application Design

• Performance Bottlenecks
• Parameterised Views
• Local Validations
• Transactions
• Pass Through Queries
• Stored Procedures
• Connections
• Server Side Cursors
• Remote Automation

Part II SQL Server Implementation

SQL Server Views

• Views
• Updatable Views
• Outer Join
• Temporary Tables
• Union
• Sub Queries

Triggers

• Trigger Program Structure
• Field Level Validation
• Record Level Validation
• Checking Values against another Table
• Preventing Changes to a Field
• Referential Integrity Checks
• Cascading Delete
• Updating another Table
• Error Messages

Stored Procedures

• Executing a Stored Procedure
• Passing Parameters
• Returning a Value
• Passing Parameters by Reference
• Variables
• CASE Expression
• Cursors
• System Procedures
• Extended Procedures
• Extended Mail Procedures

SQL Server Optimisation

• Query Optimisation
• Clustered Indexes
• Locking Issues

Part III SQL Server Administration

Security

• Implement Integrated Security
• Server Logins
• Database Users and Groups
• Database Object Permissions

Distributed Management Framework

• Table Object
• CREATEOBJECT…NEW Problem