Exploit your RootsMagic family tree database with SQLite Tools
Operations on persons and families and relationships, esp on PersonTable, FamilyTable and ChildTable.
Description One query lists all the media files in the RM4 Media Gallery and the ID of the Person, Family, Event, Source, Citation or Place to which each is linked. Used in conjunction with other queries, one can look up the media item or find the details about the item to which the media are…
RootsMagic 5 and below support for Ahnentafel numbering is limited to 32 bits, or 32 generations, even though the report allows the user to select a larger number. If the report does run over 32 generations, the Ahnentafel number starts over and is therefore incorrect. This query demonstrates that SQLite itself can support a 64…
I have been running into some subtle little problems with queries and sub-queries that suggest to me that I don’t have an adequate understanding of the scope of names within SQL. To that end, I created the following very trivial queries to test against both SQLite and MS Access. — Test query #1 SELECT Z.PersonID…
This discussion was started around the Database System Catalog page and all posts up to its continuation on this page can be reviewed in full here. In summary, MarkVS posed this problem: One thing that I wanted to do, and I expect might be of interest to others, is to be able to stream all…
The birth of a child is a major life event for a person so I thought it would be worth adding to the stream of events query for a person. This query is designed to be pasted into the AllFacts4Person5.sql file – it follows the same columnar format – or it can be run on…