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.
Additional query words: vfoxwin kbdse
Keywords: kbprb KB160912