I'm using SQLite with Lazarus to select a subset of a database using the SELECT statement. Then I want to do something with that dataset by using a While NOT SQLQuery.EOF DO followed by statements.
My question is how can I be sure I'm starting at the beginning of the dataset? Some of the dataset is not getting affected by the statements after the While NOT...statement. I'd like to use a SQLQuery.MoveFirst statement before the While Not, but don't see one available.
Thanks,
Rick