Fw: RE: [Axapta-Knowledge-Village] how to represent not equal to symbol in query build

Hi, Using qbr.value('!10') – we can pass not equal to symbol in Query Build. I  herewith attached sample coding to find vendors who do not belong to the VendorGroup “10”.         Query query;     QueryRun qr;     QueryBuildDataSource qbds;     QueryBuildRange qbr;     vendTable vendTable;    

Re: [Axapta-Knowledge-Village] how to represent not equal to symbol in query build

Hi, Check if it works.. try with SysQuery in Value. for eg., Qbr.value(SysQuery::valueNotEmptyString()); -- this checks value is not equal to null. Hope it helps. Regards, Anitha On Fri, Nov 20, 2009 at 2:59 PM, giridharraj wrote: > > > Hi, > > Can anyone tell me how to put NOT EQUAL TO symbo

[Axapta-Knowledge-Village] how to represent not equal to symbol in query build

Hi, Can anyone tell me how to put NOT EQUAL TO symbol in query build. Because the below query is not working for me. str test; test =''; qbr.value(strfmt('%1 != %2',contact.custaccount,test) Regards, Giridhar Raj.