Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULL / Corrupted DBF files
Message
From
30/12/2002 16:43:24
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00736740
Message ID:
00736768
Views:
7
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform