Hi all,
I have a scenario here, and the query contain 100k records. batch-size=100.
if I added a new record. when I reopen the query. it will become 100,001 records.
now the problem is, how can I find that particular new added record in which batch 's rowid
instead of I need to loop 100k+ times and find that particular record in which rowid.
Thank you.
Regards,
TanMH
hi all,
I already found the solution by myself.
1) find paritcular record and get the rowid.
h_query:open-query()
h_query:reposition-to-rowid( ).
h_query:get-next.
then only use reposition-to-row( h_query:current-result-row).
Thank you.
Regards,
TanMH
That's the approach to take.
1) find paritcular record and get the rowid.
Just one clarification: if you've done this
h_query:reposition-to-rowid( ).
There's no need to do this
reposition-to-row( h_query:current-result-row).
-- peter