Views locking records.

[EMJULIAN]

I have a form with 4 grids that are using 4 different views as their datasources. I open the views and other tables in form A using:

Use Database
Use myView in 0
select myView
set index to.....

then I run form B, which is where the views are actually used.

The problem I am having is occasionally when trying to write to a view that is attached to a table I get a "record is in use by another user" error. Except that I am the only user and it's a local table. I select the view and then it hangs up at:

replace eventview.no_entries with eventview.no_entries+1

The problem is it doesn't do it all the time and I can't see a pattern so I can't figure out what's causing the record to lock (the status is exclusive even when the error occurs).

Any one got any ideas???
Thanks!

Eve

 

[Mike Gagnon]

Set the DataSession to private on your forms.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.