Rootsmagic 7 increase tree
step #2 add a dummy Reference Number fact, step #3 run the main script. Reference Number facts before you start, it’s step #1 run the DELETE, Normally, it’s step #1 add a dummy Reference Number You will need add one dummy Reference Number fact to one person before NB!!! If you delete all Reference Number facts, WHERE EventType = 35 - facts before you Start. DELETE FROM EventTable - run this script if you want to delete all Reference Number Item #3 is probably the most significant difference. The three changes are: 1) provided a DELETE statement in case the colleague wanted to delete all existing Reference Number facts, 2) removed the references to a Group so the colleague would not have to make a group of everybody in his database, and 3) ran a MAX function on the EventID in the EventTable so the colleague would not have to look up the last EventID in the EventTable and plug it into the script. I rewrote the query slightly for a colleague. Discussions & comments from Wikispaces site If you want the REFN to appear first in the Edit Person screen, then set the SortDate of the dummy REFN to 1 before running the procedure. OwnerID - leading zeroesĪll of the added REFN facts will have every other parameter identical to that of the dummy REFN fact, including the same EditDate, hence it is preferable to use a dummy created on the same day that you run the procedure. OwnerID - leading blanks 'RIN' ||SUBSTR ( '000', LENGTH (N. WHERE OwnerID >=StartID AND OwnerID 9999): 'RIN' ||SUBSTR ( ' ', LENGTH (N. PersonID AS OwnerID FROM PersonTable P, GroupTable IsPrimary, IsPrivate, Proof, STATUS, EditDate, Sentence, 'RIN ' ||N. OwnerID, FamilyID, PlaceID, SiteID, DATE, SortDate , IsPrimary, IsPrivate, Proof, STATUS, EditDate, Sentence, Details, Note ) SELECT EventType, OwnerType, N. (EventType, OwnerType, OwnerID, FamilyID, PlaceID, SiteID, DATE, SortDate , Here’s the query: rev LabelValue instead of LabelID INSERT OR ROLLBACK INTO EventTable Return to the person you initially added the dummy REFN and delete it. When you next open your database with RootsMagic, you should see the newly added REFN facts in every member of your Named Group.