Note: talk about database independancy? What about other datasources then, for example webservices?
Database Servers + datasets
Datasources: database tables
FoundSet: Datasource + calculations & aggregates
Record:
Dataproviders: all "columns"from a record + global and form variables
Forms bind to a Foundset.
I remember I was thinking that there were some gray areas when it comes to datasets and foundsets, and generally how Servoy is generating the SQL from these depending on relations etc. I noticed that there were often questions about that in the forum, and no definitive answers of course (but at least pointers to what approach gives you what), and in my company too, people are coming to me quite often with some of the following questions:
Seems like a lot of topics in one, really, but of course not necessarily all of these topics need to be addressed, or addressed at the same time, but I really think that these are things that need more explanations/clarifications/demonstrations. |