xtk.session.Write(<tempOptout xtkschema="sam:tempOptout" _operation="insert" rId={vrId} blId={vblId} oldEmail={vOldEmail} optOut={vOptOut} />);
In the above I want to get back the id value for the above schema after the insert. Schema has autopk=true
Please help
Solved! Go to Solution.
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))
Hi amritak94288453 ,
You will have to fire a queryDef using proper unique conditions, probably rId={vrId}, blId={vblId} and oldEmail={vOldEmail}
Regards,
Vipul
Views
Replies
Total Likes
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))