Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exclusive Opened Files
Message
 
 
To
03/07/1998 03:10:43
Jayesh Vorani
Technova Imaging Systems Limited.
New Bombay, India
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00113989
Message ID:
00113998
Views:
19
>I have a table which has a single general field always holding the picture of the current record. I need to zap the file frequently as i navigate in the form so that it can hold the picture of the current record. for zapping i need to open the file exclusively in the data env. of the form. Same table is used in the other forms and is used exclusively there too. though the forms are having private data session i cannot open the two forms at a time since that table is opened exclusively in both the forms. Even this may create problems if forms are opened on diff. terminals in a network.
>
>Any Solutions?? Any Clues?? or any other option for storing the pictures? any help is appreciated.

It is mandatory to open tables in EXCLUSIVE mode when zapping files, and Opening tables EXCLUSIVELY can only be done one at a time. You can use a table as your model table and copy its structure into a temporary variable utilizing SYS(2015).
cfile = SYS(2015)

SELECT mymodeltable  && TABLE WITH GENERAL FIELD
COPY STRUCTURE TO &cfile

USE &cfile EXCL IN 0 ALIAS mypicttable
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Reply
Map
View

Click here to load this message in the networking platform