M
Mark Davies
Guest
If both your buffers contain fields that are named exactly the same then the BUFFER-COMPARE will compare those fields only - the non-matching ones will be ignored. The example I gave would then still apply for the comparing bit and the cDifference variable will contain a comma-separated list of fields that did not match. If you are only interested in the one field and that should be the only difference then check that it is the only field in the list. I am guessing that you are looping through one table and then finding matching records in the other (similar to my example). If that is the case, the BUFFER-COMPARE statement would be the same: BUFFER-COMPARE TO SAVE RESULT IN cDifferences. If you look at the help for BUFFER-COMPARE you will note that you are also able to exclude certain fields from the compare. See if this might be the way you want to go - if not and you cannot use buffer-compare then let me know and I will show you how to dynamically loop through the fields in each of the buffers.
Continue reading...
Continue reading...