Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Select expression for both VFP and SQL DB
Message
From
30/03/2019 14:18:44
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
30/03/2019 13:11:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01667660
Message ID:
01667762
Views:
41
>In the C language there were separate logical and bitwise AND, OR and NOT operators -- getting them confused would usually result in confusing results.
>
>Of course the potentially confusing thing about BIT would be that if truly implemented as a single-bit value, there can only be 0 or 1 values. However if you want to have NULL values, then it can't actually bit a single bit in implementation.

In VFP dbfs there's a hidden bitmapped field, in tables with at least one nullable field, which contain a 1 for every null in the fields, so technically the bit field is still as it was, but there's an extra bit outside, set when it's null. I guess other databases apply a similar scheme.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform