>>OK.. I see what you mean.. I will open all my tables and cursorsetprop() in
>>main.prg and close them at exit time...:)
>
>This is a huge performace hit when there is alot of transactions out there. Just dummy up a test tabel with 1.5 million transactions and delete 5% of them. When you type in USE TEST in 0 order XXX it coudl take up to 1 min just to regain control.
>
>This is why the views are better. You never need the entire 1.5 million records unless it's a report. So a parameterized view to 1000 records of the 1.5 million is in your best interest.
>
>There are indexing tricks to speed up performance here just to poen the file.
>Index on DELETED() is a must.
-----
Hi Stephen... Would you please send me a samll sample of code on how
you setup your VIEWS?.. thanks