2/22/2018

Axapta : Axapt Not LIKE Code In Where

Axapta : Axapt Not LIKE Code In Where

    !(Table.Field LIKE "*...*")



Example : 
        WHILE
        SELECT DrwNo FROM inventTable
        GROUP BY DrwNo
        WHERE inventTable.DrwNo != ""
            && inventTable.HasDrawing == NoYes::No
            && ( inventTable.ItemGroupId != "CR" && inventTable.ItemGroupId != "P:B1" && !(inventTable.ItemGroupId LIKE "SUB*") )
        {
    
        }

No comments:

Post a Comment