大家,帮我看一下这个关于SQL的错误好吗?
danna 2002-08-26 06:58:52 我的错误是这样的:project librayproj.exe raised exception class Eoleexcaption with message Invalid SQL statment expected ‘DELETE','INSERT',PROCEDURE ,SELECT ,UPDATE 的错误呢!
我一运行程序就出错,跟本不能显示窗口:代码如下:这个一碰到open 语句就出上面的错误,整个程序都是这样的。我不知道是不是这是我这个窗体的问题还是怎么的。但是我那另外的窗口也是这样用数据模型的。就没问题。
void __fastcall Tfrmtushushajia::FormCreate(TObject *Sender)
{
DataModule1->tsdc_ADOQuery1->Close();
DataModule1->tsdc_ADOQuery1->SQL->Clear();
DataModule1->tsdc_ADOQuery1->SQL->Add("SEELCT * FROM tsdc");
if(!DataModule1->tsdc_ADOQuery1->Prepared)
DataModule1->tsdc_ADOQuery1->Prepared=true;
// DataModule1->tsdc_ADOQuery1->Active=true;
DataModule1->tsdc_ADOQuery1->Open();
//ShowMessage("this");
DataModule1->shu_ADOTable1->Close();
DataModule1->shu_ADOTable1->SQL->Clear();
DataModule1->shu_ADOTable1->SQL->Add("SEELCT * FROM shihaobiao");
DataModule1->shu_ADOTable1->Prepared=true;
DataModule1->shu_ADOTable1->Open();
DBCshuwuhao->Items->Clear();
while(!DataModule1->shu_ADOTable1->Eof)
{
DBCshuwuhao->Items->Add(DataModule1->shu_ADOTable1->FieldByName("shihao")->Value);
DataModule1->shu_ADOTable1->Next();
}
DataModule1->shu_ADOTable1->Close();
DataModule1->shu_ADOTable1->SQL->Clear();
DataModule1->shu_ADOTable1->SQL->Add("SEELCT * FROM jiahaobiao");
if(!DataModule1->shu_ADOTable1->Prepared)
DataModule1->shu_ADOTable1->Prepared=true;
DataModule1->shu_ADOTable1->Open();
DBCshujiahao->Items->Clear();
while(!DataModule1->shu_ADOTable1->Eof)
{
DBCshujiahao->Items->Add(DataModule1->shu_ADOTable1->FieldByName("jiahao")->Value);
DataModule1->shu_ADOTable1->Next();
}
DataModule1->shu_ADOTable1->Close();
DataModule1->shu_ADOTable1->SQL->Clear();
DataModule1->shu_ADOTable1->SQL->Add("SEELCT * FROM tsbm");
if(!DataModule1->shu_ADOTable1->Prepared)
DataModule1->shu_ADOTable1->Prepared=true;
DataModule1->shu_ADOTable1->Open();
DBCtushubianhao->Items->Clear();
while(!DataModule1->shu_ADOTable1->Eof)
{
DBCtushubianhao->Items->Add(DataModule1->shu_ADOTable1->FieldByName("tushubianhao")->Value);
DataModule1->shu_ADOTable1->Next();
}