Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>It's interesting to see all the different solutions that people are recommending. However, NOTHING will work. Since you say this is a legacy table, you can only get two values. .T. and .F.
>
>It's not totaly true. In the browse you can see T, F and empty values in the logical field. ISBLANK() function would return .T. for the empty values on record per record processing. Unfortunatelly, it doesn't work properly in SQL Select.
A logical can only store 0 or 1. Having a "blank" value doesn't make sense. The ISBLANK() function IMO is the one that's not working properly. I agree with Craig that the only way to get another value is to have the field be NULL. Again, IMO.....
Tom
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement