>>>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.
Up to vfp8 only 512MB was well supported. if you really need more RAM for faster SQL for instance, use vfp9