Hi,
I need to find the differences in 2 dbf's. They are identical in structure and largely identical in content also. I've searched here for best practices. The DBFCompare utility in the downloads section only analyzes the structure, so it's of no use here. Certain threats give some code to select differing records, but they all seem to have shortcomings.
What I have done regularly in the past is this:
SELECT ( table1 )
COPY TO table1.txt TYPE SDF
SELECT ( table2 )
COPY TO table2.txt TYPE SDF
and then compare with an external application that's capable of comparing text files, in my case Total Commander.
It works quite nice for me, in this case too. I thought: Let me add this tip here, since it's still missing.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
