Stack overflow with circular virtual object expression
I want to use the virtual object feature to substitute a table name with a query but need help with the syntax of the expression for the MetadataObject.
Say I have a table named TABLE1, and want to have it replaced with:
(SELECT * FROM TABLE1 WHERE COLUMN1 = 'Value')
When it replaces the original TABLE1 with my expression, it seems to then replace the TABLE1 in my expression with my expression again, over and over until it fails.
If I define my table as "TABLE1_AQB" then it works, but I'd rather not have users seeing that _AQB in the ObjectTreeView
Thank you for your question.
The current version of Active Query Builder implies usage of other virtual objects in SQL expressions of virtual objects. We can let you control this implication in the next version with a new property.
The stack overflow bug will be fixed in the next build.