How to make joined queries editable

[The_Doc_Man]

G:

It was a one-field GROUP BY that resulted from when I was trying to dynamically generate a query string and the aggregated field got left out due to a programmer error. It kind of happened in passing and wasn't intentional. My reaction was, "well, how about that?" followed by fixing the problem and moving on.

 

[gemma-the-husky]

non updateable queries are a real pain at times, and hard to deal with directly. We all have to find workarounds for some situations.

eg in some cases, we need a union query for data presentation purposes, but then we have to deal with non updateable records because of the union.