Cannot preform this operation on an open database是什么回事
taxi 2000-09-09 09:16:00 IndexQuery和TitleQuery已经指向了两个paradox7类型的表,当我要动态建立另外的表时,出现错误,错误信息如下:
'IndexQuery:Cannot preform this operation on an open database'
程序如下:
procedure CreateTable(filename1,filename2:string);
begin
IndexQuery.Active:=false;
TitleQuery.Active:=false;
IndexQuery.DataBaseName:=SavePath;//错误的箭头指在这里;SavePath是一个路径
TitleQuery.DataBaseName:=SavePath;
IndexQuery.SQL.Clear;
TitleQuery.SQl.Clear;
IndexQuery.Sql.Add('Create Table');
IndexQuery.Sql.Add(fileame1);
IndexQuery.Sql.Add(' (name varchar(20),HasTitle char(1),primary key(name))');
TitleQuery.sql.Add('Create Table');
TitleQuery.Sql.Add(FileName2);
TitleQuery.Sql.Add(' (name varchar(20),parent varchar(20) ,content blob,primary key(name))');
IndexQuery.Prepare;
TitleQuery.Prepare;
IndexQuery.ExecSQL;
TitleQuery.ExecSQL;
end;