Exploit your RootsMagic family tree database with SQLite Tools
Sources. Source Templates, Citations, Master Sources, Source Details, Lumping, Splitting, Sorting,, …
RootsMagic 4 added the concept of Source Templates. With the new feature, no report functionality for it has yet been integrated into the Source List Print, however (RM 4.0.7.1, currently). This information might be useful in a number of applications, including in the case in which the initial Master Source/Source Details field split resulted in…
CTE Versions for RM7 and RM8 Revised code by Pat Jones using common table expressions:Version for RM7 and below AllCitations-RM7.sql tested 2021-01-20 Version for #RM8 and above AllCitations-RM8.sql revised 2022-04-27 to include duplicate uses Unlike the old version, this script does not appear to be able to display “headless citations” or “phantom sources or citations”…
This page was stimulated by a question Jerry Bryan posed in the discussion on the Submit Your Problem page about finding and viewing the value of the Page field for a Free Form template. That led to a series of SQLite queries culminating in this one that I thought warranted a page for further discussion…
This query deletes from the CitationsTable those records that have no associated record in the SourceTable. These ‘phantom’ sources or ‘orphaned’ citations manifest themselves in the Edit Person screen as citations that return nothing when opened, are counted in the File > Properties report and may have odd effect in other reports. The query is…