Can I change a field's ObjectPtr target BaseObject without losing the field values?

[Keith DeLong]

In an existing V4RB database, I have a  number of ObjectPtr fields that
point to a table. I need to point all these to a different table in an
upcoming release.

I populate the new table using a record order identical to the old one (thus
preserving the recID). When I next change the target baseobject on the
ObjectPtr fields to point to the new table, the existing ObjectPtr field
values are all set to 0. This destroys all my table relationships.

Is there a workaround to this behavior? Do I have to export each table's
ObjectPtr field values and then reimport them into the field after changing
the its target baseobject? Any other ideas?

I have a pretty good size customer base with up many years worth of data so
this has to be accomplished programmatically from within REALbasic.


Thanks,
Keith DeLong