Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ff_scan FoxFix 5.1
Message
 
 
To
27/12/2004 07:16:07
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00972194
Message ID:
00972308
Views:
15
I can open the file in VFP without any problem. I will follow your suggestion and copy the file. By the way, does VFP create new header in the new file to which I am copying?

>Hi Dmitry, can you open the file in VFP normally? If so then copy it to another filename using VFP COPY TO command and see what FoxFix says about this new file.
>
>
>>Hi Jos,
>>Yes, I tried to load the table into the FoxFix. It immediately tell me that there are "inordinate number of errors ..." and FoxFix says that most likely the problem is with the Header Record Count, Length, or File Length. Therefore, FoxFix recommends to fix those problems first before scanning the table. FF_SCAN() is the only way I know of to correct the table header problems but it in effect trashes the table. So I am sort of in the catch 22.
>>
>>>Hi Dmitry. Have you tried running FoxFix on the file in interactive mode via the FoxFix app? That should tell you what it "thinks" is wrong with the file.
>>>
>>>
>>>>I have a DBF table (with associated .FPT and .CDX) and the database container. The table has approximately 170,000 records. When I open the table (using USE command) in VFP 6 I can see all the records, no obvious problem. But after I check the table with FF_SCAN using the following syntax:
>>>>
>>>>iRes = ff_scan( cDbfName, -1 )
>>>>
>>>>
>>>>the table is completely trashed. That is, when I USE the table in VFP 6 all records look garbled, completely trashed.
>>>>
>>>>What do you suggest could be the problem?
>>>>
>>>>Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform