在SQL中如何调用CB定义的变量?

feilongzaitian1979 2004-08-11 08:18:41

AnsiString FileName=Dir+"DataAnalyzer_data.mdf";
AnsiString LogFileName=Dir+"DataAnalyzer_log.ldf";
ADOQuery1->SQL->Clear();
ADOQuery1->Close();
ADOQuery1->SQL->Add("CREATE DATABASE DataAnalyzerbak");
ADOQuery1->SQL->Add("ON");
ADOQuery1->SQL->Add("PRIMARY(NAME=DataAnalyzer_data,FILENAME=:FileName,SIZE=1MB)");
ADOQuery1->SQL->Add("LOG ON(NAME=DataAnalyzer_log,FILENAME=:LogFileName,SIZE=1MB)");
ADOQuery1->ExecSQL();

我自己定义的FileName和LogFileName,SQL不认怎么办啊?请大虾们指教!

...全文

110 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

ralpha08 2004-08-11

打赏
举报

改成这样
AnsiString FileName=Dir+"DataAnalyzer_data.mdf";
AnsiString LogFileName=Dir+"DataAnalyzer_log.ldf";
ADOQuery1->SQL->Clear();
ADOQuery1->Close();
ADOQuery1->SQL->Add("CREATE DATABASE DataAnalyzerbak");
ADOQuery1->SQL->Add("ON");
ADOQuery1->SQL->Add("PRIMARY(NAME=DataAnalyzer_data,FILENAME='"+FileName+"',SIZE=1MB)");
ADOQuery1->SQL->Add("LOG ON(NAME=DataAnalyzer_log,FILENAME='"+LogFileName+"',SIZE=1MB)");
ADOQuery1->ExecSQL();