In VFP9 they have added native support for this type of mapping to Logical fields.
In VFP8 you could use cursoradapter and do the conversion by doing something like this after each query:
SELECT IIF(lField=0,.F.,.T.) as lField FROM cTable INTO CURSOR NEWTABLE READWRITE
oCA.CursorDetach()
USE IN SELECT("cTable")
SELECT * FROM NEWTABLE INTO CURSOR cTable READWRITE
oCa.CursorAttach("cTable",.F.)
>I have logical field in my table.
>I want to upsize this data to Firebird SQL server and use remote view
>for this data.
>
>Firebird SQL does not have bit data type.
>So I upsized my logical field as NUMERIC(1) data type to Firebird .
>
>I want to create a remote view or cursoradapter having logical data type column.
>For this, I tried to force VFP to convert it back to logical field:
>
>
DBSetProp('mytable.mylogicalfield', 'Field', 'DataType', "L")
>
>Unfortunately, this causes error
>
>Type conversion required by the DataType property for field 'mylogicalfield' is invalid.
>
>How to force VFP to create logical fields in remote views in Firebird ?