Data sources

Previous Next

Data sources allow USoft web pages to access stored data. For you as a developer, they provide access to data without the need to code SQL statements manually.

You can use a data source to get data displayed in fields, but also as a data definition that is then used by a JavaScript routine that you script.

Data sources are typed as Info, Lookup, Related, Dropdown or Variable Set data sources. Each of these is discussed in a section below:

Info data sources are the standard connection to data that are searched, selected or manipulated.

Lookup data sources are for searching and selecting foreign key values from a lookup window (eg., selecting a Product for an Orderline).

Dropdown data sources are for selecting foreign key values from a dropdown list (eg., selecting the Country of Origin of a Product).

Related data sources are for accessing child data related to a currently selected parent (eg., all the Orders of a given Customer).

Variable Set data sources are for populating dropdown lists with values that do not come from the database. Option controls are also used for this purpose.

 

 

collapseFinding data source objects in Web Designer
collapseInfo data sources
collapseLookup data sources
collapseDropdown data sources
collapseRelated data sources
collapseVariable Set data sources

 

 

See Also

Embedded Data Sources

Data Source Path Syntax

Life Time Data Source Property

Page and Data Source Constructs

Page and Data Source Constructs

 

How to Define a Related Data Source

How to Define a Lookup Data Source

How to Insert a User-Defined Data Source

How to Define a Variable Set Data Source