>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
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."