- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
you can use queryDef to fetch the data from targetSchema as shown below
var conditionVar="@age > 25";// example condition
var recordSet = xtk.queryDef.create(
<queryDef schema={vars.targetSchema} operation="select">
<select>
<node expr="@std_id"/>
<node expr="@name"/>
</select>
<where>
<condition expr={conditionVar} />
</where>
</queryDef>
);
var allRecords = recordSet.ExecuteQuery();
for each (var rec in allRecords)
{
var var1=rec.std_id;
var var2=rec.name;
//your INSERT statement;
}
hope this helps.