Iteration over some field-values

make

Member
Hi everybody !

I want to do the following :

I have a table like this :

Art HT Val
---- ---- -----
10 1.0 0.0
10 1.0 1.0
10 1.0 1.2
10 1.5 0.9
10 1.5 1.1
10 1.3 1.1
10 1.5 1.3
10 1.7 0.1
10 1.7 1.0

Now i change two value's of HT (This part is done, code ist written)

For example : i selected the 1.5 and 1.7 (HT)
Now i must write a query. The query should give back all values
from 1.5 to 1.7.

I want the follwing result :
Art HT Val
---- ---- -----
10 1.5 0.9
10 1.5 1.1
10 1.3 1.1
10 1.5 1.3
10 1.7 0.1
10 1.7 1.0

How can i do that ?
with the do oe repeat statemant ?

Greets
Make
 

Serj HAMMER

Junior Racer
select with repeat

Hello, make.
if You whant to use REPEAT then why You do not use repeat "as is"?

REPEAT:
  FIND NEXT table.
&nbsp;&nbsp;if HT < 1.3 OR HT > 1.5 THEN NEXT.
&nbsp;&nbsp;... selection output ...
END.

P.S. And why You do not use FOR EACH or OPEN QUERY?
 
Top