Re: NewEra is heavy!

Posted in 1995

Kerry Sainsbury — Mon, 13 Nov 1995 19:36:18 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <4801po$39o@cssun.mathcs.emory.edu>, rob@dssmktg.com (Robert Minter) wrote: >Kerry Sainsbury writes: >* In article <47t9kj$jko@nic.ftns.no>, Nils.Myklebust@ccmail.telemax.no wrote: >* >>Kerry Sainsbury, kerry@kcbbs.gen.nz wrote: >* >* >>I am unclear how Delphi handles the scrolling of the cursor, there may >* >>be some rowids floating in the background I wonder - might not be so good >* >>on fragmented Informix 7 tables? >* > >* >Hopefully they use a scroll cursor. >* >* I can say that they aren't using ROWID (I SET EXPLAIN ONed and had a look >* at the sqexplain.out) > >I know that if you update a row within an open 'CURSOR' in Delphi with >another 'CURSOR' or SQL statement, then do a NEXT and then PRIOR on that >first 'CURSOR', it doesn't show the changes made. I guess you'd need to .Refresh the "other" TTable or TQuery. Why would you have two cursors pointing at the same table at the same time anyway? ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | kcbbs.gen.nz:/informix/informix.[faq|apx] New Zealand. Work: +64 9 377-4473 | mathcs.emory.edu:/pub/informix/faq/ " " Home: +64 9 279-3571 | http://www.garpac.com/informix.html