Or again, you could 'build up' your IN.LINE like this:
If you string were **huge** this might be faster as long as the size of each
@AM was not too big...
IN.LINE = ""
LOOP
REMOVE TEMP.IN.LINE FROM IN.TAB SETTING MARK
BEGIN CASE
CASE MARK = 0 OR MARK = 1 OR MARK = 2
(do my thing with IN.LINE)
IN.LINE = ""
CASE MARK = 3
IN.LINE := TEMP.IN.LINE:@VM
CASE MARK = 4
IN.LINE := TEMP.IN.LINE:@SVM
END CASE
UNTIL MARK = 0
REPEAT
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
> Sent: Monday, November 17, 2008 2:19 PM
> To: [email protected]
> Subject: RE: [U2] Speeding up processing through large dynamic table
>
> That is what I was afraid of. Okay. So after listening to
> all of your comments (thus far since there is an annoying
> delay in these messages), here is what I like the best:
>
> SWAP CHAR(9) WITH "" IN IN.TAB
> SWAP CHAR(10) WITH "" IN IN.TAB
>
> SWAP @VM WITH CHAR(9) IN IN.TAB
> SWAP @SM WITH CHAR(10) IN IN.TAB
>
> REPEAT
> REMOVE IN.LINE FROM IN.TAB SETTING MARK
> SWAP CHAR(9) WITH @VM IN IN.LINE
> SWAP CHAR(10) WITH @SM IN IN.LINE
> (do my thing with IN.LINE)
> UNTIL MARK DO
> REPEAT
>
> Any objections, concerns or better suggestions for using
> CHAR(10) as the temporary substitute for the @SM? I just
> picked it because it came right after CHAR(9) on my
> handy-dandy ASCII chart! Been using it since the 70's. Some
> things just never go out of style!
>
> David Laansma
> IT Manager
> Hubbard Supply Co.
> Direct: 810-342-7143
> Office:810-234-8681
> Fax: 810-234-6142
> www.hubbardsupply.com
> "Delivering Products, Services, and Innovative Solutions"
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> David Wolverton
> Sent: Monday, November 17, 2008 2:52 PM
> To: [email protected]
> Subject: RE: [U2] Speeding up processing through large dynamic table
>
> If you don't want to 'swap' all the other markers with
> 'strings' (SWAP @VM WITH "<<VM>>" IN RECORD) then you have to
> 'build' the line item up -- keep removing until you see the
> remove hit the @AM and then process the line...
>
> DW
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of
> Dave Laansma
> > Sent: Monday, November 17, 2008 1:24 PM
> > To: [email protected]
> > Subject: RE: [U2] Speeding up processing through large dynamic table
> >
> > Oh my goodness! This is incredible.
> >
> > Okay, now I have a mixture of @VM and @AM in the table. The REMOVE
> > 'stops' at every @VM and @AM. I only want it to 'stop' at
> @AMs. How
> > do I do that?
> >
> > David Laansma
> > IT Manager
> > Hubbard Supply Co.
> > Direct: 810-342-7143
> > Office:810-234-8681
> > Fax: 810-234-6142
> > www.hubbardsupply.com
> > "Delivering Products, Services, and Innovative Solutions"
> -------
> 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/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
