I bumped into another hurdle. I attach the app and the error message.
I define a very simple test table, then created a view on it. When I make changes on fields in the table, no problem. Then I try the same change in the view, I get the attached error message.
I did some tests, and it looks that it has to do with having a boolean field in the definition of the view (at least, it appears to be!). Creating an almost identical view to the first one but omitting the boolean field, no problem at all to update any field.
Hello,
This is a request for a selection, the database engine needs a stable reference to be able to perform updates if necessary. in this case, the table key must be added to the query, this key can be hidden.
Hi again!
I bumped into another hurdle. I attach the app and the error message.
I define a very simple test table, then created a view on it. When I make changes on fields in the table, no problem. Then I try the same change in the view, I get the attached error message.
I did some tests, and it looks that it has to do with having a boolean field in the definition of the view (at least, it appears to be!). Creating an almost identical view to the first one but omitting the boolean field, no problem at all to update any field.
Any clue?
MRev
Hello,
Indeed, there is a problem with the update, I'm looking...
Hello,
This is a request for a selection, the database engine needs a stable reference to be able to perform updates if necessary. in this case, the table key must be added to the query, this key can be hidden.
Hello Surfvite,
Thanks a lot, this solved the matter!