Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical Data Type in SQL Server 7
Message
 
 
To
18/10/2001 10:25:03
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00570235
Message ID:
00570248
Views:
22
>Hello,
>
> Can anyone please tell me the equivalent to a logical in SQL Server 7.0? Is there a logical field type in SQL Server 2000?
>
>Thanks
>
>Jim

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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform