Hi,

I have a MySQL 5 database table with a Longtext field. I have the MySQL ODBC Connector installed. I am using VFP 9 SP2.

I have been able to populate the table from VFP using SQL pass-through.

Now I want to retrieve the Longtext data from the table.

lnHandle = SQLSTRINGCONNECT(......)
lcQuery = "SELECT id, textfield FROM textdata"
lnResult = SQLEXEC( lnHandle, lcQuery,'outdata)

All works fine, EXCEPT the Longtext data is always truncated to 255 characters.

I have seen CURSORSETPROP('mapbinary') and CURSORSETPROP('maptext') which allow me to change the type of the field created in the 'outdata' table from Char to VarChar, but it's still truncated to 255 characters.

Any suggestions appreciated.

Kind regards,
Mark Hall