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
Copy link

Link copied!

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