CODEWITHSUNDEEP
axaptadynamics-ax-2012x++
Aliaksandr Maksimau
Aliaksandr Maksimau

Reputation: 2281

update_recordset and array field

When I'm trying to update a table with an array field using update_recordset statement I'm getting the following compilation error:

Operand types are not compatible with the operator.

Here is my code:

update_recordset Table1 setting
    ArrayField = Table2.ArrayField 
join Table2
    where Table2.IdField == Table1.IdField;

Any thoughts?

Upvotes: 1

Views: 569

Answers (1)

Jan B. Kjeldsen
Jan B. Kjeldsen

Reputation: 18051

Array fields do not work well with update_recordset.

You may have success with addressing the individual fields arrayField[1] etc. but I remember failing even that.

You may have to revert to while select forupdate.

Upvotes: 2

Related Questions