How to analyze why certain Views from Queries are not refreshed

[dreamquartz]

Hi All,

Weird situation,

I have multiple Views, all coming from Queries, and there are a few that do not refresh. The Queries as the source to those Views do run, and the ResultSet is correct, but when closing the Session and re-opening it, these Views are empty.

Again not all are having the issue.
I use naming conventions that include letters and numbers for the most important Queries and for others just alphabetical characters for Views.
I use rename Query and Copy-Paste it in the name for the View, resulting in a name for a View with some form of Version tracing.

I do not use SELECT DISTINCT, because the manual states that it not not allow for View updates, but anything else should be no problem.

I can re-create the Views again, and use them during the Session, but not convenient for Clients.
When re-creating certain Views, I have to re-create the dependant Views again as well.

Any thoughts?

Dream

02/06/26: updated Subject, due to spelling errors

[Bidouille]

Please attach an ODB so we can take a look.

[dreamquartz]

Sorry, but I can not do that, due to confidentiality and copy right restrictions.
I was looking for some general information on how to go through the process.

Dream