PRB: SQL Server Table Bit Field Requires Value of 0 or 1

MORE INFORMATION

Steps to Reproduce Behavior

1. Set up an ODBC data source to the Pubs database in SQL Server if you do not have one already. Use the following steps:
   
   
   1. Open the 32-bit ODBC or ODBC program item icon in the Control Panel (These apply to Windows 95 and Windows NT, respectively).
   2. In the Data Sources dialog box, click Add.
   3. In the Add Data Sources dialog box, select SQL Server from the Installed ODBC Drivers list, then click OK.
   4. In the ODBC SQL Server Setup dialog box. Add a Data Source Name. Note the name you assign it, as you will need it later. Type in or select your server name in the Server combo box. Select the Options button, and under Database Name, type in 'pubs' (without the quotes). Click OK to save the settings.
   5. Click Close from the Data Sources dialog box.
2. Create a database in Visual FoxPro. Open this database in the Database Designer.
3. Create a new Remote View by right-clicking in the Database Designer and selecting New Remote View from the context menu. Select the New View button.
4. In the Select Connection or Data Sources dialog box, select the "Available data sources" option button. Select the Data Source Name (from step 1d) from the "Available data sources" list, then click OK.
5. The SQL Server Login dialog box appears. Enter the correct Login ID and Password for your server, and click OK.
6. The Open dialog box appears. Select the Authors table, click the Add button, and then the Close button.
7. In the Remote View Designer, select the Add All button on the Fields tab.
8. Right-click in the View Designer, and select Run Query. Look at the contents of the Contract field--it contains T or F, indicating this is a field of bit data type.
9. Select the Filter tab, and click in the Field Name box. Select Authors.contract from the drop-down list. In the Example box, type .T., then right-click in the Remote View Designer, and select Run Query. The following error occurs:
   Connectivity error: [Microsoft][ODBC SQL Server Driver]
   [SQL Server]Line 1: Incorrect syntax near '.'.
10. Change the Example from .T. to 1, and right-click in the Remote View Designer, and select Run Query. The browse displays records with Authors.contract containing T.