D, There was an ADO Navigator on DSP that mentioned something about thos Regards Neven N.K. MacEwan B.E. E&E [EMAIL PROTECTED] ----- Original Message ----- From: Donovan J. Edye <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sent: Wednesday, 14 June 2000 15:46 Subject: [DUG]: Most efficient way to refresh an ADO Query? > G'Day, > > I have an application that makes changes to the database and another one > that views those changes. At present I have the viewer doing refreshes every > second. Which of the following is the most efficient way to refresh an > TADOQuery where: > > Cursor : ctStatic > Cursor Location : clClient > > 1. Close, Open > 2. Refresh > 3. Requery > > Would a better scenario be to change the cursor location to clUseServer and > cursor to ctDynamic for the datasets on the viewer? This would then mean > that changes become visible "automatically" and do not require a refresh. > However the queries in the viewer are linked to DB grids and this would then > cause locking problems if I am not mistaken. So what is the most efficient > way for the viewer to get to see changes made by the updater? I need these > changes to be visible in as near real time as possible and the viewer to be > able to scroll forwards and backwards through the data. > > TIA > > ------------------------------------------------------------------------ > --Donovan > Donovan J. Edye [www.edye.wattle.id.au] > Namadgi Systems, Delphi Developer > Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED] > Voice: +61 2 6285-3460 Fax: +61 2 6285-3459 > TVisualBasic = Class(None); > GExplorer [http://www.gexperts.com/gxexplorer/] Freeware Windows Explorer > replacement. Also includes freeware delphi windows explorer components. > ------------------------------------------------------------------------ > > -------------------------------------------------------------------------- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
