Hello All, I am running a very simple insert query that should return the identity key from a MSSql server. When I run the query below, and print the results I get a incrementing values (1316134921, 1316134922, 1316134923 for example). However, that is not the value I expected. It should have been …

The docs say that system.db.runPrepUpdate returns an integer, and 10000000000010 is too big for an integer. I suspect that 1316134921 is the value you get taking integer overflow into account, but I don't have time right now to verify.

runPrepUpdate getKey returning wrong value

Ignition

pturmel February 12, 2024, 7:51pm 8

An alternative is now available for those out there needing bigint primary keys:

1 Like