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
