Hi, Raoshan.

>I've tried to work with a VFP application having its data on ORACLE 8i. I've used remote views to get data from oracle server. but I'm unable to set any indexes on the view and that's why I'm unable to use some search commands like SEEK (isn't it will be very slow if I use LOCATE command instead of SEEK)

You can't define permanent indexes on a view. You can, however, index the view once you got the data. Anyway, you can use locate without performance problems if the resultset in the view is small enough. If it is too big, indexing it will also take some time, so the best approach depends on several issues.

Just some hints:
- Try first to keep the amount of data in the view as small as possible.
- If the resultset is big but your app will keep this data on the view for quite some time and make many searches over it, index it. It will take some time to do it, but then searches will be fast.
- If the resultset is big and your app just get it, perform a couple local searches and then discard it, then use LOCATE.

In most cases, if the view is properly parameterized, then you shouldn't need to do further searches, except for some interface details.

Hope this helps,