Exploit your RootsMagic family tree database with SQLite Tools
This script answers the question, “How long have marriages lasted?”. For each Marriage and corresponding Annulment or Divorce event for a couple, it extracts the year of the events and also gets the year of the death of the earlier of the two to have died. It then calculates the length in time between the…
Update 2021-03-11: #RM8 version by Pat Jones added. Having the married name of a person as an Alternate Name can be useful to those more familiar with it than the birth name as per LessTX’s posting on the Wish List: Add Married Name as Alternate Name and has been requested over the years in these…
Installing the ODBC driver and setting up the link to the RootsMagic SQLite databse is decribed in the the “MS Access Engine” page. This will allow you to look at the contents of your RM database Tables individually. In fact it will also allow amendment of data unless you set the Access tables to be…