Trey,
I'm confused about your answer - aren't cursors totally 'one datasession' like views? Assuming, of course, they aren't filtered tables. How could the buffering of a cursor in one datasession affect a cursor by the same name in another datasession/form - they should be totally different tmp files.
Barbara
>OIC.
>No, it only works on cursor in the current data session.
>Two approaches you could take
- If your app has some sort of form manager, then you can add something to it to go through open forms and see if the given cursor is open and table buffered - ugh :)
- Use views for the related tables instead, then you can add temp indexes on the view to your heart's content - or limit the view itself with view parameters.
I suggest the last approach.
