关于用ADO建个ACCESS的新库
我搜索到可以这样实现用ADO建个ACCESS的新库:
AnsiString cDatabase;
AnsiString cConn;
cDatabase="d:\\Sample.mdb";
cConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+cDatabase+";Persist Security Info=False;Jet OLEDB:Database Password=";
Variant cat=Variant::CreateObject("ADOX.Catalog");
cat.OleProcedure("Create","Provider=Microsoft Jet 4.0 OLE DB Provider;Data Source=d:\Sample.mdb;Jet OLEDB:Database Password=");
TADOCommand *cmd=new TADOCommand(NULL);
cmd->ConnectionString=cConn;
cmd->CommandText="Create Table yqw(Field1 char(10),Field2 char(10))";
cmd->Execute();
delete cmd;
cmd=NULL;
问题是:cat.OleProcedure("Create","Provider=Microsoft Jet 4.0 OLE DB Provider;Data Source=d:\Sample.mdb;Jet OLEDB:Database Password=");
此语句中Data Source=d:\Sample.mdb我想要是个变量,我用Data Source="+cDatabase+"来代替
不行,该怎么做呢?