你的位置：ww12345678 的部落格 | AX Helper > 网络文摘 > Dynamics 365 财务和运营 x++ While select 语句中的IN 关键字 / In keyword While select statement X++ Dynamics 365 for finance and operations

Dynamics 365 财务和运营 x++ While select 语句中的IN 关键字 / In keyword While select statement X++ Dynamics 365 for finance and operations

网络文摘 alirazazaidi 5年前 (2019-03-20) 1115浏览 0评论

Hi Today I found very interesting post here , where we can use “In” keyword for While select or Select statement. in will be enum based.

SalesTable salesTable;

container con = [SalesType::Sales, SalesType::ReturnItem, SalesType::Subscription];

while select * from salesTable

where salesTable.SalesType in con

{

Info(salesTable.SalesId);

}

reference :

D365/AX7:SQL IN Operator In X++ Where Clause (Enum Fields Only)

与本文相关的文章

如何在 D365 F&O 中手动创建物料批次/How to create Item Batch manually in D365 F&O
Consignment Inventory Handling in D365 Finance and Operations
通过移动设备取消采购订单行登记数量或通过 D365FO 中的采购订单删除库存/Unregister Purchase Order line register quantity which is received via mobile device OR Remove Stock via PO in D365FO
How to see if a Vendor Invoice has been settled or not/如何查看供应商发票是否已结算
在D365财务和运营中直接交付产品 / Direct Product delivery in D365 Finance and Operations
在不写代码的情况下，如何在D365财务和运营中为某个字段设置必填/How to set any Field mandatory without writing code in D365 Finance and Operations.

与本文相关的文章

Hi，您需要填写昵称和邮箱！