Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem doing modifying stru to a table with memo fields
Message
De
16/03/2011 12:34:51
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:
01503885
Vues:
30
>>>>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 ?
>>>>
>>>>Thanks in advance.
>>>>
>>>>Kam Lee
>>>>SUNY DMC
>>>>Brooklyn NY
>>>
>>>Try suggestions from this blog post Not enough memory for a file map
>>>
>>>SYS(3050, 1, 512*1024*1024)
>>>SYS(3050, 2, 512*1024*1024)
>>Thanks Namoi for the reply. I just tried the SYS(3050, 2, 1.5*1024*1024*1024) and ?SYS(3050, 1, 1.5*1024*1024*1024)
>>it did not work. Got the same error. Windows taskmanger showing vfp is using 1 giga of memory.
>>The table is about 467 mega byte large though. The fpt is about 400 mega.
>
>Try less memory, 512*1024 as suggested in the blog.
It works. Thanks Naomi!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform