That got me closer. Now I have to translate that to modifying a query
built by the QueryBuild... classes.
static void Job1(Args _args)
{
InventTable inventTable;
InventTableModule inventTableModule;
;
while select * from inventTable
notexists join inventTableModule
where inventTableModule.ItemId == inventTable.ItemId &&
inventTableModule.Blocked == NoYes::Yes
{
info(strfmt("%1 %2",inventTable.ItemId, inventTable.ItemName));
}
info("Done");
}
Jim Chwaszczewski
________________________________
From: Janet Blake [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 9:52 AM
To: [email protected]
Cc: Chwaszczewski, Jim
Subject: RE: [development-axapta] Query Question
I would use a notexists join:
static void Job1(Args _args)
{
InventTable a;
InventTableModule b;
;
select ItemId,ItemName
from a
notexists join b
where b.itemid == a.itemid
&& b.blocked == noYes::No;
}
[Non-text portions of this message have been removed]
