Csexamp.exe - Client-Server Data Entry Screen for SQL

ID: Q143002

The information in this article applies to:

Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 6.0

SUMMARY

Csexamp.exe is a sample providing two files, Client.sct and Client.scx, that offer a demonstration of creating a basic data-entry screen that works against a SQL Server back end.

MORE INFORMATION

The following file is available for download from the Microsoft Download Center. Click the file name below to download the file:

Csexamp.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center. The form does not cover all possible error conditions that you may encounter but it does handle the process of logging on to SQL Server, establishing a handle, and allowing entry of data to the Authors table.

The Authors table was used because it has a primary key constraint on the Auth_ID field, and it also requires that some additional conversion work be done to the data that is passed through to SQL Server. The field that requires this conversion is the Contract field, which is defined as a SQL Server field type of 'bit.' All code has been thoroughly commented explaining how and why things were done in a specific fashion. You must have an ODBC data source to SQL Server 6.x, and you will also need to edit the connection code found in the form's Load event.

Additional query words: client server structured query language

Keywords : kbfile kbsample KbClientServer kbDatabase kbServer kbSQL kbVFp300 kbVFp500 kbVFp600
Version : WINDOWS:3.0,3.0b,5.0,6.0
Platform : WINDOWS
Issue type : kbinfo