Announcement

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

    Possible Bug on SQL Server attribute sqlStorageStrategy="ntext"

    I found a possible bug at the night build SmartGWT/12.0p/EnterpriseEval\latest at 19/12/2019

    When I try to fetch with Criteria textMatchStyle:"startsWith" on a field with attribute sqlStorageStrategy="ntext";

    The following SQL statement is generated!

    SELECT COUNT(*) FROM STYLE_SPEC WHERE (LOWER(STYLE_SPEC.SPEC_CAT) LIKEN'color%' {ESCAPE '\'} AND STYLE_SPEC.SPEC_CAT IS NOT NULL) on db: SQLServer threw exception: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near 'LIKEN'. - assuming stale connection and retrying query.

    LIKEN'color%' {ESCAPE '\'} ---- THERE SHOULD BE SPACE AFTER LIKE!!

    <DataSource
    dbName="SQLServer"
    tableName="STYLE_SPEC"
    ID="STYLE_SPEC"
    serverType="sql"
    >
    <fields>
    <field name="STYLE_SPEC_ID" primaryKey="true" type="sequence" hidden="true" ></field>
    <field name="SPEC_CAT" length="50" type="text" sqlStorageStrategy="ntext"></field>
    </fields>

    #2
    This is fixed and is available for download in latest nightly build.

    Comment

    Working...
    X