0002339: Generating SQL Expression View contains quote error

ID	Project	Category	View Status	Date Submitted	Last Update

0002339	CaseTalk Modeler	Generation (SQL, XML, etc)	public	2020-01-03 13:46	2022-01-10 20:40

Reporter	Marco Wobben	Assigned To	Marco Wobben
Priority	normal	Severity	block	Reproducibility	sometimes
Status	closed	Resolution	fixed
Target Version	9.9.0	Fixed in Version	9.9.0

Summary	0002339: Generating SQL Expression View contains quote error
Description	If the fact expression contains a single quote the creation of the database view, which expresses the tables, will contain an error. This error occurs since the single quotes are not escaped to form a valid sql statement.
Tags	No tags attached.

CaseTalk Edition	unknown

Date Modified	Username	Field	Change
2020-01-03 13:46	Marco Wobben	New Issue
2020-01-03 13:46	Marco Wobben	Status	new => assigned
2020-01-03 13:46	Marco Wobben	Assigned To	=> Marco Wobben
2020-01-03 13:46	Marco Wobben	Status	assigned => resolved
2020-01-03 13:46	Marco Wobben	Resolution	open => fixed
2020-01-03 13:46	Marco Wobben	Fixed in Version	=> 9.9.0
2022-01-10 20:40	Marco Wobben	Note Added: 0003940
2022-01-10 20:40	Marco Wobben	Status	resolved => closed

Marco Wobben 2022-01-10 20:40 administrator ~0003940	Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.