Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't get foxfix to write changes to table
Message
From
13/11/2001 13:34:54
 
 
To
21/08/2001 20:47:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00547039
Message ID:
00581014
Views:
19
David,
Did you ever resolve this issue? I have FoxFix 5.1 and am running into the same problems and some additional ones. As far as the additional problems go: I have 4 tables that ff_scan() returns errors on (but does not appear to be valid errors and it does NOT fix them), however I can open the tables fine in VFP. If I scan them with FoxFix 3.5, they return 0 (no errors). Strange... Trying to figure it out. The tables are type fox2x for compatibility issues. I want to implement the distributable dll with an app so I need to get the ff_scan working right.

Also, if I try to open the tables after running ff_scan on them, I get the 1705 error (file access denied). I have to close the app that runs foxfix completely before I can attempt to recreate or rebuild the files that foxfix has scanned (either returning errors or no errors -doesn't matter). Any ideas on how to get the tables all closed? I've tried flush and fflush() after running ff_scan() on them with no success.


Tracy



>Since I posted this, I have some additional information:
>
>For some reason, I am not able to get foxfixes ff_scan function to work right. it returns an error code of zero on a table that I know is corrupt.
>
>But I implemented a function call to 'dscan50x.app', and this is working like a charm. It finds and/or fixes the problems that I can't find with ff_scan() and fixes the problems I can only find, but not fix.
>
>But I still can't get Foxfix5.exe, via the gui interface, to write the changes to my tables.
>
>Any ideas?
>
>TIA
>
>>I have an email in to Xitech - but since it is late at night there now.. thought I'd try here first..
>>
>>I just got a new version of Foxfix - 5.1. I ran the standalone version to check the integrity of my dbf. Fox fix found errors in the fpt. (However the 'Memo Tab' itself has a green checkmark next to it) But the scan summary tab shows that there were 23 memo pointer errors. The 'messages' tab shows a final status code of '0000..' (Doesn't that indicate that there is no problem?
>>
>>However, the 'error log' tab shows 23 messages indicating memo pointer problems. Clicking the update button at the bottom right takes me straight back to the 'Filename to scan ' dialog box. When i click to scan the file again, it shows the same errors. The dbf and fpt never get updated.
>>
>>What am I doing wrong? Why does the memo tab itself have a green checkmark?
>>
>>
>>I found an 'old version' of foxfix from around 1997. It had a separate memoscan utility. I ran that against my table(s). It found and corrected the memo errors. I'm sure they have improved the product since 1997! not made it worse - so - I must be doing something wrong - need a new build -.
>>
>>Env: win98, don't think there are any file or folder permission issues, etc.
>>
>>Finally, I used the ff_scan function of the foxfix5.dll - it is NOT finding any errors with the file. Again, I am guessing that I am doing something wrong.
>>
>>Any ideas?
>>
>>TIA
.·*´¨)
.·`TCH
(..·*

010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform