Re: Dev 2000 forms - Record navigation Q

You can get the record number as mentioned by Steve Cosner (by using cursor with the same where clause as in the block, just get 'where' clause from SYSTEM.LAST_QUERY). So, now you know record number and you can use GO_RECORD built-in. It's much faster than NEXT_RECORD...

Let me know if you need more details.

Hope this helps.

Bert Vanderstraeten wrote:
>
> I've got a table filled with over 10.000 records which I'm navigating
> through in a form. If I want to look up a certain record f.e. ID 2000, the
> form executes a next_record() function 2000 times.
>
> Ofcourse this results in low performance but I did not use the execute-query
> with the ID value because it would only return one record and thus
> navigation would be no longer possible from this record to the next/previous
> one..
>
> Or is there a way?
>
> thanks a million in advance!
>
> Bert Vanderstraeten

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru