- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Solution:
var query = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@lineNum"/>
</select>
</queryDef>
);
var result = query.ExecuteQuery();
var data = NLWS.xtkCounter.load(2521030); //id of counter
var c = data.value;
for each(var i in result) {
c++
data.value = instance.vars.c = c;
sqlExec("UPDATE " + vars.tableName + " SET sInternalName = 'SDM"+instance.vars.c+"' WHERE iLineNum="+i.@lineNum);
data.save();
}
Views
Replies
0 Likes
Total Likes