[Stackoverflow] [Progress OpenEdge ABL] How to be sure that only one record is taken into account at a given stage of the query?

Status
Not open for further replies.
R

r4zSS

Guest
I wonder how exactly the "queries" for each and first work.

lets say I have some tables A, B, C and D.

How many records will I find if I use sth like:

1.

Code:
first B,
each C,
first D:
<block>
end.

1*|C|*1? [assuming there will be C that has some relation with B, etc]

And then I have sth like this:

Code:
for each A,
first B,
/*-----------------------*/
each C,
first D:
<block>
end.

How can I make sure to have the same complexity after this change? (B has now relation with A and there will be some where statements) Will it be |A|1|C|*1? And If I want to have the same complexity as before is there anything I can add there?

Continue reading...
 
Status
Not open for further replies.
Top