Category: Database

Design, definitions, structure, operations…

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.

Data Definitions #datadefinitions

RootsMagic 4+ Data Definitions See spreadsheets “DataDefsMstr” and “DataDefsFieldSort” on Database Design Spreadsheets. Discussions & comments from Wikispaces site romermb Adding To/Updating File romermb 08 January 2010 21:35:48 A few of us so far have been trying to add the Notes, etc details to the various table fields in the file referenced in this page.…

Read the full article