XDC Cache Query "no such column: should this be a string literal in single-quotes?"
Bryan Baca
started a topic
2 days ago
An XDC Cache Query contains a WHERE clause with double quotes. Example:
SELECT * FROM 'Sales'
WHERE Country="USA"
In InfoBurst versions 2026.2 and later, a SQLite version is used where double quotes in a WHERE clause are not allowed and result in the following error:
Query failed to execute ==> Failed to execute Cache Query 'SELECT * FROM 'Sales' WHERE Country="USA"' :: SQL logic error no such column: "USA" - should this be a string literal in single-quotes?
This is a known issue with later SQLite versions. The solution is to replace the double quotes with single quotes.
Bryan Baca
An XDC Cache Query contains a WHERE clause with double quotes. Example:
SELECT * FROM 'Sales'
WHERE Country="USA"
In InfoBurst versions 2026.2 and later, a SQLite version is used where double quotes in a WHERE clause are not allowed and result in the following error:
Query failed to execute ==> Failed to execute Cache Query 'SELECT * FROM 'Sales' WHERE Country="USA"' :: SQL logic error no such column: "USA" - should this be a string literal in single-quotes?
This is a known issue with later SQLite versions. The solution is to replace the double quotes with single quotes.