I tested this in 7.6 and I get a CURSOR lock. Variable form. The variable lookup listview where clause has retrieved 0 rows. The lock persists until I close the form.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Thursday, March 10, 2011 12:09 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Variable list view << If the list view does not set a lock, can a lock somehow get "stuck" and not release? This table shows a row lock 100% of the time, but the only object accessing it is the list view. >> Yes, there are circumstances in which locks get set and the only solution is to have all users disconnect and then have a single user connect the database with no one else in it. I don't know the chain of circumstances necessary to reproduce it (may require simultaneous DOS and Windows access, for all I know), but do see it happen fairly frequently. The listview should not be setting a lock by itself. -- Larry
