最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Data Manipulation tip 5. Like operator wild card in Select query Dynamics ax 2012 D365 for Operations.

网络文摘 alirazazaidi 587浏览 0评论

Currently I am writing an Inquiry for Client. For this inquiry I have to use Like operator functionality. For example end user wants to search Sale Orders. For this enter the partial sale order number and Inquiry provides the result.

Microsoft provide Like operator , I used it with text box in below code snippet. Suppose strProcumentValue is string edit control with auto declaration as true.

 

 

void clicked()

{

PurchTable  _Table;

 

 

super();

 

 

select * from _Table where _Table.PurchId like “*” + strProcumentValue.text() +”*”;

 

if (_Table !=null)

{

 

info(“found”);

 

}

}

Its works for me,

reference: http://daxdude.blogspot.com/2011/02/use-x-wildcard-like-and-not-like-in-x.html

发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址