Microsoft KB Archive/160912

= PRB: Remote View to SQL Server with Logical Values =

Article ID: 160912

Article Last Modified on 12/1/2003

-

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 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.



Steps to Reproduce Behavior

 * 1) Open a Database Container with the command MODIFY DATA.
 * 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.

Additional query words: vfoxwin kbdse

Keywords: kbprb KB160912

-

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

© Microsoft Corporation. All rights reserved.