0001: TESTDYN="" 0002: TESTDYN<-1>="HELLO":CHAR(253):"THERE" 0003: TESTDYN<-1>="UNTIL":CHAR(253):"ANOTHER" 0004: SELECT TESTDYN 0005: LOOP 0006: READNEXT ID ELSE EXIT 0007: PRINT ID 0008: REPEAT 0009: STOP 0010: END
This only returns HELLO UNTIL My first test did not have @vm's and it looked like it worked but when I put in @vm's, anything after them is ignored. George > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > Marvin R. Fisher > Sent: Monday, November 17, 2008 3:00 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Speeding up processing through large dynamic table > > > But it is not a file - it's an array. > > Marvin R. Fisher > Technical Resource Group > A Pipeline Group Company > 2850 Red Hill Ave. > Suite 110 > Santa Ana, CA 92705 > Tel (949) 296-8380 ext. 620 > Fax (949) 756-0029 > Pipeline Software Statement: This email message is > confidential and may be legally privileged. The contents > contained within, including any attached files, are intended > solely for the addressee(s). Access by anyone other than the > addressee(s) is unauthorized. If you are not the intended > recipient, any disclosure, copying, distribution or any > action, taken or not taken, in reliance on it, is prohibited > and may be unlawful. If you believe that you have received > this email message in error, please contact the sender. Any > views expressed within are those of the individual sender, > except where the sender specifies and with authority, states > them to be the views of Pipeline-Software, Inc., Santa Ana, CA. > > (The contents of this email message have been scanned for the > presence of computer viruses.) > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann Sent: Monday, November 17, 2008 11:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Speeding up processing through large dynamic table 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 > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/