ax用代码调用静态查询
static void AXD_CallQuery_SalesInfo(Args _args)
{
SysQueryRun queryRun = new SysQueryRun(querystr(AXD_SalesInfo));
SalesLine m_salesLine;InventTable m_InventTable;
;
if (queryRun.prompt())
{
while (queryRun.next())
{
m_salesLine = queryRun.get(tableNum(salesLine));
m_InventTable = queryRun.get(tableNum(InventTable));
if (queryRun.changed(tableNum(salesLine)))
{
info(strfmt("SalesID: %1,itemid:%2",m_salesLine.salesID,m_InventTable.itemId));
}
}
}
}
{
SysQueryRun queryRun = new SysQueryRun(querystr(AXD_SalesInfo));
SalesLine m_salesLine;InventTable m_InventTable;
;
if (queryRun.prompt())
{
while (queryRun.next())
{
m_salesLine = queryRun.get(tableNum(salesLine));
m_InventTable = queryRun.get(tableNum(InventTable));
if (queryRun.changed(tableNum(salesLine)))
{
info(strfmt("SalesID: %1,itemid:%2",m_salesLine.salesID,m_InventTable.itemId));
}
}
}
}