| Author |
DBF Files DELETED When PACK
|
|
|
| I found that VFP 6.0 would delete 'some' DBF files when PACK statement
is executed. Then, "File does not exists" error occurs.
However, this problem does not delete all my DBF files but just some of
them. I still cannot find its pattern.
Any idea?
Thanks.
| |
|
| DrWai wrote:
> I found that VFP 6.0 would delete 'some' DBF files when PACK statement
> is executed. Then, "File does not exists" error occurs.
>
> However, this problem does not delete all my DBF files but just some of
> them. I still cannot find its pattern.
>
>
> Any idea?
Well a PACK does something like this:
COPY TO tempdbf FOR NOT DELETED()
DELETE originaldbf
RENAME tempdbf TO originaldbf
Could it be that there is something odd about your temp folder?
--
Paul
| |
| Dan Freeman 2005-09-15, 11:24 am |
| Probably a user rights issue. There is some deleting and recreating going on
during a pack, but only if the table is large enough to warrant it IIRC.
Dan
Paul wrote:
> DrWai wrote:
>
> Well a PACK does something like this:
>
> COPY TO tempdbf FOR NOT DELETED()
> DELETE originaldbf
> RENAME tempdbf TO originaldbf
>
> Could it be that there is something odd about your temp folder?
| |
|
| Thanks for your reply. I have already find the pattern...for example:
- Create a table at c:\temp1\temp2\abc.dbf
- Append a record and then delete it
- Change the attribute of folder temp2 to invisible (hidden)
- Open the table again and then PACK
- Error "File Does Not Exist" should be prompted now
Paul, you are right...I found the temp file survived in the temp
folder. But, the problem is that PACK could not restore/rename the temp
file back to original, if ITS PARENT FOLDER IS HIDDEN.
Any suggestion? Or I need to write PACK step by step?
^^"
| |
|
| As I posted in this forum under another topic, FoxPro seems have
problem on handling hidden file...try this
- Create a plain text file c:\temp\abc.txt
- Set it to invisible
- Type command SET TEXTMERGE ON
- Type command SET TEXTMERGE TO c:\temp\abc.txt ADDITIVE
- Access denied error occur
|
|
|
|