Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
More on logical field on VFP to SQL Server
Message
From
25/02/2008 19:51:39
 
 
To
24/02/2008 12:39:49
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01295881
Message ID:
01296293
Views:
10
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
Previous
Reply
Map
View

Click here to load this message in the networking platform