d365technext: SQL In Operator in D365FO

[Blog bot]

Источник: http://d365technext.blogspot.com/201...in-d365fo.html
==============


SQL In Operator in D365FO


Microsoft Introduce In Operator in X++ Syntax, but it will work with Enums only.

Following are the example how you can use this


SalesTable salesTable;
container con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];
while select SalesId from salesTable
where salesTable.SalesType in con
{
Info(salesTable.SalesId);
}


Источник: http://d365technext.blogspot.com/201...in-d365fo.html