Category: Database

Design, definitions, structure, operations…

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

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

RootsMagic 7

RootsMagic 7 was released on 25 Nov 2014. It will take some time to answer the following questions: Which SQLite scripts on this wiki need to be revised? Identifying changes in the database design will trigger areas to investigate. Which ones can be retired? Requires comparing the functional capabilities of RootsMagic 7 to those of…

Read the full article