Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Session opening tables SHARED
Message
From
06/12/2001 09:19:50
 
 
To
06/12/2001 05:32:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00590132
Message ID:
00590490
Views:
22
>>Hi all,
>> Open VFP7, select OPEN from the Data Session Window. Dialog prompts for DBF, EXCLUSE box checked. Tables can be modified.
>> Run any program, without SET ECLU commands (already ON), open table(s) EXCLUSIVE, program ends with CLOSE DATABASES.
>> Now I try to OPEN a table from the Data Session window, the EXCLUSIVE box is NOT checked. Tables open READ_ONLY. No SET DATA commands or DATASESSION commands have been issued anytime.
>>
>>Q. Is there anywhere I can set this behavior of the Data Session?
>>
>>TIA,
>>Pete
>
>Pete,
>Tables didn't open read_only. If any table is used in a workarea where already in use then the behaviour you describe occurs (data session exclusive mark not resembling the current set exclusive). But I couldn't see open read_only behaviour. (Honestly I don't see it as a problem, almost forgot there were such a window). As a fix calling set exclusive explicitly after prg works :
>
>CLOSE DATABASES ALL
>lcExcl = SET("Exclusive")
>SET exclusive &lcExcl
>
>Cetin

Thanks Cetin,
I needed to verify that I wasn't going crazy. I opened and closed several DBF's from DATA SESSION right after starting VFP7. Only once did a DBF open Read-Only. I did not do anything else. Just opened and closed DBF's from DATA SESSION. All DBF's on a Novell server. Workstations are W2K. Problem doesn't exist in VFP6. I thought perhaps this was normal behavior for VFP7.

Here, 90% of our work is done from the COMMAND and DATA SESSION windows. Very few applications are written because we get different new clients every day. The few steady, repeating clients we have are the only ones with applications. Half of the six programmers have never written an application.

Pete
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Reply
Map
View

Click here to load this message in the networking platform