Isomorphic SmartClient/SmartGWT Framework (v9.1p_2014-03-23/PowerEdition Deployment 2014-03-23)
I've discovered an issue in SmartGWT 4.1 where an invalid SQL query is being created when using an ntext field as the criteria.
It is creating the query in the following format:
SELECT c1, c2, c3 FROM table WHERE (LOWER(c1)=n'criteria')
SQL Server will give the following error:
Incorrect syntax near 'criteria'.
The issue is that the n is lower-cased. The query should be:
SELECT c1, c2, c3 FROM table WHERE (LOWER(c1)=N'criteria')
I've discovered an issue in SmartGWT 4.1 where an invalid SQL query is being created when using an ntext field as the criteria.
It is creating the query in the following format:
SELECT c1, c2, c3 FROM table WHERE (LOWER(c1)=n'criteria')
SQL Server will give the following error:
Incorrect syntax near 'criteria'.
The issue is that the n is lower-cased. The query should be:
SELECT c1, c2, c3 FROM table WHERE (LOWER(c1)=N'criteria')
Comment