Page History

...

A record is mapped to a single row in a SQL database table.

...

Foundset

...

A foundset is a Servoy object that represents a query from a single database table. Foundsets handle the caching of data for display, but do not need to requery the database to do so.

Any form based on a table in Servoy has a underlying foundset managing the data for it. Forms based on the same table will share a foundset unless they are directed differently through scripting or design time property.

Foundsets can be created, accessed, altered, controlled, and applied through scripting.

Relation

A relation is a Servoy object used to define the key relationship between two database tables. A standard relationship is defined by the primary key of one table being linked to a foreign key of another. Some features of a relation include:

• The tables can be linked by equality, but also by other operators (<,>,like, and so on).
• The tables can exist on two different database servers on different database platforms.
• The tables can be linked by more than one column.
• A global variable can be used on the left side of the link. This is useful for filtering, as you can use a relation to filter a set of records by setting the value of a global variable.
• Referential integrity can be enforced, as well as cascading deletes.

...

Dataset

...

A dataset is a Servoy object that can hold row and column data. Datasets can be created via scripting, or can be returned by a custom SQL query as well. Unlike foundsets, datasets do not represent a live link to a database resource.

Calculation

A calculation is a derived value that acts like another column in the database table. Calculation data is the result of a JavaScript function and is similar to a Servoy method. The main difference is what is available to the function; a calculation function cannot access form variables, values from form elements, or application functions as it is calculated in the data layer of the application. The function does have the current column's data and any related data available to it.

...

A variable can be defined and holds data at runtime, but is not tied to any database column. Variables can be used as a dataprovider on a form, and can be created in either form scope or global scope.

...

Dataset

...

A dataset is a Servoy object that can hold row and column data. Datasets can be created via scripting, or can be created by SQL query as well.

...

Foundset

...

A foundset is a Servoy object that represents a query from a single database table. Foundsets handle the caching of data for display, but do not need to requery the database to do so.

Any form based on a table in Servoy has a underlying foundset managing the data for it. Forms based on the same table will share a foundset unless they are directed differently through scripting or design time property.

Foundsets can be created, accessed, altered, controlled, and applied through scripting.