Category: Database

Design, definitions, structure, operations…

RMTREE Properties Query for RM8

This is an ‘upgrade’ from RMGC_Properties – Query #database for pre-RM8 databases. It provides an expansion over the information provided on the RM8 Home – File Properties screen. With a SQLite manager that supports runtime variables, a summary report can be given (just those variables with no leading hyphen). It ATTACHes a reference empty, unused…

Read the full article

Trying to find duplicate spouses

I am trying to find duplicate spousess. I created the following query: select fatherid, (select n1.surname || “, ” || n1.given from nametable n1 where fatherid = ownerid) as fathername, motherid, (select n2.surname || “, ” || n2.given from nametable n2 where motherid = ownerid) as mothername from familytable order by fatherid, motherid; 1. Should…

Read the full article

Backup database open in both SQLite and RootsMagic #backup

Problem Neither the RootsMagic File>Backup nor File>Copy can proceed because the database file “is being used by another process” (RootsMagic’s own or your SQLite manager or other outboard SQLite connection). And if you’ve chosen Backup, RM gracelessly blocks you from further work with an always-on-top fake news message window “Creating backup file…” requiring closure of…

Read the full article

DAT File Question #ancestrycom #treeshare #database

I found some discrepancies in RootsMagic and posted a question. This was in an answer: C:\Users\Tom\AppData\Roaming\RootsMagic\AMT (change the “Tom ” to your Windows username). In this folder is a .DAT file for each connected Ancestry Member Tree (AMT), named “AT-AncestryTreeID.DAT”, where AncestryTreeID is an integer. This file is a SQLite database containing tables named identically…

Read the full article

Database is locked

Is it possible to open the databases as read only? Obviously SQLite is opening the database for edit capability. I am getting the database is locked when I have the database open in sqlite and try to open RootsMagic. I am 95% of the time using sqlite for query only. I rarely do an update…

Read the full article