InventTable inventTableBuffer;
for (inventTableBuffer = getFirstSelection(InventTable_ds);
inventTableBuffer;
inventTableBuffer = InventTable_ds.getNext())
{
// write logic here.
}
select top 1 name from DIRPARTYTABLE inner join HcmWorker ON HcmWorker.PERSON = DIRPARTYTABLE.RECID AND HcmWorker.RECID = (select top 1 worker from HCMPOSITIONWORKERASSIGNMENT INNER JOIN HCMPOSITION ON HCMPOSITIONWORKERASSIGNMENT.POSITION = HCMPOSITION.RECID AND HCMPOSITION.POSITIONID = 'PositionId' where GETDATE() between HCMPOSITIONWORKERASSIGNMENT.VALIDFROM AND HCMPOSITIONWORKERASSIGNMENT.VALIDTO);
Currency details:CompanyInfo companyInfo = CompanyInfo::find(); info(strFmt("%1",companyInfo.postalAddress().Address));
CompanyInfo::standardCurrency() OR Ledger::accountingCurrency(CompanyInfo::current());
To loop/iterate selected records from grid on form you can use following code, this can be done on clicked method of button control : Invent...