uni parser problem
Posted: Wed 02 Mar 2016 12:08
Hi,
if you enter this query in a TUniQuery
it works. Note the semicolon at end.
But when try to change the order using SetOrderBy the ORDER BY is appended after the semicolon, causing an error.
When using the FilterSQL property the WHERE clause is inserted properly (if there is not an ORDER BY).
Off course to solve just remove the semicolon!
Still remain a small bug.
if you enter this query in a TUniQuery
Code: Select all
SELECT * FROM mytable;
But when try to change the order using SetOrderBy the ORDER BY is appended after the semicolon, causing an error.
When using the FilterSQL property the WHERE clause is inserted properly (if there is not an ORDER BY).
Off course to solve just remove the semicolon!
Still remain a small bug.