HI
can anyone help me …
How can i use delete_from in query Object in Ax 2009 ?
while( queryExecuter.next())
{
salesTable = queryExecuter.get(tablenum(SalesTable));
delete_from salesTable;// it’s not working
salesTable.delete();// it 's working
info(“Orphan records are deleted”);
}
Jagaddish,
Couldn’t understand what exactly you wanna do with query.
Coz i already described that it can be used to filter or sorting or can provide range etc…
If you want to know regarding this delete_from refer here : http://msdn.microsoft.com/en-us/library/aa624886.aspx
Vishal,
objective of my x++ query is _ bulk delete all sales orders that are open(backorder) and don’t have a salesline ,
Now , i want to build query object for this query …
X++:
ttsBegin;
delete_from salesTable notexists join salesLine
where salesLine.SalesId == salesTable.SalesId
&& salesTable.SalesStatus == salesStatus::Backorder;
{
info(“Orphan records are deleted”);
}
ttscommit;
Query Object::
axQuery = new Query();
qbdsSalesTable = axQuery.addDataSource(tablenum(SalesTable));
qbdsSalesLine = qbdsSalesTable.addDataSource(tablenum(SalesLine));
qbdsSalesLine.relations(false);
qbdsSalesLine.joinMode(JoinMode::NoExistsJoin);
qbdsSalesLine.addLink(fieldnum(SalesTable,SalesId),fieldnum(SalesLine,SalesId));
qbrOpenOrder = qbdsSalesLine.addRange(fieldnum(salesTable,SalesStatus));
qbrOpenOrder.value(queryvalue(SalesStatus::Backorder));
queryExecuter = new QueryRun(axQuery);
while( queryExecuter.next())
{
salesTable = queryExecuter.get(tablenum(SalesTable));
// info(salestable.SalesId);
delete_from salesTable; // it’s not working
info(“Orphan records are deleted”);
}
Delete_from will not work in query.
Ok.
Thank You… 