Lazarus

Programming => Databases => Topic started by: Focus77 on May 25, 2020, 01:39:01 pm

Title: How to stay on the current row?
Post by: Focus77 on May 25, 2020, 01:39:01 pm

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.

Title: Re: How to stay on the current row?
Post by: eljo on May 25, 2020, 01:41:52 pm

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.

Title: Re: How to stay on the current row?
Post by: Focus77 on May 25, 2020, 01:57:45 pm

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.