Método Para Actualizar Valores En Una Tabla
{
AMCaseTimeSheetTrans timeSheet;
ProjEmplTrans emplTrans;
;
ttsbegin;
while select forupdate timeSheet
wheretimeSheet.CaseId == 'OT-0165391'
{
while select emplTrans
where emplTrans.ProjId == timeSheet.ProjId
&& emplTrans.NAVCaseOprId ==timeSheet.OprId
&& emplTrans.EmplId == timeSheet.EmplId
{
if((emplTrans.Qty * emplTrans.SalesPrice) == timeSheet.LineAmount)
{timeSheet.ProjectHours = emplTrans.Qty;
timeSheet.doUpdate();
break;
}
}
}
ttscommit;
}
static void Job10(Args _args)
{AMCaseTimeSheetTrans timeSheet;
ProjEmplTrans emplTrans;
;
ttsbegin;
while select forupdate timeSheet
where timeSheet.CaseId == 'OT-0140583'
{select firstonly emplTrans
where emplTrans.ProjId == timeSheet.ProjId
&& emplTrans.NAVCaseOprId == timeSheet.OprId
&&emplTrans.EmplId == timeSheet.EmplId
&& emplTrans.TransId == timeSheet.ProjTransId;
timeSheet.ProjectHours = emplTrans.Qty;timeSheet.doUpdate();
}
ttscommit;
ULTIMO
static void Job10(Args _args)
{
AMCaseTimeSheetTrans timeSheet;
ProjEmplTrans emplTrans;
;
ttsbegin;while select forupdate timeSheet
where timeSheet.CaseId == 'OT-0140583'
{
select firstonly emplTrans
where emplTrans.ProjId == timeSheet.ProjId&& emplTrans.NAVCaseOprId == timeSheet.OprId
&& emplTrans.EmplId == timeSheet.EmplId
&& emplTrans.TransId ==...
Regístrate para leer el documento completo.