Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views Locking Tables
Message
 
To
15/07/1997 11:13:59
Sonny Chouinard
CHCA Computer Systems Inc.
Lachenaie, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00039884
Message ID:
00040027
Views:
28
>>>Hi,
>>>
>>> It seems to me that you are opening your table (in the DE) exclusively. Set exclusive to off. That's probably why the others don't have access to some table when the form is opened.
>>
>>Well, you are correct. In the DE 'Exclusive' is set to true. Unfortunately the system will not let me change that value, perhaps because I am extending the OpenTables() method in order to create indexes on the remote views. Also, according to VFP help, "The Exclusive property has no effect on remote views." I am confused and stuck...
>>
>>George
>
>Have you set multilocks to .T. ?

In my 'Main' program I SET EXCL OFF and SET MULITLOCKS ON. Also, in the OpenTables method I have code that set mulitlocks on. Looks like this:

LOCAL ltmp
set multilocks on
nodefault
ltmp=dodefault()
if used('mins')
sele mins
index on m_min tag m_min
else
wait window 'Tabel MINs could not be opened.'
return .f.
endif
if !cursorsetprop('Buffering',5)
wait window 'Buffering could not be set for MINs table.'
return .f.
endif
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Previous
Reply
Map
View

Click here to load this message in the networking platform