Hello,

mhh, the VFP9 help has a new section where all possible datatype conversions are listed ..

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.

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.

if all this should not work, i'll be really disappointed about Microsoft ..
they don't have any problem at all to support correct mapping between MS-SQL Server datatypes and VFP types, but on most other DBMS backends you'll have problems to support this or that datatype. and you must evaluate beforehand carefully what types are supported, if they are mapped correctly, if they update correctly etc. ..

if i were responsible for this, i would sit down a month deep diving into the whole scenario, setup a server with Oracle, MySQL, MsSQL, PostgreSQL, DB2, Informix, Paradox etc. for testing and solve this OLD problems (missing features) forever.
If one wanted to be accusingly he could argue that MS didn't solve this problems to 'slighty' force VFP developers using their SQL-Server as the DBMS.

Regards
Christian