Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

amritak94288453
amritak94288453
Offline

Badges

Badges
5

Accepted Solutions

Accepted Solutions
1

Likes Received

Likes Received
2

Posts & Comments

Posts & Comments
2

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by amritak94288453
Customize the badges you want to showcase on your profile
Re: How to get the id after insert (Auto PK= True) - Adobe Campaign 20-07-2018
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))

Views

786

Like

1

Replies

0
How to get the id after insert (Auto PK= True) - Adobe Campaign 19-07-2018
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

Views

943

Like

1

Replies

2
Likes from