Thank you.
Are you sure that
DBSetProp('mytable.mylogicalfield', 'Field', 'DataType', "L")
works in VFP 9 ?
I tried it in VFP 9 beta but still got this error.
>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 ?
Andrus