Database merge using Foxpro 8.0

[Aseem1234]

Hello,

I have merged two databases together, an old and a new one, that have the same data. I used a union all because I have a memo field called Notes in each of them. I then store this merged table into another table on the local hard drive. When I load this data into a userform, all the other fields match, however, certain records have the wrong Notes or nothing at all...

I do this on many computer and each user is getting different results...some have the correct notes, other do not, and other have no notes at all...

Can someone help me?

 

[BPeisch]

It could be that you have corrupted pointers in one of the original files. Make a backup copy of each of the original files and try to PACK MEMO. Then confirm that they each point to the correct notes.



-BP

http://www.peisch.com