>We have a large application in FoxPro 6.0 that uses both FoxPro DBC and MS SQL as the backend database.
>
>We are looking to port the application to an Oracle 8i database. We've used several logical fields (datatype bin in MS SQL) in the application. When upsizing the database to Oracle the datatype is set to NUMBER(1) in Oracle.
>
>Apparently, Logical/Bit datatype is not supported in Oracle.
>
>Is there any other solution other than making global changes to the FoxPro application?
How do you access the remote data?
If you are using views, you should be able to change the data type of the logical fields in the views to "L" with DBSETPROP().
Then the view would handle the conversion (1=.t., 0=.f.)
I don't have Oracle to test, but I believe that's the way it's supposed to work.
If you do have to make changes in VFP, I would make it in code to make a False check be
Empty(field)
and a True check to be
Not Empty(field)
. Then you don't have any conditional programming to do.
Insanity: Doing the same thing over and over and expecting different results.