since ‎14-12-2017
‎10-12-2019
amritak94288453
Level 1
Re: How to get the id after insert (Auto PK= True) amritak94288453 - Adobe Campaign Classic
I was able to achieve it as below . Problem with inserting and then selecting is it does not guarantee the right id because of parallel transactions. So I had to do the below var sql4 = "WITH upd AS (INSERT INTO SamTempOptout (sOldEmail,iBlId,iRId,iOptOut) values ('"+ vOldEmail + "'," + vblId + "," +vrId + "," + vOptOut + ") RETURNING iTempOptoutId) SELECT iTempOptoutId FROM upd ";document.write("sql4 = " + sql4 );ctx.vars.TempOptoutId = String(sqlGetInt(sql4))
458
Views
1
Like
0
Answers
How to get the id after insert (Auto PK= True) amritak94288453 - Adobe Campaign Classic
xtk.session.Write();In the above I want to get back the id value for the above schema after the insert. Schema has autopk=truePlease help
609
Views
1
Like
2
Answers and Comments
Likes from