Use of group by in update_recordset

(0) Share

Report

Posted on by Community Member

Dear all,

I am having problem to deal with group by in update_recordset, and also I am not able to use aggregates in update_recordset. I need some alternative suggestion or solution to achieve functionality like update_recordset.

while select forUpdate takes more time in execution rather than update_recordset

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

István Orosz 2,137 on at

Like (0)

Report

Hi,

Aggregation directly is not possible in an update_recordset (although you can do it in insert_recordset). I would suggest to make a view with the required aggregates and grouping, that can be joind to the set-based operations later.

Kind Regards,

István

Was this reply helpful? Yes No