Microsoft Dynamics AX (Archived)

Update_recordset

(0) Share

Report

Posted on by XB

1,875

Hi all

I don't have any compile error but when I execute code axapta throw an error.

Is it possible do this ? (toDate - custAveragePeriodCollectionTrans.DueDate)

update_recordSet custAveragePeriodCollectionTrans
setting DueDays = toDate - custAveragePeriodCollectionTrans.DueDate;

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

@rp@n 30 on at

Like (0)

Report

Hi Javier

Can you please let me know the exact error with screen shot.

Arpan Sen

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Error is for use the expression (toDate - CustAveragePeriodCollectionTrans.DueDate)

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Hi Javier, it is not possible with the update_recordset statement in X++ to update a field by calculating a value of other fields. In this case you will have to change your code to a record based operation i.e. a while select statement and update each record individually.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (0)

Report

Hi Javier Biesa,

Generally you can do this, but this table looks like custom one, what are the types of DueDays and DueDate fields ?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

msdn.microsoft.com/.../aa865135.aspx

You may add and subtract date from date, and int from date. If it is of any other type i.e. utcdatetime or int64 it will likely not work. You could try to convert the utcdatetime figures into a date with the DateTimeUtil collection class.

You could also wrap around the whole arithmetic function with an any2int() to clearly state for whomever is reading the code that you are expecting an integer in the DueDays field.

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

DueDays is an integer and DueDate is a date (EDT DueDate)

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

You have 0 value in your record buffer, so date-0=date, which you cannot save in an int field. AX does not work in a way you assume, so the actually selected buffer is not referrable for the set operation.

You have to join in the datasource once more i.e. using RecId as a link, then you could put that second buffers' value in the deduction.

See example 3 in the documentation:

https://msdn.microsoft.com/en-us/library/aa674382.aspx

Was this reply helpful? Yes No
XB 1,875 on at

Like (0)

Report

Hi Vilmos

I saw this links for this reason I was asking if it's possible, I supose you are right an record buffer is empty.

Was this reply helpful? Yes No
Suggested answer

shayan arshi 40 on at

Like (0)

Report

shayanarshi.blogspot.com/.../update-record-set-using-updaterecordset.html

This will be helpful to you for insertion

Was this reply helpful? Yes No