Using database data
You can make a connection between a RichTextEdit control and
a DataWindow control or DataStore object. When an input field in
the RichTextEdit control has the same name as a column or computed
column in the DataWindow object, it displays the associated data.
Whether or not the RichTextEdit control has a data source,
there is always only one copy of the rich text
content. While editing, you might visualize the RichTextEdit contents
as a template into which row after row of data can be inserted.
While scrolling from row to row, you might think of many instances of
the document in which the text is fixed but the input field data
changes.
To share data between a DataWindow object or DataStore, use
the DataSource function:
|
1 |
rte_1.DataSource(ds_empdata) |
Example of sharing data
If the DataWindow object associated with the DataStore ds_empdata has
the four columns emp_id, emp_lname, emp_fname,
and state, the RichTextEdit content might include
text and input fields like this:
Sample letter with columns from the employee table
ID: {emp_id}
Dear {emp_fname} {emp_lname}:
We are opening a new plant in Mexico. If you would like to
transfer from {state} to
Mexico, the company will cover all expenses.
Navigating rows and pages
For the RichTextEdit control, navigation keys let the user
move among the pages of the document. However, you must provide
scrolling controls so that the user can move from row to row.
You should provide Prior Row and Next Row buttons. The scripts
for the buttons are simple. For Next Row:
|
1 |
rte_1.ScrollNextRow() |
For Prior Row:
|
1 |
rte_1.ScrollPriorRow() |
If you also provide page buttons, then when the user is on
the last page of the document for one row, scrolling to the next
page moves to the first page for the next row:
|
1 |
rte_1.ScrollNextPage() |