You could write a function to return a logical value from a logical or numeric value:

*******************
** Pass
** v - logical or numeric value
**
function logical
lparameter v
if vartype(v)=[N]
return (v>0)
else
return v
endif
endfunc

You'll have to do a global replace but it'll still work for both versions

>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?