by crichton » Tue Feb 14, 2012 10:05 am
Hi Caroline
I have moved from VFP9 to Servoy a year ago, and it took me a while to really appreciate how cleaverly data binds in Servoy.
I have converted my Foxpro databases to Postgresql. Are you trying to use views in foxpro database? If so I would recommend switching to postgresql.
You no longer have any need for views, as Servoy handles all those joins automatically via relations. Imagine using a single Database Environment in VFP where the relations were all set up in the database gui... we'll thats how Servoy works.
So basically you set up a table, then create the relations to any other tables to cover the same tables as per your views. Then on your form you you set the datasource as the top level table of the view table. All the relations to that table will then be available for you to place fields on the form. This is done by selecting the correct relation and drilling down to relations under that till you get the field thats in the correct relation to place on your forms and tabs. It's hard to explain in text, but once you get the hang of it it's brilliant. You can even programatically update any relation thats not part of this form or another one as Servoy seems to always have all the relations dynamically updating and binding.
Hope this helps a bit.