Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Converting RecordSets to Text

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Formatting Recordset Variables

To learn more about how and where you can use formatting, see the Using Formatting section.

Recordset format is used for printing records contained in a variable of the recordset type as text. Such variable can be created, for instance, with a query or, for instance, in a many-to-many relational field. This format appears as a list of fields, data from which is to be displayed. Suppose, we have the [$recs] variable that contains 3 records with the following field values:

Record 1:2006-07-14Apple515
Record 2:2006-07-16Tomato1020
Record 2:2006-07-19Juice416

Let's show how they will appear with different recordset formattings:

Test Text FormulaResult
[$recs^rset |Title|, ]Juice, Tomato, Apple
[$recs^rset |Title| - $|Total|; ]Juice - $16; Tomato - $20; Apple - $15
[$recs^rset |Date|: |Title| - $|Total|[br]]
([br] - means line BReak)
2006-07-14: Juice - $16
2006-07-14: Tomato - $20
2006-07-14: Apple - $15
[$recs^rset |Title|, Quantity=|Quantity|;[br]] Juice, Quantity=4;
Tomato, Quantity=10;
Apple, Quantity=5
[$recs^rset "|Title|", "|Quantity|"[br]]" "Juice", "4"
"Tomato", "10"
"Apple", "5"

Please note that in the last example there is an additional quote before the tag closure. This is necessary since the delimiter (in this case, the "[br]) is not to be placed.

Thus, the recordset format is the foundation for outputting record set values.

For performing operations over records in a recordset variable, use the cycle For Each Record From Recordset.

All topics in the "Formatting Data" section: