Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem doing modifying stru to a table with memo fields
Message
 
 
To
15/03/2011 21:00:14
Kam Lee
SUNY-Health Science Center
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01503800
Message ID:
01503806
Views:
33
>>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform