[DUG] Slow updates

2004-09-16 Thread Jeremy Coulter
Title: Message Hi All. I have a DB Grid (an InfoPower one) that is linked to a TADOQuery. I have made it so one of the cells can be edited to update a value or add one. This all works fine, UNTIL, it tries to do an update. If you enter in a value then press teh enter key or down arrow, it

Re: [DUG] Slow updates

2004-09-16 Thread Rohit Gupta
I havent used ADO, but one possible cause could be that it is reading the whole table in after an update. There may be a property to turn this behaviour off. Hi All. I have a DB Grid (an InfoPower one) that is linked to a TADOQuery. I have made it so one of the cells can be edited to

Re: [DUG] Slow updates

2004-09-16 Thread Neven MacEwan
J Pls post what your ado query config is 'Static Client Side' is the best, if you use dynamic server side it can be horrible Neven MacEwan (B.E. EE) Ph. 09 621 0001 Mob. 0274 749062 Jeremy Coulter wrote: Hi All. I have a DB Grid (an InfoPower one) that is linked to a TADOQuery. I have made it so

Re: [DUG] Slow updates

2004-09-16 Thread Robert martin
: Rohit Gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, September 17, 2004 9:40 AM Subject: Re: [DUG] Slow updates I havent used ADO, but one possible cause could be that it is reading the whole table in after an update

RE: [DUG] Slow updates

2004-09-16 Thread Jeremy Coulter
: Friday, 17 September 2004 10:26 To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Slow updates I know very little about ADO but I think Rohit is right about reading the whole table in, probably not good (and should be fixed). However doesn't ADO have a async