>>>>We have an application origionaly developed in VFP 6 and are converting it to a Client/Server application. In VFP there are LOGICALS which relate to BIT in SQL Server 7. What would be the equevelant in ORACLE 8.
>>>>
>>>>The problem is when the Remote View is Created a field is being checked for True or False. This can be done in FVP or SQL. How can or should this be done with ORACLE.
>>>>
>>>>Thanks
>>>
>>>Oracle has no logical field type. I use a numeric field of width 1 and use 0 or 1 for the values.
>>
>>When you create a Remote View how does VFP treat the field? As a Numeric or a Logical? If it is treated as a Numeric what can be done for VFP to recognize it as a Logical?
>
>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?