How the go down in a database ( with a condition in the field)

[Celemka]

Hello

I have a database with different field

Index / Distance / Type / Value

If i make :

Distance = EventQuery->FieldValues["Distance"];
EventQuery->Next();

The cursor move one step to down to the next line.
But I would go (down) not to the next line, but to the next incrementation
from Index ( because my database is not in order, but the field Index is
correct.

How can I do ... like

EventQuery->FieldValues["Index"]->Next;

but this dont run.

If you can explain me.
Thank you in advance

PS: I work with borland C++ builder wich a database like acces

 

[Norman Yuan]

Simply make sure the query is sorted by the [Insex] column.

 

[Celemka]

up !! please