Help me to create .dbf using VisualStudio (2003, ODBC)
I try this :
1st:
Code:
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"
}
THROW "Too few parameters. Expected 1"

2nd:
Code:
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\")");
}
THROW "Unrecognized command verb"

i tried to create dbf myself in VisualFoxpro and input data from my prog, but result same : "Unrecognized command verb"
is my SQL right ?