我用delphi连接是自带的数据库db,文件增加记录后有84m,但用query查询delphi报错:stack overflow..., 请问怎么解决还是换别的数据库
self.Query1.DatabaseName:='E:\人力HRv2.14上线-基础资料导出导入编程相关文件';
self.Query1.SQL.Text:='select * from xx ';
self.Query1.Open ;就报告错误了
self.Query1.DatabaseName:='E:\人力HRv2.14上线-基础资料导出导入编程相关文件';
self.Query1.SQL.Text:='select * from xx ';
self.Query1.Open ;就报告错误了
procedure TMain_Frm.FormCreate(Sender: TObject);
begin
try
ADOConnection1.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+extractfilepath(Application.ExeName)+'KYE.mdb;Persist Security Info=False';
ADOConnection1.LoginPrompt:=False;
ADOConnection1.Connected:=True;
except
Application.Terminate;
Application.MessageBox('數據庫連接文件出錯!請與MIS聯系!!!', '錯誤',
MB_OK + MB_ICONSTOP);
Application.Terminate;//數據庫連接文件出錯,程序中止退出
end;
end;
procedure TMain_Frm.FormCreate(Sender: TObject);
begin
try
ADOConnection1.ConnectionString:=
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+extractfilepath(Application.ExeName)+'KYE.mdb;Persist Security Info=False';
ADOConnection1.LoginPrompt:=False;
ADOConnection1.Connected:=True;
except
Application.Terminate;
Application.MessageBox('數據庫連接文件出錯!請與MIS聯系!!!', '錯誤',
MB_OK + MB_ICONSTOP);
Application.Terminate;//數據庫連接文件出錯,程序中止退出
end;
end;
search table -->
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.add( 'select * from xxx.....' );
adoquery1.open;