How to stay on the current row?
lazarus / 16-Databases

----------------------------------------------------------------------
Focus77 · 2020-05-25 11:39

Hello every one.

I use SqlQuery with  Sequence.saeOnPost option.

but when I post, the cursor move to the first row.

How to make the cursor remains on the current row ?

thanks.

----------------------------------------------------------------------
eljo · 2020-05-25 11:41

get a bookmark and use the gotobookmark to jump to the record, or save
the records key values and use find/locate to jump to the record you
want.

----------------------------------------------------------------------
Focus77 · 2020-05-25 11:57

thanks for reply.

1. I used locate before but it works only with "saeOnNewRecord"
option.
but I avoid using it because when I insert record it's not possibe to
cancel it.

2. As for bookmark frankly I have never managed to use it.