Category: Database

Design, definitions, structure, operations…

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:UsersTomAppDataRoamingRootsMagicAMT (change the “Tom ” to the Windows username. In this folder is a .DAT file for each connected Ancestry Member Tree (AMT). This file is a SQLite database containing tables named identically to a subset of the TreeShared RM…

Read the full article

Possible Orphaned Records in the Event Table

Problem I was going through my database looking for United States of America and USA in the Place, Place Details and Description fields on the Edit Person screen. I am using the following query for the Place field: — Place with less than greater than.sql SELECT e.eventid, e.placeid, –e.siteid, e.familyid, e.ownertype, — 0 = person;…

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

Where is this data?

I am trying to put query together that will get the information for the Date, Place, Place Details, Description, Citation, and media fields on the following screen: Pic 1 The put the following query together to get the above information: select et.ownerid, nt.surname, nt.given, et.eventid, et.eventtype, nt.birthyear, ft.Name, et.placeid, et.siteid, substr(et.date,4,4) as Ev_Date, –(select pt.name…

Read the full article

Where is the data stashed

Pic 1 The explanation for the Details field in the EventTable of the Data Definitions states Content of Description field in Edit Person fact/event pane. Pic 2 I take that to mean it should contain Marital Status: MarriedRelation to Head of House: Head in the above print screen. I created the following query to get…

Read the full article

ConfigTable RecID 1 #datadefinitions #config

ConfigTable RecID 1 DataRec Default The first record of ConfigTable consists of XML in the RecID field that stores various database file settings. The current version and its data can be restructured and displayed as follows (Values column to be verified): See sheet “ConfigTableDefaultRec1” on Database Design Spreadsheets.