Nível 1
Nível 2
Faça login na Comunidade
Faça logon para exibir todas as medalhas
Update not working when adding data to temp table and Js is not throwing any error but it is updating any tow. Any suggestions
var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);
logInfo("Schem name = " +schemaName);
var formatString = function(str) {
blah blah blah..........................
return str;
}
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@Label"/>
<node expr="@FullName"/>
<node expr="@lineNum"/>
</select>
</queryDef>);
var resultSet = query.ExecuteQuery();
for each (var row in resultSet.enrich5)
{
//instance.vars.Label=formatString(row.@Label);
//logInfo(formatString(resultSet.enrich5.@Label));
xtk.session.Write(<query _operation="update" _key="@lineNum" Label= {formatString(row.@Label)} xtkschema="temp:enrich5"/>);
}
Visualizações
respostas
Total de curtidas
typo it is not updating any row,
Visualizações
respostas
Total de curtidas
Hi
Here is working code that I have; maybe this will help:
xtk.session.Write(<query xtkschema="temp:query" _key="@id" id={id} email={email} status={status} status_description={status_description} date={date} />)
Let me know if that works.
Dan
Visualizações
respostas
Total de curtidas
It's not working. Can you please let me why there is no reference of querydef variable or operation=update in the above code.
Visualizações
respostas
Total de curtidas
Hi Srikanth,
Instead of using the xtk.Session.Write, you can use the below statement to update the TempSchema :
sqlExec("update "+vars.tableName +" set abc='0' where bcd="+123);
Let me know if this works.
Regards,
Kapil
@Kapil_Sharma_ is this for ACS for ACC?
@srikanthr646926 @daniell35335226
I am looking for help on ACS
Visualizações
respostas
Total de curtidas
Visualizações
Curtida
respostas
Visualizações
Curtida
respostas
Visualizações
Curtida
respostas