I tried to create a CONNECT table using the following command –
create table cust engine=CONNECT table_type=DBF file_name='test.dbf';
I got an error –
Error Code: 1105. Unsupported DBF type M
I'm assuming DBF type M means that there are Memo fields in use? Or perhaps that means something else.
Anyway, if it's a reasonable request, support for FoxPro tables including memo field support (FPT files) and CDX indexes would be extremely helpful.