Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select expression for both VFP and SQL DB
Message
De
30/03/2019 14:18:44
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
30/03/2019 13:11:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01667660
Message ID:
01667762
Vues:
42
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform