Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do ORACLE have logical field????
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00368057
Message ID:
00368262
Views:
17
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform