>what's the fastest way to seek data in view?
>currently I'm using locate, but I think that's the slowest.
>
>regards,
>
>Jerry

Jerry,

You can index the view

(1) If only used once, ie no requery() done

use v_stock
index on stock_id tag stock_id

?seek('122344')

(2) If requery() done - a bit slower - = create the index before

use v_stock nodata
index on stock_id tag stock_id
....

=requery()
?seek('122344')
...

=requery()
?seek('122344')