Hello,
we have come across the following issue:
- a table has an unstored calc that returns some ID
- a relation from that table uses that unstored ID to relate to another table
- a form shows a field from that related table
so far, so good. everything working great. but:
when the users sorts by the related field, Servoy generates an invalid query. The unstored calc is part of the query (because it is needed for the relation), although that column doesn’t exist (because it is unstored). In such a case you get all kinds of DB errors. The user is not affected by this, however.
I think in such a case, Servoy should check if all fields that are used in the relation are “real” columns and prevent sorting.
Thanks
Patrick