Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Do ORACLE have logical field????
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00368057
Message ID:
00368262
Vues:
16
>>VFP treats it as a numeric. I don't do anything special. I use checkboxes for logicals, so the values of 0 and 1 work with checkboxes without any data conversion. As for data retrievals, I just have to specify WHERE MYFIELD = 1.
>
>The problem we are facing is in our setup tables, ie race, we have a logical field Inactive. We create an array where not inactive. ComboBoxes display valid values from the array.
>
>Any suggestions on how to get VFP to think that the field is a logical in the remote view?

No. Why can't you use SELECT ... WHERE Inactive = 0 ?

You could do a SELECT ... iif(Inactive = 1, .t., .f.) as Inactive from ...

But how are you going to update the values in Oracle? You are going to be better off just going with the N/1 datatype.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform