update statement in AOT

Finance and Operations/AX Developer Forum
1

Hello everyone,

I’m trying to update a record in the AOT. When I run the statement below I receive the following error.

pastedimage1480620921491v1.png

Update purchreqtable
set ORIGINATOR =‘5637164826’
where purchreqid = ‘015013’

2

Hello Carlos, I guess you wrote the SQL statement in an X++ job, right? In fact, X++ is a language that you probably want to learn a little bit, the grammar is different from pure SQL clause. Do you have an AX developer in office to help you?

3

Hi,

If you are using bulk records to update, use Update_recordset

Update_recordset purchreqtable
setting ORIGINATOR =‘5637164826’
where purchreqid = ‘015013’;

Else, use a normal update

ttsbegin;
select forupdate purchreqtable where purchreqtable .purchreqid = ‘015013’;
purchreqtable .ORIGINATOR =‘5637164826’;
purchreqtable .update();
ttscommit;

4

Your trying to do Update u test that code in Job with ur purchreqid if that executed successfully ur SQL statement is correct.

then u implemented to ur real time ticket