Exploit your RootsMagic family tree database with SQLite Tools
Superseded 2015-01-25. See Living Flag – Set Globally. I’m posting my version of SQL for Set Living. It proves to be remarkably similar to Tom’s. SQL #1, we turn on the Living Flag for everybody in the database. Essentially, we make everybody private and then followup later by setting individuals as not private when they…
Superseded 2015-01-25. See Living Flag – Set Globally. Discussion in RootsMagic-Users pointed out some limitations with the Set Living tool in RootsMagic and the risk of unsetting persons that have been previously set correctly. This page discusses how SQLite might help and is intended to start the development of some useful queries. The Living flag…
Finally! A script that sets the Living flag globally without having to be run repeatedly until all ancestors are accounted for. It does so with the recursive query feature introduced in SQLite3 in 2014 (see the page Recursive Queries – Ancestors and Descendants for more background). This script supersedes prior efforts by Tom and Jerry,…