0005497: Import reference data crashes on schema names containing SQL reserved words

ID	Project	Category	View Status	Date Submitted	Last Update
0005497	CaseTalk Modeler	Other	public	2026-03-30 23:26	2026-03-30 23:32

Reporter	Marco Wobben	Assigned To
Priority	high	Severity	crash	Reproducibility	have not tried
Status	resolved	Resolution	fixed
Fixed in Version	15.0

Summary	0005497: Import reference data crashes on schema names containing SQL reserved words
Description	CaseTalk crashes with an SQLite syntax error when importing reference data from a project whose schema name contains a word that SQLite treats as a reserved keyword (e.g. a name containing 'Master'). The schema name is used unquoted in a generated SQL statement, which causes a parse error. Fix: quote schema names in the generated SQL.
Tags	No tags attached.

CaseTalk Edition	Corporate

Date Modified	Username	Field	Change
2026-03-30 23:26	Marco Wobben	New Issue
2026-03-30 23:26	Marco Wobben	View Status	public => private
2026-03-30 23:31	Marco Wobben	Note Added: 0005936
2026-03-30 23:31	Marco Wobben	Status	new => resolved
2026-03-30 23:31	Marco Wobben	Resolution	open => fixed
2026-03-30 23:32	Marco Wobben	Fixed in Version	=> 15.0
2026-03-30 23:32	Marco Wobben	View Status	private => public

Marco Wobben 2026-03-30 23:31 administrator ~0005936	Fixed in MainDmdUnit.pas ImportReferenceDataActExecute: introduced qSchema local variable with double-quote escaping (same pattern as XlsToDb). Used qSchema instead of raw schema in the three ExecSQL calls for casetalk_settings (create table + 2x insert). Attach() was already safe — it uses Format('attach ''%s'' as "%s"').