请问我用了UPDATESOBJECT后应怎么进行更新，可以给个简单例子吗？(30分)

C

chen_ke

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #1

 

L

Liu JZX

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #2

在updatesql1中准备的更新语句如下
update customer
set
company ='Sightr'
where
Company ='Sight Diver'


procedure TForm1.Button1Click(Sender: TObject);

begin
updatesql1.updateobject:=query1;
updatesql1.SetParams(ukModify);
updatesql1.ExecSQL(ukModify);
end;

 

L

Liu JZX

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-25

• #3

在updatesql1中准备的更新语句如下
update customer
set
company ='Sightr'
where
Company ='Sight Diver'

query1中准备select * from customer
active属性社为true

procedure TForm1.Button1Click(Sender: TObject);

begin
updatesql1.updateobject:=query1;
updatesql1.SetParams(ukModify);
updatesql1.ExecSQL(ukModify);
end;

 

L

Liu JZX

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-26

• #4

D:/Program Files/Delphi4/Demos/Db/Cachedup.dpr
是一个用updatesql的粒子、克仔细研究一下

 

C

cytown

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-26

• #5

呵呵, 如果query+updatesql应用的话, 直接更改query中的值, updatesql是自动
生成的, 不需要手写
如:
query1.updateobject:=updatesql1;

begin
with query1 do
begin
edit;
fieldbyname('xxx').asstring:='test';
post;
end;
end;

就ok了

 

C

chen_ke

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-11-26

• #6

我现在是不明白用了UPDATESOBJECT之后有什么好处？它是怎样产生作用的？谢谢
另：updatesql1.SetParams(ukModify);
updatesql1.ExecSQL(ukModify);
怎样理解？

 

李

李颖

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-08

• #7

请大家继续回答，否则我将在3天后结束本问。。。

 

C

chen_ke

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-01-19

• #8

接受答案了.