Versions des environnements
>>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
Hi Al, thanks for your reply. I just tried your method but I got the same error during the excution of the COPY TO command. It ended up getting a incomplete copy of the original table.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement