>mhh, the VFP9 help has a new section where all possible datatype conversions are listed ..
The only conversion listed which produces logical data is from SQL_BIT type.
Even when PostgreSQL returns .F. and .T. as character column values, it is
not possible to create a logical column without re-writing all select clauses manually.
>i don't know to which ODBC datatype the "boolean" type from PostgreSQL is mapped ... seems so it is not mapped to the SQL_BIT type .. otherwise it should work flawlessly.
It takes a lot of time for me to study driver source code. I tried official ODBC driver, installed with PostgreSQL 8 installation.
There are other ODBC drivers, maybe this problem is solved in some other.
It should be possible to patch PostgreSQL ODBC driver source code to force it to return SQL_BIT type .
Will PostgreSQL OLE Db provider work with VFP Cursoradapter ? Maybe this problem is solved in the OLE Db provider.
>i remember that i've read somewhere that in VFP9 it's also possible to map some numeric types (SQL_TINYINT,SQL_SMALLINT,SQL_INTEGER .. maybe more) to Logical fields .. though it's not mentioned anywhere in the VFP9 Beta help, but that maybe due to not finished documentation.
From which place you read this ?
I tried in VFP 9 beta to force returning numeric field to logical using the same sample, but the error is same.
Andrus