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

Read Data Type Conversion Control on VFP9 Help


In Visual FoxPro 9.0, certain ODBC and ADO data types can be mapped
to a logical data type in remote views and the CursorAdapter object.


Fabio