>>>Hi all,
>>>Let's say that we have several Logical fields in our VFP application and we are upsizing to Oracle. Is there a Best Practice to handle this considering Oracle does not have a logical datatype?
>>
>>I am not sure about Oracle, but when I need logical field in SQL Server I use bit type (I am not sure if there is such type in Oracle, but there must be somethinbg similar). When I use CA it comes as logical field in VFP cursor.
>
>Thank you Borislav. I wish we have the option to use SQL Server; our client requires Oracle.
As Martin suggested use NUMERIC(1) and use CursorSchema to map this field to be logical.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.