Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical Data Type in SQL Server 7
Message
From
18/10/2001 11:12:55
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00570235
Message ID:
00570273
Views:
20
>No, there is no logical type data in Sql Server. The best data type to use is Tinyint ( 1 byte, range 0-255) with values 1-true and 0-False. This way you can bind it directly to VFP checkbox. There is also Bit data type that stores 8 bit per byte but it's hard to use. Still it's usefull if you have a lot of logical fields per record.

How are the bit fields hard to use? I use them for logical data and I have found it to work perfectly, and they bind to VFP checkboxes without problem.
Sylvain Demers
Previous
Reply
Map
View

Click here to load this message in the networking platform