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

rbuser · April 2016

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

nicocizik · 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),
)

rbuser · April 2016

Are you using v4 of NexusDB, Nico?

nicocizik · April 2016

Hi Paul,

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

rbuser · 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

nicocizik · April 2016

A patch is now available for RB 17.01 that solves this issue.

Contact support@ to obtain this fix.

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

Comments