[solved] GoToBookMark after closing & opening Query

[kapibara]

Can Query.GotoBookMark(aBookMark) be called after closing and opening the Query?

Or will the bookmark pointer be outdated when the query is re-opened? I get a violation on trying this.

[taazz]

Bookmarks must be handled as pointers after a dataset is closed they are probably invalid or pointing to the wrong record. In any case you need to find some other way to find your record, locate perhaps?

[JZS]

BookMarks will keep giving you violation if your data has been manipulated or re-fetched.

BookMarks as well as RecNo may not refer to the right records, IF, for instance, you are updating/deleting/reordering your records.

Locate should be your best approach.

[kapibara]

Thanks. Locate seems to be the best choice to find a record after closing the query.

If I understand correctly, Locate searches the result of a Query and finds the record you look for, if it exists.
If the Query is assigned to a data aware control like a DBGrid, then the located record will automatically be the current record of the grid. And thats just whats needed.

Example:

aQuery.Locate('field_name', 'FieldValue', []);