At the risk of starting another debate, I'll toss out my preference on
internal (or external) READNEXTS.

UD:
LOOP WHILE READNEXT ID DO
BLAH
REPEAT

D3:
LOOP READNEXT ID ELSE EXIT UNTIL 0 DO
BLAH
REPEAT

MCD and others I use the infidel EOF=0 logic
EOF=0
LOOP READNEXT ID ELSE EOF=1 UNTIL EOF DO
BLAH
REPEAT

I have been stung when using the value of the incoming ID as a test value.
Thus I leave it alone.
my 1 cent.

----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "u2-Users" <[email protected]>
Sent: Thursday, July 14, 2005 12:04 AM
Subject: [U2] [UV] Select Question


> Hi all,
>
> Can someone tell me the diference between the following two examples of
executing an external select?
>
> SELECT FILE TO LIST
> LOOP
>     READNEXT ID FROM LIST ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
>
> SELECT FILE
> LOOP
>     READNEXT ID ELSE ID = @AM
> UNTIL ID = @AM DO
> REPEAT
>
> Someone pointed out to me that there is overhead in selecting to a list
that I need not be exposing myself to.  Aren't they both kind of reading
from a list somewhere anyways?
>
> Thanks
> -------
> 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/

Reply via email to