Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Progress Status during Append
Message
De
27/11/2002 11:52:00
 
 
À
27/11/2002 11:41:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00705246
Message ID:
00727618
Vues:
9
Does Stonefield have the ability to show progress during a pack, or does it just handle the rebuilding of the relations?

>>>Any other ideas?<<
>Certainly. Use Stonefield Database Toolkit. It handles all this for you and much more.
>
>
>
>>Thanks for the idea, but this won't work if you have long field names or persistant relations in the database container. They will be lost using this method. The long field names can be saved by using the database clause in the copy command:
>>
>>COPY TO ... FOR !Deleted database XYZDBC
>>
>>This will not save the relations though. The option then is to do the copy, then ZAP the original file, then append the records back from the copy. Both append processes can use the ShowProgress() function, but this can be a very long process.
>>
>>Any other ideas?
>>
>>
>>>Hi Mark
>>>
>>>Essentially PACK is just copying all non-deleted records to a new table. Therefore instead of PACK you could just use COPY TO ... FOR !Deleted() and showprogress().... and then rename the target file and delete the original file when finished.
>>>
>>>Jos
>>>
>>>>
>>>>Is there any way to do something similar with the PACK command. It does not support the for clause, but there are times when I need to pack large files and it would be nice to let the user know that something is actually happening.
>>>>
Mark Johns
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform