Is there a way when you right mouse over a row of a table, a menu item to create an Update statement with all the data filled in and the where clause is the primary key data?
Thanks
Is a MERGE statement close enough?
Rt-click -> Export Dataset.
Set Export format to Merge
Check "Selected rows only" and "Clipboard"
Yes that would work thanks.
1 Like
BTW, It is related to, so maybe this should intertwined somehow?
That's not really based on the current row though. It's more for just building an update from scratch.
Agreed. I use the following so was not sure if same type of flow
No, these things are all separate.
I had missed this option, it can potentially be very usefull in the future in some use cases,
Thanks for that
1 Like