关于原生ADO数据更新问题 ( 积分: 100 )

T

tjzxm08

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-01

• #1

var
rs: _Recordset;
begin
rs := qtTempADO.Recordset;
//qtTempADO 为ADOQuery控件,其LockType设为 ltBatchOptimistic
//CursorType 为 ctKeyset
with rs do begin
MoveFirst;
while not Eof do begin
if bCan then Break;//用户中断
Fields['qtValue'].Value := 3;//表中的一个标志位赋值
movenext;
end;
end;
if bCan then rs.CancelUpdate
else rs.UpdateBatch(arAll);
//此句编译不能通过提示Incompatible types: 'TOleEnum' and 'TAffectRecords'
rs := nil;
......
那位大侠能解答原生ADO的缓冲更新问题?

 

T

tjzxm08

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-01

• #2

用 rs.UpdateBatch(rs.CursorLocation)倒是能通过，但更新速度奇慢，用原生
ADO就是要提高速度的，怎么解决呢？

 

D

dcms

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-02

• #3

好象要设置一个属性,记不清楚了

 

D

dcs_dcs

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-04

• #4

rs.UpdateBatch 就可以了吧

 

M

moyiying

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-08

• #5

Note:
: To use batch updating, the CursorType property of the dataset component must be either ctKeySet (the default) or ctStatic and the LockType property must be ltBatchOptimistic

 

T

tjzxm08

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-10

• #6

这个问题很难吗？

 

N

newsmile

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-11

• #7

var
rs: _Recordset;
begin
rs := qtTempADO.Recordset;
with rs do begin
MoveFirst;
while not Eof do begin
if bCan then Break;//用户中断
Fields['qtValue'].Value := 3;//表中的一个标志位赋值
update;
movenext;
end;
end;
rs := nil;//这里我一般用Unassigned

 

C

ch2001023

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-11

• #8

为什么不用SQL语句来更新数据呢,,,速度快~

 

T

tjzxm08

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-17

• #9

to newsmile:
update这句提示缺参数
to ch2001023:
Sql 更新后能撤销吗？

 

N

newsmile

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-18

• #10

请看这张帖子 http://www.delphibbs.com/delphibbs/dispq.asp?lid=3047846