static void Cyborg3QueryBuild2(Args _args)
{
Query query;
QueryRun qr;
QueryBuildDataSource qbds;
QueryBuildRange qbr;
VendTable vendTable;
query = new query();
qbds = query.addDataSource(tableNum(vendTable));
qbr = qbds.addRange(fieldNum(vendTable, VendGroup));
qbr.value('10');
//here is the line where I thought I could control the sort direction
qbds.addSortField(fieldNum(vendTable, AccountNum),SortOrder::Ascending);
qr = new QueryRun(query);
if(qr.prompt())
{
while(qr.next())
{
vendTable = qr.get(tableNum(vendTable));
info( vendTable.AccountNum);
}
}
}
Like this:
Like Loading...