| home -> documentation -> learn by example |
 Index of examples
| Retreiving data |
Simple Dataset.
This is a basic example of the DATASET tag. A DBSP starting point.
Difficulty level: 1
|
|
Dataset in segments.
This example shows how to display a DATASET in segments. The usage of the POSITION and LENGTH property are shown.
Difficulty level: 2
|
|
Parametric query. Learn how to use parameters inside a query and how to deal with empty datasets. The usage of the NODATA property is shown.
Difficulty level: 2
|
|
Simple Master-Detail relationship.
This example shows how to create nested datasets using a basic MASTER-DETAIL relationship.
Difficulty level: 2
|
|
Dynamic load of Master-Detail combobox controls.
This example shows how to dynamically change information based on user selection.
Difficulty level: 2
|
|
Parametric Master-Detail relationship.
Same as the above example but in a more elegant manner.
Difficulty level: 3
|
|
| Inserting data |
Simple insertion.
This example shows how to perform a simple insertion with a JavaScript not null fields validation.
Difficulty level: 1
|
|
Multiple insertion.
This example shows how to perform a multiple insertion using the QRYEXEC tag and the MULTIVALUEPARAMS and MULTIVALUERANGE properties.
Difficulty level: 2
|
|
| Manipulating data |
Runtime calculations.
This example shows how to insert calculated values on the fly using the EXPVAL tag.
Difficulty level: 1
|
|
Using patterns.
This example shows how to use string patterns to obtain specific values of strings using the PATTERN and PATTERNINDEX properties.
Difficulty level: 2
|
|
Dealing with null values.
This example shows how to deal with database null values using the NULLVALUE property.
Difficulty level: 1
|
|
Exporting data to Microsoft Word® and Excel®.
This example shows how to export table information to Microsoft Excel® and Microsoft Word® using DBSP.
Difficulty level: 2
|
|
| Loops, logic & Control Flow |
Simple IF statement.
This example shows the most basic usage of the IF tag.
Difficulty level: 1
|
|
Nested IF statements.
Learn how to build nested IF statements.
Difficulty level: 1
|
|
The CASE statement.
Learn how to handle multiple choices using the CASE tag.
Difficulty level: 1
|
|
The WHILE statement.
Basic usage of the WHILE tag.
Difficulty level: 1
|
|
Safe colors using WHILE statement.
See how to create the Safe Web colors palette using the WHILE tag.
This example ilustrates also how to manipulate variables and hexadecimal values in DBSP, using the SETCOOKIE tag.
Difficulty level: 3
|
|
|
