>>Some temporary directories are required. Also, RI must be disabled - or else, make sure you copy a parent table before you copy the child table.
>
>Hi Hilmar,
>
>Did you develop a technique for refilling the tables - disabling the RI or copying from the parent prior from the child ?
At first, I copied the parent table first, then the child table. The information about parent-child relations can be obtained with adbobjects(ArrayName, "relation"). Only relations where the third part (byte) is "R" (restrict) are relevant.
Later, I disabled the RI instead. I can do this, because I use TaxRI instead of standard Visual FoxPro RI. I recommend this tool (or perhaps other alternative RI builders, which I don't know).
TaxRI produces code which is about 1/10 of the size of standard RI code, and much easier to debug (in case you ever need to debug RI).
It also has some additional options, not found in standard RI - like the option to disable RI temporarily.
If you are interested, search the download section for LastName = "Meester".
>Do you use different names ?
Same table and database names, different directories.
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)