0002948: Error in server query using "with"

ID	Project	Category	View Status	Date Submitted	Last Update

0002948	CaseTalk Modeler	Repository	public	2021-03-26 12:42	2021-03-26 12:44

Reporter	BCP Software	Assigned To	BCP Software
Priority	normal	Severity	minor	Reproducibility	sometimes
Status	resolved	Resolution	fixed
Target Version	12.0	Fixed in Version	12.0

Summary	0002948: Error in server query using "with"
Description	Using a "with ..." statement in the server repository fails with an error dialog, yet shows the result set correctly.
Tags	No tags attached.

CaseTalk Edition	unknown

BCP Software 2021-03-26 12:42 administrator ~0001954	image001.png (25,368 bytes) image001.png (25,368 bytes)

BCP Software 2021-03-26 12:44 administrator ~0001955	The driver framework fails by wrapping the "with" statement in a "select count(*) from (query)" for retrieving a record count from the server. This error is specific to sql server and now handled as such.

Date Modified	Username	Field	Change
2021-03-26 12:42	BCP Software	New Issue
2021-03-26 12:42	BCP Software	Status	new => assigned
2021-03-26 12:42	BCP Software	Assigned To	=> BCP Software
2021-03-26 12:42	BCP Software	Note Added: 0001954
2021-03-26 12:42	BCP Software	File Added: image001.png
2021-03-26 12:44	BCP Software	Status	assigned => resolved
2021-03-26 12:44	BCP Software	Resolution	open => fixed
2021-03-26 12:44	BCP Software	Fixed in Version	=> 12.0
2021-03-26 12:44	BCP Software	Note Added: 0001955