I personally like this approach...
LOOP
READNEXT ID ELSE EXIT
READV DTE FROM F.MASTER, ID, 5 ELSE CONTINUE
IF DTE LE DEL.DATE ELSE CONTINUE
DELETE F.MASTER, ID
DELETE F.REFERENCE, ID
REPEAT
That's my $0.02 worth. (If that!)
Grant
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 6:08 PM
To: U2 Users Discussion List
Subject: Re: Help Needed regarding performance improvement of delete
query
Gives Mark the "most improved player" award.
Will
In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED]
writes:
> 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).
--
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
