Although we cannot use crossCompany keyword with update_recordset command, we can still acheive the same functionality with some performance overhead as follows:
static void JobCCForUpdMethod(Args _args)
{
Table21 tab21;
ttsBegin;
while select forUpdate crossCompany countOfReviews from tab21
{
changeCompany(tab21.dataAreaId)
{
tab21.countOfReviews = tab21.countOfReviews + 2;
tab21.update();
}
}
ttsCommit;
}
Leave a comment