Buffering mode and exclusive views question

[EMJULIAN]

Would the buffering mode of a form effect whether or not a view opens exclusive? I open all my views in one form (although they're used in several once they're open). I open them with
USE myView in 0 SHARED, and the database they're in is opened SHARED, and EXCLUSIVE is set OFF, but still the views open as exclusive, which is causing a few problems.

WHY??? Why are they still exclusive???

RRRRGHH. This is driving me bonkers!!!

Thanks for your help.
Eve

 

[MarciaAkins]

Hi Eve.

All a view is is a cursor whose definition (the SQL statement used to generate thcursor) is stored in the dbc.

Cursors (temporary tables - those files that have a .tmp extension when they have a physical disk presence) are always exlcusive to the location where they are produced.

It really doesn't matter anyway. User A most certainly cannot "see" a cursor produced by user B. So why is it troubling you that it is being used exlcusively?



Marcia G. Akins

http://www.TightlineComputers.com

 

[EMJULIAN]

The problem is that when I try to update the view (eventview.no_recs=eventview.no_recs+1) I get a "file in use by another user" error, even though I'm the only user. It always happens when I click on the grid to select a record before I try to update it. If I use the arrow keys, no error.

Any thoughts??
Thanks so much.

Eve

 

[MarciaAkins]

Hi Eve.

Yes. The problem is the grid, not the view ;-)

Set focus off the grid before you attempt to update the record by setting focus to some other object on the form.



Marcia G. Akins

http://www.TightlineComputers.com