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

Mon, 23 Nov 2009 08:20:56 -0800


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;

    ;

    query = new Query();

    qbds = query.addDataSource(TableNum(VendTable));

    qbr = qbds.addRange(FieldNum(VendTable,VendGroup));

    qbr.value('!10');

    qbds.addSortField(FieldNum(VendTable,AccountNum));

    qr = new QueryRun(query);

    while (qr.next())

    {

    VendTable = qr.get(tableNum(VendTable));

    info(strfmt("%1   %2",VendTable.VendGroup,VendTable.Name));

    }

 

With Regards

L.Rajalakshmi

Technical Consultant

Employee sign

 

 

From: giridharraj <giridhar...@yahoo.com>
Subject: [Axapta-Knowledge-Village] how to represent not equal to symbol in query build
To: Axapta-Knowledge-Village@yahoogroups.com
Date: Friday, November 20, 2009, 2:59 PM

 

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.

 


<<image002.jpg>>

Reply via email to