PRESS RELEASE
12th April 1997
RED is attending the FoxTeach Conference in Toronto, Canada as a vendor and speaker. The conference is arranged by Val Matison. Please contact him directly to book a place for this years conference.
The conference runs each year and is taking place over three days from 1-3 May 1997. Many speakers are scheduled to talk including:
Stamati Crook will be demonstrating the RED products at the conference as well as presenting two sessions. See you there !
This session is designed for delegates considering a move to a client server platform. An active demonstration of the major features of the SQL Server database management environment and the client-server features of Visual FoxPro form equal parts of the session.
The user interface of the SQL Server Enterprise Manager is explored during the creation of a client-server database. A table is created with fields, an index and default values. A primary key is then created and a referential integrity rule defined in the database. The process of defining a database with the SQL Enterprise Manager is compared and contrasted with the FoxPro database designer tool and some problems with upsizing noted.
Visual FoxPro remote views are the simplest way to access client server databases with Visual FoxPro. The advanced options of the FoxPro view designer are reviewed and properties set to optimise the performance of the view. The definition and use of a parameterised view to select a few records from a database is covered in detail.
Further server side implementation techniques are discussed and demonstrated to allow sophisticated data validation on the server using a Trigger programmed with the Transact-SQL programming language. A discussion of overall client-server design issues and the use of SQL passthrough and stored procedures running on the server concludes this technical overview.
This introductory session is designed for developers who are using the traditional FoxPro techniques of record locking in a multi-user environment and who need a demonstration of the Visual FoxPro techniques of data buffering.
Data buffering replaces the record locking and data scattering techniques employed for multi-user systems with previous versions of FoxPro. The technique is very flexible and can be employed on local and remote views as well as with standard FoxPro tables. Data buffering also allows for effective error trapping of validation rules stored in a database container.
The session introduces the concepts of row and table level buffering and focuses on the implementation of optimistic record locking. Validation rules are created in a database container and error trapping routines are implemented to demonstrate how these validation rule integrate with data buffering functionality.
The programming issues surrounding the error trapping process in a multi-user environment are fully discussed and the use of local views demonstrated. Relevant programming techniques are demonstrated throughout the session which is used to create a simple data manager class for controlling access to data.