>Just add the next 2 statements just before the statement where the problem arises. Maybe the calling method/procedure should contain the statements:
>
>SYS(1104) && To prevent Out of Memory
>SYS(3050,1,1024) && To prevent memory error.
>
>Regarding to your memo file: this is normal behaviour. Only Pack memo will help you to make it smaller. Any change you make to a memofield will be added to de table. Even if you make one memo field in a record smaller, the fpt will grow.
>
>Hope this helps,
>
Thanks for the reply.
Last night during the wee hours, we were able to pack the table. That fixed the problem. I suspect the table header was corrupt even though VFP was reluctant to express so. The error only occurred when appending a record never modifying.
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature