Nitin
1/11/2006 5:37:00 AM
Hi,
following is the example to get the on-hand inventory.
InventSum inventSum;
Query query = new Query();
QueryRun qr;
;
query.addDataSource(tableNum(InventTable));
query.dataSourceNo(1).addDataSource(tableNum(InventSum)).addLink(fieldNum(InventTable, itemid), fieldNum(InventSum , ItemId));
query.dataSourceNo(2).addRange(fieldNum(InventSum,
Closed)).value(Enum2Str(NoYes::No));
query.dataSourceNo(2).addSelectionField(fieldNum(InventSum,
AvailPhysical), SelectionField::Sum);
query.dataSourceNo(2).orderMode(OrderMode::GroupBy);
query.dataSourceNo(2).addSortField(fieldNum(inventSum, itemId));
qr = new QueryRun(query);
while(qr.next())
{
inventSum = qr.getNo(2);
print inventSum.ItemId, " - ", inventSum.AvailPhysical;
}
Cheers
Nitin Jain
"Fanatic" wrote:
> How can a build a query object for example to show all the items for which
> the quantity is greater than 0...???
>
> thx