Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem working with logical field in SQLServer
Message
 
 
À
09/04/2007 09:55:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01213419
Message ID:
01213424
Vues:
12
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform