READNEXT could be an option

SELECT IN.TAB
LOOP WHILE READNEXT IN.LINE DO
  CUST.NUM=IN.LINE<1,1>
  CUST.DESC=IN.LINE<1,2>
REPEAT

this should be lightning-fast regardless how big IN.TAB is.

David Laansma wrote:
Is there a way to speed up spinning through a very large dynamic table?  Here is
a sample of my program:

A11 = DCOUNT(IN.TAB,@AM)

FOR A1 = 1 TO A11
  IN.LINE = IN.TAB<A1>
  SWAP @VM WITH @AM IN IN.LINE
  CUST.NUM  = IN.LINE<1>
  CUST.DESC = IN.LINE<2>
NEXT A1

A11 is 85,000+ and as this loop goes on, this thing get really slow.  Any tips
on speeding this up?
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to