PRB: Remote View to SQL Server with Logical Values (160912)



The information in this article applies to:

  • Microsoft Visual FoxPro for Windows 3.0
  • Microsoft Visual FoxPro for Windows 3.0b
  • Microsoft Visual FoxPro for Windows 5.0
  • Microsoft Visual FoxPro for Windows 6.0

This article was previously published under Q160912

SYMPTOMS

When you try to create a Remote View and try to filter based on logical .T. or .F., the following error could occur:
Connectivity error:[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '.'.

CAUSE

SQL Server stores logical values as 1 or 0.

RESOLUTION

Under the filter tab of the Remote View place a 1 or 0 for the Example criterion. If the desired records would contain .T. place a 1, and if .F. place a 0.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open a Database Container with the command MODIFY DATA <dbc name>.
  2. Right-click in the Database Designer and select New Remote View.
  3. Select New View from the resulting dialog box and select a SQL Server Data Source from either the Connections or Available Data Sources.
  4. Select a table from the SQL Server database that has a logical field.
  5. Add all of the fields to the Selected fields.
  6. Select the Filter tab. Under Field name, choose the logical field.
  7. For the Criteria choose "Like" and under Example, enter ".T.".
  8. Run the Query and note that the error appears. By simply changing the ".T." to the number "1," you enable the query to perform correctly.

Modification Type:MajorLast Reviewed:12/1/2003
Keywords:kbprb KB160912