>Hi Hilmar
>
>You are right, I don't have to use filter. But When I am requering Data In forms it takes a long time. (Specially when there is returned records are more than one from more than 2 Lakhs records).
What is the SQL command? (You can get this in the view builder.)
What indices do you have? You should definitely have an index on the primary key. Some other indices MAY interfere.
>And other question is that whether we have to use explicit Lock even to update in View?
No, I don't think so. When you use optimistic buffering (usually the recommended approach, and the default for views, if I remember correctly), Visual FoxPro does all the required record locking implictly, when you try a TableUpdate(). When you use pessimistic buffering, Visual FoxPro implicitly locks as soon as a user starts editing a record.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)