Get primary key of updated row on runPrepUpdate

Ignition
1

Hi everyone,

I would like to verify that using getKey parameter on runPrepUpdate on an Update statement does not give back the primary key of updated row? If this is correct, is there any way to get the primary key?

Thank you.

2

I don’t think so. Unlike an Insert statement, an Update statement can affect multiple rows, so there’s no generic facility for retrieving a primary key.

3

thank you! makes sense.