I need to update a batch of records. I cannot use update_recordset since i need a join in my query.
I was searching help documentation of Axapta if i can find something.
I found this :
mk:@MSITStore:C:\Program%20Files\Navision\Axapta%20Client\Bin\AxDvgLangUs.chm::/X++_constructs/Data_Manipulation/Update/Update.htm which say :
SELECT FORUPDATE MyTable
WHERE MyTable.name==‘Jane Doe’;
MyTable.amountMST += 100;
MyTable.AccountNum = 1050;
Selects the table MyTable for update. Any records with the name equal to Jane Doe are updated. The amountMST field has 100 added to its current value, and the AccountNum field is changes to account number 1050.
If you read explanation, this code can update multiple records.
I try a simple query like that and no it didnt work.
We have already not much documentation about Axapta, but the one with Axapta is wrong ? Whats the problem with this code?