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.
Modification Type: | Major | Last Reviewed: | 12/1/2003 |
---|
Keywords: | kbprb KB160912 |
---|
|