你的位置：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 7年前 (2019-03-20) 1464浏览 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)

与本文相关的文章

10.0.39 中的管理员调配工具在哪里？/Where is admin Provisioning tool in 10.0.39. vm
修复在导入 D365FO .bacpac 时 “此版本的 SQL Server 不支持‘KILL DATABASE CONNECTION’权限 ”的问题 (10.0.39)/Fix “The permission ‘KILL DATABASE CONNECTION’ is not supported in this version of SQL Server” while importing a D365FO .bacpac (10.0.39
VendPackingSlipTrans and VendInoiceTrans 表关系/Relation between VendPackingSlipTrans and VendInoiceTRans D365 Finance and Operation
如何在 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

与本文相关的文章

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