Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Autoincrement field problem with v17.01, Delphi Seattle and NexusDB

edited April 2016 in End User
If you set a search criterion against an field of type ftAutoIncrement
then the magic sql code generates a field value that is a string, not an
integer (e.g. '10' rather than 10) and you get an error:

exception message : NexusDB: : Query
execution failed: Type mismatch (nxtNullString <> nxtWord32) when
comparing at line 10, pos 12 [$3CA0/15520].

This is completely reproducible with the NexusDB demo project you
supply, although you will need to add a table into the database with
autoincrement fields. Or I can send support the demo project we are
running here.

TIA

Paul

Comments

  • edited April 2016
    Hi Paul,

    Sorry for the delay in this response.

    I tried recreating this on my machine (Delphi XE8, NexusDB 4, RB 17.01)
    but was unable to get the error. Below is the SQL I used to create a
    test table. Perhaps you can alter it or provide me a test table that I
    can use to see the problem in a simple application.

    CREATE TABLE TestTable
    (
    ID AUTOINC NOT NULL PRIMARY KEY,
    Name VARCHAR(255),
    )

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2016
    Are you using v4 of NexusDB, Nico?

  • edited April 2016
    Hi Paul,

    The test was performed using the latest version of Nexus DB 4. (4.0015
    Standard 32bit)

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited April 2016
    On 19/04/2016 14:34, Nico Cizik (Digital Metaphors) wrote:

    OK have emailed you demo project with one of our tables in it (hetype.nx1).

    Thanks, Paul
  • edited April 2016
    A patch is now available for RB 17.01 that solves this issue.

    Contact support@ to obtain this fix.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.