Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem doing modifying stru to a table with memo fields
Message
De
15/03/2011 20:03:08
 
 
À
15/03/2011 19:44:52
Kam Lee
SUNY-Health Science Center
Brooklyn, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01503800
Message ID:
01503801
Vues:
48
>I got this error "Not enough memory for file map" when I tried to add a field to table structure. I got like 4 giga of memory. And I think the 3 memo fields in the table has something to do with the error. the FPT file seems somewhat having some corrupted data.
>There are like 50 different tables in the Database. Only one table is giving me the error.
>
>I can't add field to or delete field from the the table. I tried PACK , it ran without problem. But I am still getting the error when trying to
>add a field to the table. The table has 51 fields, record length: 484
>Is there any way to clean up the fpt file ?

One thing you could try:

1. Backup all your database and table files (including CDX, FPT etc.)

2. Copy all the data from the suspect table to a temporary one in the same database: COPY TO TempTable DATABASE MyDatabase ALL WITH PRODUCTION

3. See if you can successfully modify the structure of TempTable. If you can:

- Check that TempTable seems to have all the data
- Make sure you have a good backup!
- ZAP your original table
- USE the original table, and APPEND FROM TempTable
- Test to see if the issue with the original table is fixed
- If so, remove the TempTable from your database
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform