Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
2 GB Limit!
Message
De
18/06/2004 09:09:49
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
18/06/2004 07:46:18
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00914959
Message ID:
00914991
Vues:
8
>I had seen some messages about that but had thought it can't be occurs on my customers. It occurs now....
>
>Please Helppppppp!!!! What I have to do !!!!!!!

If your table is corrupted, you may have to restore from an older backup.

For a long-term solution, I think it might be better to consider C/S - one that supports larger tables. Or, you might try to split tables horizontally or vertically (horizontally: separate by month, by client, etc.; vertically: put some fields in a separate table, with a one-to-one relation).

For an emergency solution, see if you can save space in any fields - for example, by changing some numeric fields to integer, by making character fields slightly smaller, etc.

Also try the other suggestion you received: delete some old data (moving it to a history table, if you want to keep the data). Note: This may be somewhat problematic, if you use RI. You may have to delete or move data from related tables, as well.

Greetings,

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform