is it possible to update a table using MAXOF function

Finance and Operations/AX Technical Forum
1

hi friends, i want to update a table using maxof() function,

if possible in ax means, just give one example.

thanx :slight_smile:

2

No it will result in an update conflict(if used on RecId) or you will not have the record to update.

Rather you can use the order by clause in your update statement…

3

how to use order by clause in update stmnt???

4

select forupdate custTable order by CreditMax desc;

5

its not working,

ttsbegin;
while select forupdate tempcol order by tempcol.Rno1 desc
{
tempcol.Name2=“ttt”;
tempcol.Rno2=222;
}
ttscommit;

6

while select forupdate tempcol order by Rno1 desc
{
tempcol.Name2=“ttt”;
tempcol.Rno2=222;

tempcol.update();
}