Author: chief

AllCitations.sql Error

I am running the following query in SQLite Expert Personal 5.2(x86): — AllCitations.sql — 2010-01-28 ve3meo — Lists citations for each person — 2010-01-29 rev by ve3meo to use LEFT OUTER JOINS to include the most orphaned citations — Citations for Alternate Names, added column for NameTable.IsPrimary AS Uniq to all queries — and negated…

Read the full article

Removing media from one person

I attached the 1920 Census to the people displayed in the window below: I want to remove the media from Sophia only.and leave the media attached to the remaining people. Actual Results: I have Sophia’s record open, selected the media column for the fact, highlighted Sophia and pressed the Remove media button. It removes the…

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

Alternate Names List

I created alternate names for wives so I can find the wife with her married name. I put the given and maiden name in the given for the alternate name. I put her husband’s surname in surname. I use Married as Name Type, Mrs. As Prefix and the husbands given name with parenthesis around it…

Read the full article

ReportNon_proven #events

List non-proven Facts. This SQL query will report non-proven facts. This is useful when going though a non-sourced acquired database so you can go though all of the events and find a source for them. Download: Proven.sql Discussions & comments from Wikispaces site ve3meo Does it depend on LDS support turned on? ve3meo 06 April…

Read the full article

Database System Catalog #datadefinitions

RootsMagic 4 Database System Catalog A singular system table, sqlite_master, resides in a SQLite database. The table essentially defines the RootsMagic 4 database tables, indices, and fields as follows: type name tbl_name rootpage sql table AddressLinkTable AddressLinkTable 52 CREATE TABLE AddressLinkTable (LinkID INTEGER PRIMARY KEY, OwnerType INTEGER, AddressID INTEGER, OwnerID INTEGER, AddressNum INTEGER, Details TEXT…

Read the full article