A VERY BIG PROBLEM

[SonicChen]

I have one table with 1 million records and some memo fields in VFP6. But i found some of the memo's content was the table's whole memo file's content. The length exceed 3M.
I think it's the vfp's bug.
How can i read the exact content of these memo or can only ignore it?
anybody else encounter this problem?

way to gold shines more than gold

 

[Mike Lewis]

SoniChen,

Do you mean that in a single record, you can see all the memos for all records? If so, there is definitely something wrong. I've never heard of that situation before.

Rather than a bug, it is more likely to be some sort of corruption in your table. I suggest you first PACK the table, then do a PACK MEMO. (But make a backup first, just in case.)

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[DSummZZZ]

You may also have reached the maximum file size limit on one or more of the files.
Is the table or memo file larger than or getting close to 2 gig?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[SonicChen]

oh yes, that's because of the corruption, not a bug.
sigh, i have spent much time to solve this problem...

way to gold shines more than gold