Exploit your RootsMagic family tree database with SQLite Tools
Operations on Places and Place Details, esp on the PlaceTable
The LifeLines query lists all events for all persons whether in a database tree or not, including shared facts, date, fact detail, site and place, MRIN, other parties, duplication indicator and IsPrivate flag (new!). Sorted by RIN and Sort Date. With the right SQLite manager, can filter results for one person. It’s a successor to…
FactsHavingPlaceDetails3.sql Returns all Places with Place Details and the Persons or Families (couples) and their Facts, including Shared events, using the Place Detail. Results from FactsHavingPlaceDetails3 as displayed by SQLiteSpy FactsHavingPlaceDetails2.sql Returns all Places with Place Details and the Persons or Families (couples) and their Facts using the Place Detail. No shared events. A comprehensive…