The database is DB2 on an AS/400 and it has a smallint (-32,000 to 32,000 range Integer) but no BIT or Logical type.


You have try with a Remote View and declare the VFP field logical type ?

AFAIK, If this fail, you cannot gain this conversion at VFP ODBC level.