For those who cannot read GOTO's, here's the code expressed goto-less.

LOOP WHILE READNEXT ID DO
    READV DTE FROM F.MASTER, ID, 5 THEN
         IF DTE LE DEL.DATE THEN
              DELETE F.MASTER, ID
              DELETE F.REFERENCE, ID
         END
    END
REPEAT

there you go (to).


----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 4:33 PM
Subject: Re: Help Needed regarding performance improvement of delete query


> In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time,
[EMAIL PROTECTED] writes:
>
> > 10 READNEXT ID ELSE STOP
> >    READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10
> >    IF DTE GT DEL.DATE THEN GOTO 10
> >    DELETE F.MASTER, ID
> >    DELETE F.REFERENCE, ID
> >    GOTO 10
>
> I count three goto's
> So three times through the spank machine.
> Will
> --
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.oliver.com/mailman/listinfo/u2-users

-- 
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users

Reply via email to