Home

Tuesday, February 24, 2015

Query() and While Select in X++


We can use Query() class or while select statement to create a query on the table.

using while select statement

while select InventTable
ItemId == "123ABC";

using Query class

Query = new query();
query.addDataSource(tableNum(InventTable)).addRange(fieldNum(InventTable, itemId)).value("123ABC");

No comments:

Post a Comment