vendredi 6 avril 2012

How to use like in range with wildcard character in axapta

Using wildcard "Like"
//The "*" symbolises the like in the statement
static void useWildCards(Args _args)
{
Query custQuery = new Query();
QueryRun queryRun;
CustTable CustTable;
;
custQuery.addDataSource(tablenum(CustTable)).addRange(fieldnum(CustTable, Name)).value('L*');
queryRun = new QueryRun(custQuery);
while (queryRun.next())
{
custTable = queryRun.get(tablenum(CustTable));
info(custTable.Name);
}
}

Aucun commentaire:

Enregistrer un commentaire