unit UdmU;interfaceuses
SysUtils, Classes, DB, ADODB;type
TAdodm = class(TDataModule)
ConnYuan: TADOConnection;
DSYuan: TDataSource;
QueryYuan: TADOQuery;
ConnBeng: TADOConnection;
TableBeng: TADOTable;
DSBeng: TDataSource;
private
{ Private declarations }
public
{ Public declarations }
end;var
Adodm: TAdodm;implementation{$R *.dfm}end.
unit DeliverFU;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls;type
TDeliverForm = class(TForm)
Panel1: TPanel;
DBGrid1: TDBGrid;
Panel2: TPanel;
Button1: TButton;
Button2: TButton;
Edit1: TEdit;
DBGrid2: TDBGrid;
Label1: TLabel;
Button3: TButton;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
DeliverForm: TDeliverForm;implementationuses UdmU;
{$R *.dfm}procedure TDeliverForm.Button1Click(Sender: TObject);
begin
Application.Terminate;
end;procedure TDeliverForm.Button2Click(Sender: TObject);
begin
try
Udmu.Adodm.QueryYuan.Active:=False;
Udmu.Adodm.QueryYuan.SQL.Clear;
Udmu.Adodm.QueryYuan.SQL.Add ('select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;
Udmu.Adodm.QueryYuan.Active:=true;
except
showMessage('请输入数字');
end;
end;
请问我如何要把QueryYuan的数据结果存到TableBeng中去
SysUtils, Classes, DB, ADODB;type
TAdodm = class(TDataModule)
ConnYuan: TADOConnection;
DSYuan: TDataSource;
QueryYuan: TADOQuery;
ConnBeng: TADOConnection;
TableBeng: TADOTable;
DSBeng: TDataSource;
private
{ Private declarations }
public
{ Public declarations }
end;var
Adodm: TAdodm;implementation{$R *.dfm}end.
unit DeliverFU;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls;type
TDeliverForm = class(TForm)
Panel1: TPanel;
DBGrid1: TDBGrid;
Panel2: TPanel;
Button1: TButton;
Button2: TButton;
Edit1: TEdit;
DBGrid2: TDBGrid;
Label1: TLabel;
Button3: TButton;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
DeliverForm: TDeliverForm;implementationuses UdmU;
{$R *.dfm}procedure TDeliverForm.Button1Click(Sender: TObject);
begin
Application.Terminate;
end;procedure TDeliverForm.Button2Click(Sender: TObject);
begin
try
Udmu.Adodm.QueryYuan.Active:=False;
Udmu.Adodm.QueryYuan.SQL.Clear;
Udmu.Adodm.QueryYuan.SQL.Add ('select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;
Udmu.Adodm.QueryYuan.Active:=true;
except
showMessage('请输入数字');
end;
end;
请问我如何要把QueryYuan的数据结果存到TableBeng中去
解决方案 »
- (EhLib4.4)DbGridEh显示完整竖线方法!所有分全上了!
- 跪求fastreport for delphi6.0的下载地址
- 有没有可以显示病人图标列表信息的控件?或以图标显示酒店房间信息的控件?下有示例
- 拜求代理服务器编程的程序
- ************难道没有人知道这个问题吗?用 delphi 如何导出 foxpro数据库表中的数据???
- chr()是不是把数转成ascll码字符与vb的chr()是不是一样
- 如何在代码中模拟一个鼠标拖动的过程!
- 库存数量问题:我想用SQL做一个简单库存管理系统,但不知道在开完单据之后如何对库存数量加减,在修改有已有的单据后库存数量又如何体现
- delphi怎么访问远程共享的文件并取前五行
- DBRadioGroup怎么用,对应什么字段?
- Locate气死我了
- TreeView的问题
Udmu.Adodm.QueryYuan.SQL.Add ('insert into TableBeng select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;
SysUtils, Classes, DB, ADODB;type
TAdodm = class(TDataModule)
ConnYuan: TADOConnection;
DSYuan: TDataSource;
QueryYuan: TADOQuery;
ConnBeng: TADOConnection;
TableBeng: TADOTable;
DSBeng: TDataSource;
private
{ Private declarations }
public
{ Public declarations }
end;var
Adodm: TAdodm;implementation{$R *.dfm}end.
unit DeliverFU;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls;type
TDeliverForm = class(TForm)
Panel1: TPanel;
DBGrid1: TDBGrid;
Panel2: TPanel;
Button1: TButton;
Button2: TButton;
Edit1: TEdit;
DBGrid2: TDBGrid;
Label1: TLabel;
Button3: TButton;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
procedure Button3Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
DeliverForm: TDeliverForm;implementationuses UdmU;
{$R *.dfm}procedure TDeliverForm.Button1Click(Sender: TObject);
begin
Application.Terminate;
end;procedure TDeliverForm.Button2Click(Sender: TObject);
begin
try
Udmu.Adodm.QueryYuan.Active:=False;
Udmu.Adodm.QueryYuan.SQL.Clear;
Udmu.Adodm.QueryYuan.SQL.Add ('select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;
Udmu.Adodm.QueryYuan.Active:=true;
except
showMessage('请输入数字');
end;
end;
procedure TDeliverForm.Button3Click(Sender: TObject);
begin
Udmu.Adodm.QueryYuan.SQL.Clear;
Udmu.Adodm.QueryYuan.SQL.Add ('insert into UdmU.Adodm.TableBeng {TableBeng}select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;
end;end.
都提示出现异常,说TableBeng对像无效
TableBeng.Assign(QueryYuan)
顺便提一下是二台机器的相同数据表中的数据传输不是单台机的数据库传输
各位朋友,能不能先添加Access库里啊。可以的话应怎么添加到本地的Access数据库。
高手请帮一下ok!
↑或直接写Field名
Udmu.Adodm.QueryYuan.ExecSQL; //削除此行try
Udmu.Adodm.QueryYuan.Active:=False;
Udmu.Adodm.QueryYuan.SQL.Clear;
Udmu.Adodm.QueryYuan.SQL.Add ('select top '+'''Edit1.Text'''+' * from company');
Udmu.Adodm.QueryYuan.Active:=true;
except
{...}
Udmu.Adodm.QueryYuan.SQL.Add ('insert into ' + TableBeng.TableName + ' select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;这样就可以了,然后刷新一下数据会出来
Udmu.Adodm.QueryYuan.SQL.Add ('insert into ' + TableBeng.TableName + ' select top '+Edit1.Text+' * from company');
Udmu.Adodm.QueryYuan.ExecSQL;这样就可以了,然后刷新一下数据会出来
我试了一下这样的结果就是在源机器查讯了数据,结果也是添加到源数据库报错' + TableBeng.TableName + '的值也是Company 报以有键值的错.
本人的意思是将源数据库QuerryYuan查到的数据,保存到 TableBeng连接到的数据表中,二个数据库和表都是相同名字和结构的!
望各位大哥,高手再顶一下,先谢过了!
请问各位高手如何把查讯到的数据保存到一个二维数组中,而后再加到目的数据库.