Page 1 of 1

ViewFoundsets Query Question

PostPosted: Thu Jun 27, 2019 2:03 am
by wvitpr
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?

Re: ViewFoundsets Query Question

PostPosted: Thu Jun 27, 2019 2:37 pm
by mboegem
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

Re: ViewFoundsets Query Question

PostPosted: Fri Jun 28, 2019 1:30 am
by wvitpr
Ok thanks Marc. that makes sense..