ViewFoundsets Query Question

Hi,
I really like the new ViewFoundsets option in theory, but why must we use servoy query builder to load it… ?, if you already have a complicated working query would it not be possible to just load it directly as an option?

Hi,

this is because Servoy is able to determine which Foundset to keep in sync (or not) based on the query builder object.
A plain query should be parsed first in order to achieve this, which is impossible when having to deal with all kinds of SQL-dialects

Ok thanks Marc. that makes sense…