This script moves the entire contents of event descriptions of a selected fact type to the Note for that event. If there is already content in the Note, the Description value is appended as a new paragraph.
To select a Fact Type, you must use a SQLite manager that supports SQLite run-time variables, such as SQLite Expert Personal (SQLiteSpy does not). When the query is run, a box will pop out prompting for the entry of the Fact Type’s abbreviation. This is the label as seen in the Edit Person screen. By entering the wildcard character (%), all Fact Types having the Description enabled will be processed.
EventDescriptionToNote-Move.sql
— adapted from Events – Move Short Note to Description
When I run this I get an error. Here is the message
cannot start a transaction within a transaction SQL Statement: — EventDescriptionToNote-Move.sql /* 2016-05-08 Tom Holden ve3meo — adapted from EventNoteToDescription-Move.sql Moves content from Event Description (Details) to Event Note.