Thursday 27 December 2012
Monday 15 October 2012
Dynamics Axapta Basic methods
Display method:
static InventTable find(ItemId itemId,
boolean update = false)
{
InventTable inventTable;
;
inventTable.selectForUpdate(update);
if (itemId)
{
select firstonly inventTable
index hint ItemIdx
where inventTable.ItemId == itemId;
}
return inventTable;
}
Exist method:
static boolean exist(ItemId itemId)
{
return itemId && (select RecId from inventTable
index hint ItemIdx
where inventTable.ItemId == itemId
).RecId != 0;
}
Lookup method:
Method 1:
Method2:
JumpRef method:
Method 1:
static void
nonProductionLookup(FormStringControl _ctrl)//,str category)
{
Query
query = new Query();
QueryBuildDataSource qbds1;
QueryBuildRange qbr;
SysTableLookup sysTableLookup;
;
sysTableLookup = sysTableLookup::newParameters(tablenum(PMMachineTable),_ctrl);
sysTableLookup.addLookupfield(fieldnum(PMMachineTable,MId));
sysTableLookup.addLookupfield(fieldnum(PMMachineTable,AssetName));
qbds1 =
query.addDataSource(tableNum(PMMachineTable));
qbr
= qbds1.addRange(fieldNum(PMMachineTable,PmEqType));
qbr.value(enum2value(PmEqType::NonProduction));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Method2:
Public void lookup ()
{
SysTableLookup
sysTableLookup;
Query
q =new Query();
QueryBuildDataSource
qbds,qbds1;
QueryBuildRange
qbr,qbr1,qbr2;
PMSpecLookUp
specLookUp;
PMSpecificationTemplateLine specificationTemplateLine;
;
sysTableLookup =
sysTableLookup::newParameters(tablenum(PMSpecLookUp),this);
sysTableLookup.addLookupfield (fieldnum (PMSpecLookUp,PMSpecificLookUp));
sysTableLookup.addLookupfield(fieldnum(PMSpecLookUp,Description));
qbds =
q.addDataSource(tableNum(PMSpecLookUp));
qbds1 =
q.addDataSource(tablenum(PMSpecificationTemplateLine));
qbr =
qbds.addRange(fieldnum(PMSpecLookUp,PMGroup));
qbr2 =
qbds1.addRange(fieldNum(PMSpecificationTemplateLine,Description));
qbds1.joinMode(JoinMode::ExistsJoin);
qbds1.relations(true);
qbr.value(PMSpecificationTemplateLine.Description);
sysTableLookup.parmQuery(q);
sysTableLookup.performFormLookup();
}
public void jumpRef()
{
Args args = new args();
FormRun formrun;
;
// super();
args = new
Args(formStr(PMSpecLookUp));
args.caller(element);
args.lookupField(fieldNum(PMSpecLookUp,PMSpecificLookUp));
args.lookupValue(PMSpecificationTemplateLine.PMSpecificLookUp);
formRun =
ClassFactory::formRunClassOnClient(args);
formRun.init();
formRun.run();
formRun.wait();
}
Friday 5 October 2012
Monday 2 July 2012
Friday 10 February 2012
Software most used in PC's
Adobe Reader 10.1.2
Download
Google Chrome 18.0.1025.7 Beta
Download
Firefox 11.0 Beta 2
Download
Yahoo! Messenger 11.5.0.155
Download
Vlc player 2.0.3-win32
Download
Flash Player 11.2.202.197 Beta 5 (IE)
Download
uTorrent 3.1.2 Build 26745
Download
Google Talk 1.0.0.104 Beta
Download
2007 Microsoft Office Add-in: Microsoft Save as PDF
Download
Download
Google Chrome 18.0.1025.7 Beta
Download
Firefox 11.0 Beta 2
Download
Yahoo! Messenger 11.5.0.155
Download
Vlc player 2.0.3-win32
Download
Flash Player 11.2.202.197 Beta 5 (IE)
Download
uTorrent 3.1.2 Build 26745
Download
Google Talk 1.0.0.104 Beta
Download
2007 Microsoft Office Add-in: Microsoft Save as PDF
Download
Subscribe to:
Posts (Atom)