Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
More on logical field on VFP to SQL Server
Message
De
25/02/2008 19:51:39
 
 
À
24/02/2008 12:39:49
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01295881
Message ID:
01296293
Vues:
12
As surprisingly as it could get, I found out that the SQL Client provider is smart enough to recognize a Bit field or a Numeric(1,0) field to be parameterized with True or False. And, from a SQL result, such as in a datarow, using something like:
If loRow("Active") Then
   ...
End if
will work in both situations.

Well done!
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform