Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    SELECT with ntext in WHERE clause

    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')

    #2
    Your issue is fixed, you can download next nightly build (2014-03-26) and try it out.

    Comment


      #3
      Thanks! I've verified with the latest build.

      Comment

      Working...
      X