Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table with cursors in table buffering mode
Message
From
12/12/2000 14:03:48
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00452380
Message ID:
00452407
Views:
21
>>check CursorGetProp("buffering") - if it returns 4 or 5, then the cursors are table buffered.
>
>Yes, I know, but does this also cover cursors open in other datasessions?
>
>The error only occurs when I have two or more forms open simultaniously and when both forms have open cursors of the same table. The offending command is an "index on ..." statement to make a temporary index on a field in a related table. The error occurs if the related table is also open in another form.

OIC.
No, it only works on cursor in the current data session.
Two approaches you could take
  1. 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 :)
  2. 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.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform