CString ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=533;Dbq=c:\\fpdb;";
CDatabase   db;

try
{
	db.OpenEx(ConnectionString, CDatabase::noOdbcDialog);
	db.ExecuteSQL("CREATE TABLE test2 (id INT, dat1 MEMO)");
	db.ExecuteSQL("INSERT INTO test2(id, dat1) VALUES(1, \"test\")");//THROW "Too few parameters. Expected 1"
}

CString ConnectionString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\\fpdb;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO";
CDatabase   db;

try
{
	db.OpenEx(ConnectionString, CDatabase::noOdbcDialog);
	db.ExecuteSQL("CREATE TABLE test2 (id INT, dat1 MEMO)");//THROW "Unrecognized command verb"
	db.ExecuteSQL("INSERT INTO test2(id, dat1) VALUES(1, \"test\")");
}

FieldType NFieldWidth nPrecision Description 
  B             -              d           Double 
  C            N              -           Character field of width n 
  D            -              -            Date 
  F            N              d            Floating numeric field of width n with d decimal places 
  G           -               -            General 
  I           -               -             Integer 
  L           -               -             Logical 
  M          -               -             Memo 
  N          N               d             Numeric field of width n with d decimal places 
  T          -               -              DateTime 
  Y          -               -             Currency