Microsoft KB Archive/143002

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

Article ID: 143002

Article Last Modified on 3/14/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q143002



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:

Csexamp.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. 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 Author 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: kbinfo kbsqlprog kbserver kbdatabase kbfile kbsample kbclientserver KB143002

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.