Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.5.00
-
None
-
Rank:0|i00167:
-
Constraints - Value, Queries
Description
Query-by-value fails to find observation-facts because an quotes are inserted into the SQL where clause. For example, rather than "where tval_char = 'Malignant'" the SQL is generated as "where tval_char = '"Malignant"'
The fix is to remove the quotes from line 518:
sEnum = '("'+sEnum+'")';
remove extra quotes -- change lin e 518 to
sEnum = '('+sEnum+')';
The fix is to remove the quotes from line 518:
sEnum = '("'+sEnum+'")';
remove extra quotes -- change lin e 518 to
sEnum = '('+sEnum+')';