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
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
