Hello,
if I remember correctly the ODBC driver returns 0 as the display size of a column with type XML.
run a ODBC trace and look for:
SQLColAttribute - SQL_DESC_DISPLAY_SIZE (or SQL_COLUMN_DISPLAY_SIZE)
FoxPro doesn't handle this correctly and thinks it's an empty column.
You can use SQLEXECEX from download #
28338.
It maps the XML type correctly to a memo field.
Regards
Christian