Exploit your RootsMagic family tree database with SQLite Tools
Applications that use SQLite with the RM database or operate on RM’s inputs or outputs.
I like this: RMtrix has a magical element to it in the sound alike to “tricks” with an appropriate implication as to what the software does – it carries out tricks on the RootsMagic database. Also can work as an acronym: RM obviously, tools or tricks, repairs, information, experiments or an algebraic unknown variable, x,…
This page is intended to stimulate some discussion about developing utilities for RootsMagic in a high level programming language. Please add your thoughts. Would you be interested in: using utilities that do things RootsMagic does not currently do? developing such utilities? testing? Development Platform? I had been setting up an old Borland Delphi 4 with…
As an external utility for the RootsMagic genealogy program, what would it do, how would it look? Initially, it would take the many tweaks and modifications discussed on this site and roll them into a format that is usable for the average RM user. Rationale There are a lot of general database cleanup or modification…
This page is intended to group existing SQLite queries and future functions under a menu structure that parallels that of RootsMagic itself, with the idea that similar naming, order and, possibly, locations on screen may facilitate user navigation to the utilities most relevant to their area of interest or concern. This is a first draft.…
I wanted to report some further investigations into my quest to be able to write the same query only once for use both directly in SQLite and again for MS Access, with hopefully not a whole lot editing required to make the same basic query work in either environment. On the issue of what may…
I have been running into some subtle little problems with queries and sub-queries that suggest to me that I don’t have an adequate understanding of the scope of names within SQL. To that end, I created the following very trivial queries to test against both SQLite and MS Access. — Test query #1 SELECT Z.PersonID…
(This is for the MS Access section of the Wiki. I thought I was putting it there, but it didn’t seem to go there. I guess I’m still figuring out how to work the Wiki. Jerry) I’m about to describe what I think is a useful approach to some reporting problems that are of interest…
Microsoft Excel is a great tool for filtering/sorting/reporting on data in a Grid format. It also provides additional features such as various sorts of in-built graphs based on the data you are using as well as providing, for more advanced users, in-built calculation functions (formulas) that can be used to manipulate the data. Naturally, as…
Open Office has a database program (Open Office Base) and a spreadsheet program (Open Office Calc). Base can be connected via ODBC to a SQLite database in much the same way as has been described for Microsoft Access, using the same SQLite ODBC driver (See Part One of MS Access Engine). A .odb file is…
If you are using the Microsoft Access database engine to interrogate the RootsMagic SQLite database (see MS Access Engine and MS Access Engine – Event Query) then you will hit the problem that, on the face of it, Access does not ‘understand’ the BLOB fields within the SQLlite database. This wiki describes the workround that…