>I am sure this must be in the achives somewhere, but is there a clean way to compare two tables or a table and a cursor to determine if they are identical?
>
>Bill
AFIELDS() gets information about the fields. You can compare the two arrays, element by element.
This also gets lots of other information about the fields and about the table itself, which you may find useful comparing: validation rules, triggers. etc.
Depending on your needs, you may also want to compare indices.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
