 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
Converting RecordSets to Text
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:
| # | Date | Title | Quantity | Total
| | Record 1: | 2006-07-14 | Apple | 5 | 15
| | Record 2: | 2006-07-16 | Tomato | 10 | 20
| | Record 2: | 2006-07-19 | Juice | 4 | 16
|
Let's show how they will appear with different recordset formattings:
| Test Text Formula | Result
| |
| | [$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.
See Also:
Using Formatting
Report Style Editor
Text Formulas
Custom Export
|
