Razzak, Thanks for the suggestion.
In RRBYW18 the VarLookupListView does not cause a cursor lock. I did some experimenting and discovered that unchecking the "Display distinct values" box would cause the form to use a cursor lock. This was repeatable both in 9.5 and 9.1 Thankfully, this discovery gives us a workaround for most of our controls, but not all. There are scenarios where the displayed values are identical but there are multiple instances with different key values (key not displayed). In these cases the listview or combo box refuses to select rows with that condition, for obvious reasons. Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Friday, August 17, 2012 1:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Cursor Locks At 01:42 PM 8/17/2012, Dennis McGrath wrote: >We discovered today that we have variable forms where variable lookup >listviews and combo boxes create a cursor lock on the source table. > >Is there any way to avoid this, short of basing the controls on temp >tables? Without knowing all details and everything else behind your variable form, try the following simple test using R:BASE eXtreme 9.1 (RRBYW17) or R:BASE eXtreme 9.5 (RRBYW18) sample database which includes the variable "VarLookupListView" form that illustrates the use of Variable Lookup ListView control. 01. Start R:BASE eXtreme 9.1/9.5 and Connect to RRBYW17 or RRBYW18 EDIT USING VarLookupListView The variable lookup listview based on the Customer table. 02. Now Start a second session of R:BASE eXtreme 9.1/9.5 and Connect to the same RRBYW17 or RRBYW18 database. Using the database explorer, take a look at the Customer table. Do you see a LOCK on the Customer table? If the answer is NO, re-visit "your form" and everything else behind it. Hope that provides you with some blue's clues .... Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase
