Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Packing a database
Message
 
À
02/08/2006 09:21:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows 2000
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01142372
Message ID:
01142375
Vues:
8
>Hi all,
>
>We have a support issue here from a client who has been using the system for 7 years. It seemed to have stop writing to a certain table.
>After a while I figured if I delete one record and packed the table, the program could go back to writing to the file without any problems. I tried packing withour a delete and that didn't work. I was surprised it reached some sort of limit. I though they could take up to 2 GB. The .dbf file is only 493KB.
>I was wondering does anyone have an explanation about why it suddenly stopped. Also is there a way to pack the file without having to delete one record?
>
>Any help would be much appreciated,

Did you have Memo/General/Blob field(s) in that table? If so keep in mind that the limit of 2GB is also valid for FPT files.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform