Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiuser environment question
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01151640
Message ID:
01151971
Views:
44
Khubaib,
Use this order in your programme:
SET EXCLUSIVE ON
*** don't delete cdx files
USE YourTable1
REINDEX

USE YourTable2
REINDEX
...
OR
m.NumberOfTables = ADIR(arrayfiles,"*.dbf")
SET EXCLUSIVE ON
FOR m.myvar = 1 to m.NumberOfTables
    TRY 
      USE (arrayfiles[m.myvar, 1])
      REINDEX
    CATCH
      MESSAGEBOX("Cann't open "+arrayfiles[m.myvar, 1]+" exclusive")
    ENDTRY
NEXT
USE
SET EXCLUSIVE OFF
But I have one simple question.
Why, Why, Why you need to delete all cdx, and create again???




>I have other problem, i index my all file in begning of programme, and also delete all cdx, and create again. i thing it is required exculsive on;
>i require change this???
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform