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
