我用Delphi7下的ADO连接VFP7的自由表,在写数据时512条记录时出现
too many variablis的错误,为什么?
ADOConnection string是Provider=VFPOLEDB.1;DataSource=D:\myVFP;Password="";Collating Sequence=MACHINE要是用ODBC连接则无问题,奇怪!!!
附源程序
unit tube50;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation
uses qldata;
{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
dmrec:TQLDmRec;
stmD:TQLDmData;
i:Longint;
begin
ADOConnection1.Open;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('INSERT INTO TBZQDM(ZQDM,ZQMC) VALUES(:DM,:MC)');
stmD:=TQLDmData.Create('shnow.dat',fmOpenRead);
stmD.FstRec;
for i:=1 to stmD.GetRecNo do
begin
stmD.ReadRec(dmrec);
ADOQuery1.Parameters.ParamValues['DM']:=dmrec.sZqdm;
ADOQuery1.Parameters.ParamValues['MC']:=dmrec.sZqmc;
ADOQuery1.ExecSQL;
stmD.NxtRec;
end;
stmD.Free;
stmD:=TQLDmData.Create('sznow.dat',fmOpenRead);
stmD.FstRec;
for i:=1 to stmD.GetRecNo do
begin
stmD.ReadRec(dmrec);
ADOQuery1.Parameters.ParamValues['DM']:=dmrec.sZqdm;
ADOQuery1.Parameters.ParamValues['MC']:=dmrec.sZqmc;
ADOQuery1.ExecSQL;
stmD.NxtRec;
end;
stmD.Free;
ADOQuery1.Close;
ADOConnection1.Close;
end;end.
too many variablis的错误,为什么?
ADOConnection string是Provider=VFPOLEDB.1;DataSource=D:\myVFP;Password="";Collating Sequence=MACHINE要是用ODBC连接则无问题,奇怪!!!
附源程序
unit tube50;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls;type
TForm1 = class(TForm)
Button1: TButton;
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation
uses qldata;
{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
dmrec:TQLDmRec;
stmD:TQLDmData;
i:Longint;
begin
ADOConnection1.Open;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('INSERT INTO TBZQDM(ZQDM,ZQMC) VALUES(:DM,:MC)');
stmD:=TQLDmData.Create('shnow.dat',fmOpenRead);
stmD.FstRec;
for i:=1 to stmD.GetRecNo do
begin
stmD.ReadRec(dmrec);
ADOQuery1.Parameters.ParamValues['DM']:=dmrec.sZqdm;
ADOQuery1.Parameters.ParamValues['MC']:=dmrec.sZqmc;
ADOQuery1.ExecSQL;
stmD.NxtRec;
end;
stmD.Free;
stmD:=TQLDmData.Create('sznow.dat',fmOpenRead);
stmD.FstRec;
for i:=1 to stmD.GetRecNo do
begin
stmD.ReadRec(dmrec);
ADOQuery1.Parameters.ParamValues['DM']:=dmrec.sZqdm;
ADOQuery1.Parameters.ParamValues['MC']:=dmrec.sZqmc;
ADOQuery1.ExecSQL;
stmD.NxtRec;
end;
stmD.Free;
ADOQuery1.Close;
ADOConnection1.Close;
end;end.
解决方案 »
- Tevent类型是什么?
- VC 有非常好用的Visual Assist,Delphi有没有Delphi Assist类似的工具增强IDE?
- 关于用delphi作FTP程序的问题!!!FTP跨网段如何实现!
- 各位哥哥姐姐,帮我看看这个问题吧,都折腾几天了。
- 灾难性故障---一用Flash控件就出现----帮我啊!
- 各位高手,过来帮忙好不好,我都急死了
- paradox 有没有数据类型转换的函数啊?
- 拿到工资单的日子,竟是最难受的日子!
- 100点求用delphi不用ODBC或者BDE处理DBF文件的源程序
- Delphi+Access中,查询时在Edit控件中的问题??????????
- CSDN改版后不好,请大家到这里暂聚:http://delphi8013.xilubbs.com/
- 怎么设置Form使其运行不随鼠标调整大小。谢谢
用OLE DB For ODBC Provider可以的话,就用ODBC吧!
我去MSDN找也没找到更新的版本,有哪位大虾知道,救救我呀
我是业余菜鸟