 |
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 database software records contained in a variable of the
database software 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 database software 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 database software 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 database software recordset format is the foundation for outputting database software record set values. For performing operations over database software records in a database software recordset variable, use the cycle
For Each Record From Recordset.
See Also:
Using Formatting
Report Style Editor
Text Formulas
Custom Export
|