Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening all dbfs in a directory
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01585571
Message ID:
01585830
Views:
63
>Borislav gave you the code.
>
>Keep in mind that this will not guarantee the file is not corrupt. It will simply tell you if it can be opened.

That is exactly what i wanted it to do - it enables me to spot the corrupt tables and replace them from a backup

Thanks for your help

>
>
>>This is my code - it opens the first database and then errors trying to get the second with Funcion argument value type or count is invalid - I must be missing something very obvious
>>
>>CLEAR
>>CLEAR ALL
>>SET EXACT ON
>>SET TALK off
>>SET DEFAULT TO c:\global
>>PUBLIC dbfs,cta
>>DIMENSION dbfs(1000)
>>DIMENSION gadatabase(1000)
>>gadatabase=""
>>
>>
>>gnDbcnumber = ADIR(gaDatabase, '*.DBF') && Create array
>>FOR nCount = 1 TO gnDbcnumber && Loop for number of databases
>>dbfs(ncount)=gadatabase(ncount,1)
>>ENDFOR
>>
>>
>>STORE ncount TO cta
>>
>>DIMENSION dbfs(cta)
>>
>>
>>FOR xxxx=1 TO cta
>>STORE ALLTRIM(dbfs,xxxx) TO tablex
>>tablex=ALLTRIM(tablex)
>>USE &tablex IN 0 SHARED
>>next
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform