>>>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.
Mark McCasland
Midlothian, TX USA