Re: PACK question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wolfgang Schmale (Spamkocher_at_strang.lt)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 14:24:04 +0200

Hi

As long as there is enough ram memory VFP does not create any file on the
disk for pack or for cursors. So if you run your test with a table which is
smaller than the available ram no file is created 

-- 
----------------------------------------------
Mit freundlichen Grüßen
Wolfgang Schmale
[MVP für Visual FoxPro]
--------------------------------------------
"emyron" <myron123@adelphia.invalid> schrieb im Newsbeitrag
news:1rudnZYZY7ibUbrcRVn-jw@adelphia.com...
> I apologize for a long explanation in the following question but I felt it
> was necessary to specify what I have already tried.
> When the PACK command is used for a table, in what directory is the
> temporary table created?  I assumed the temporary table was created in the
> same directory as the original table, but this apparently is not the case.
> To prove it to myself , I placed the table on a floppy disk and filled the
> rest of the disk with dummy files until the space left on the floppy was 0
> bytes.  VFP was started and the default directory was set to the floppy
> disk.  I then USEd the table exclusively and PACKed it.  The message
> indicated the correct amount of records were copied.  When I checked the
> size of the PACKed table, the FPT file was definitely smaller.
>
> I also tried a test where the config.fpw had all temporary file equates
set
> to the floppy disk and the table to be Packed was also on the floppy.  I
> made sure there was just enough room for the temporary files when I ran
VFP
> and opened the table exclusively.  Before running PACK I checked the
> contents of the floppy disk using a Command Prompt window.  The directory
> showed 3 temporary files and the table (DBF, CDX and FPT) files.  It also
> showed the dummy files I had used to fill up the disk and indicated there
> was 0 free bytes.  The PACK was run.  The table was successfully packed.
> Another examination of the floppy showed the 3 temporary files were still
> there (no change in size).  The FPT file was definitely smaller and the
> total amount of free bytes reflected a change in size of the packed FPT.
>
> The question still remains: where is the temporary table created during
> PACK?  I had a thought that it may be in the default WINDOWS\TEMP
directory.
> I have no way of monitoring this directory, so I can't be verify or
disprove
> the hypothesis.
> TIA,
> --E. Myron
>
>
> -- 
> To reply directly, change "invalid" to "net"
>
>

Relevant Pages

  • PACK question
    ... When the PACK command is used for a table, ... I placed the table on a floppy disk and filled the ... made sure there was just enough room for the temporary files when I ran VFP ...
    (microsoft.public.fox.programmer.exchange)
  • PACK question
    ... When the PACK command is used for a table, ... I placed the table on a floppy disk and filled the ... made sure there was just enough room for the temporary files when I ran VFP ...
    (microsoft.public.fox.helpwanted)
  • Re: PACK question
    ... I also verified there was 0 bytes of free space on the floppy ... disk after I brought up VFP and before running PACK. ... may be where the temporary files are created. ... > the special TMPFILES configuration item in your Visual FoxPro ...
    (microsoft.public.fox.programmer.exchange)
  • Re: why does my ppt save to disk as ppz?
    ... | when I select pack and go to save a ppt to a floppy, it saves on the disk ...
    (microsoft.public.powerpoint)
  • Re: disk full message, A: drive
    ... When you are working in a file, Word needs lots of space for temporary files. ... If you are working directly off a floppy there may not be room. ... Never have your ONLY copy of a file on a floppy disk, ...
    (microsoft.public.word.application.errors)