ViewFoundsets Query Question

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

ViewFoundsets Query Question

Postby wvitpr » Thu Jun 27, 2019 2:03 am

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?
Regards,
Phillip Routley

Worldview IT
Sydney, Australia
User avatar
wvitpr
 
Posts: 219
Joined: Tue Apr 24, 2007 1:38 am

Re: ViewFoundsets Query Question

Postby mboegem » Thu Jun 27, 2019 2:37 pm

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
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance Developer

Image

Partner of Tower - The most powerful Git client for Mac and Windows
User avatar
mboegem
 
Posts: 1743
Joined: Sun Oct 14, 2007 1:34 pm
Location: Amsterdam

Re: ViewFoundsets Query Question

Postby wvitpr » Fri Jun 28, 2019 1:30 am

Ok thanks Marc. that makes sense..
Regards,
Phillip Routley

Worldview IT
Sydney, Australia
User avatar
wvitpr
 
Posts: 219
Joined: Tue Apr 24, 2007 1:38 am


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 10 guests

cron