Displaying single-row queries
The Quick HTML function also provides a way to quickly set up a table to display the contents of a single row in a database. This function is useful for data entry applications, where you might want to display or change all of the fields in a database row.
For single-row queries, Quick HTML builds a table that displays a label and an entry field for each column in the row. This makes it possible to build a user interface in which end users can edit the contents of the fields in the row, and then submit the changes for processing by another page. Because Quick HTML uses entry fields for this, you must place the generated table for a single-row query inside a form.
To display the results of a single-row query, follow these steps:
1. Set up your database query using the VA Smalltalk Single Row Query part.
2. Select Quick HTML from the pop-up menu of the Single Row Query part.
3. When prompted, select the resultRow attribute from the list. VA Smalltalk automatically tears off the resultRow attribute and loads the mouse pointer with the generated table.
4. Place the generated table within a form on the Page.
At edit time, the table generated for a single-row query appears as HTML tagging rather than as a Table part. To see how the table looks at run time, test it with your Web browser.
5. Connect the aboutToGenerateHtml event of the HTML Page to the executeQuery action of the Single Row Query.
Last modified date: 01/29/2015