Re - size of file -
File size is 14.2k.
Re - Does the app keep the tables open?
Yes, some tables are kept open as an alias, and just SELECTed when we need them. There are also tables that we open, read/write, and close again. The corrupted table I mentioned earlier was of the latter type. We open it, read or write to it, and close it immediately.
Re - Updating our tables? What do you mean? The regular VFP stuff, like
USE tablename IN 0 ALIAS aliasname
SELECT aliasname
APPEND BLANK
REPLACE fieldx WITH "value1"
USE IN aliasname
or SQL inserts. Nothing fancy.
>Paul:
>
>The size of the file that you get from your client is 0K also? if not, the >foxfix did not see the correct file. In the pass (10 year ago) I used >Norton Utilities to check that kind of problem. And we resolve the problem >creating a EOF caracter in the corrupted file. But that did not resolve >your problem. Another question, your application maintain open the master >tables? What kind of method do you use to update your tables?