Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Findout corrupted dbf
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01172800
Message ID:
01174652
Views:
10
>Dear Sir,
>
>But in your codes, there is no reference of
>workdir=getdir()
>
>Please help again
lcWorkDir = getdir()
lcBadFiles = ""
on error llBadFile = .t.
lnDBFs = adir( laDBFs, lcWorkDir + "*.dbf" )
for lnI = 1 to lnDBFs
  llBadFile = .f.
  use ( lcWorkDir + laDBFs[ lnI, 1 ] )
  if llBadFile
    lcBadFiles = lcBadFiles + laDbfs[ lnI, 1] + chr(13)+chr(10)
  endif 

endfor 

strtofile( lcBadFiles, "c:\corrupt.txt" )
on error
I just put in front of the parm within ADIR(), then when opening the file via USE ...
Previous
Reply
Map
View

Click here to load this message in the networking platform