Hi All, It appears that when using the runPrepUpdate() (and the named query equivalents) function and setting getKey to True that MSSQL uniqueidentifier primary key columns are not returned unlike bigint identifiers. With getKey set to true the function returns a 0, with getKey set to false it corr…

It's not supported, if you look at the function signature you can see the return type is currently Integer.

Do query functions using getKey=True support MSSQL uniqueidentifier data type?

pturmel February 12, 2024, 7:38pm 5

So, I managed to nerd-snipe myself. And in the process, added another reason to avoid MS SQL Server like the plague.

1 Like