我在
ADOQuery1.ConnectionString :='driver={microsoft visual foxpro driver};sourcetype'+'=dbf;sourcedb='+ExtractFilePath(ParamStr(0))+';Exclusive=no';ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from "h:\qs\sjsgf.dbf" order by gfgddm');
ADOQuery1.Open;这段代码的时候,当执行到最后一句的时候报错:
A connection component is required for async ExecuteOptions.
请问是何原因呀。
ADOQuery1.ConnectionString :='driver={microsoft visual foxpro driver};sourcetype'+'=dbf;sourcedb='+ExtractFilePath(ParamStr(0))+';Exclusive=no';ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from "h:\qs\sjsgf.dbf" order by gfgddm');
ADOQuery1.Open;这段代码的时候,当执行到最后一句的时候报错:
A connection component is required for async ExecuteOptions.
请问是何原因呀。
ADOQuery1.Open;
在ADOCONNECTION中应该设置表所在的目录
应该有表所在目录,设置完后TEST,看是否成功。
ADOQuery1.SQL.Add('delete from "h:\qssj\sjsgf.dbf"');
ADOQuery1.ExecSQL; ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from "h:\qs\sjsgf.dbf" order by gfgddm');
ADOQuery1.Open;
我的代码是这样写的,如果是路径的问题,可为什么前边的的delete from "h:\qssj\sjsgf.dbf"这条语句又能正确执行呢。
ADOConnection1.ConnectString:='driver={microsoft visual foxpro driver};sourcetype'+'=dbf;sourcedb='+ExtractFilePath(ParamStr(0))+';Exclusive=no';
ADOConnection1.ConnectionOptions:=coAsyncConnect;
ADOQuery1.Connect:=ADOConnection1;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('select * from "h:\qs\sjsgf.dbf" order by gfgddm');
ADOQuery1.Open;
还是报同样的错!
如果你只想把VFP数据倒入SQL Server 的话,参考以下贴子
转自大富翁http://www.delphibbs.com/delphibbs/dispq.asp?lid=1691966