Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem working with logical field in SQLServer
Message
 
 
To
09/04/2007 09:55:03
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01213419
Message ID:
01213424
Views:
11
SQL Server doesn't have logical data type. Anyway your problem is not with the column type but with the column name. 'OPEN' is reserved word in SQL Server and as such has to be enclosed in square brackets. I'm not sure how it should be handled in the remote views.

>I am trying to access a field in a SQLServer database that is of type "L".
>
>The field's name is OPEN. If I read the table using * to select all records, I have no problems; the field in the cursor shows up as logical.
>
>However, if I try to list the field name explicitly in my list of fields ("Select TransferNumber, open") or use it in a WHERE clause ("Select * Where OPEN"), I get an error code back.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform