How to retrieve returned rows other than the first one?

[pebecker]

Hi,
I'm running D5Pro and the latest MyDAC, and have a question:

I have a query that I run that returns 4 records. I can get the first one like this:

id := MyQuery1.FieldByName(FIELD_ID).AsString;

I'd like to get the data from the same field of the second row, and the third, and the fourth, etc. I can't see how to do this, can someone help?

Thanks,
Paul Becker

[Ikar]

In this case MyDAC behaviour doesn't change from behaviour of BDE, ADO and so on.
Please read in Delphi Help articles related to TDataset.Next and Prev methods.

[kenny]

Hi, try

While Not MyQuery1.Eof Do Begin
id := MyQuery1.FieldByName(FIELD_ID).AsString;
MyQuery1.Next;
End;

[Ikar]

Would you like to get a number of records or field values?

[pebecker]

Thank you very much for your reply. I wasn't aware that .Next worked - I didn't see an example of this and so I never thought to try it.

Thanks again,
Paul