Author: momakid

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

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

Exporting Data

My RootsMagic file has over 8,500 people in it, 23,000 events, 3,000 families, 3,000 citations, and 3,600 multimedia links I have a query that takes a bit to run. I am using sqlite expert Personal 5.2. I am trying to export the results of the query to a spreadsheet. So far I have not found…

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