Demonstrate Net.data built-in reporting functions

DTW_TB_HTML_TABLE

This built-in function relies on the data in a Net.data %TABLE variable which are closely related to SQL result sets.
The Net.Data %TABLE variable used in this example is generated by populating it from the result of an SQL SQLECT statement.

The DTW_TB_HTML_TABLE function renders a Net.data %TABLE variable as an HTML table.

The complete source for this example can be viewed at dtw_tb_html_table.

This example first sets the predefined Net.data variable DTW_HTML_TABLE to have a value of "YES".

Then it runs a DTW_SQL function named @list() which selects records from the file QIWS/QCUSTCDT.
So there are just 2 lines within the %HTML block as follows -

@dtw_assign(DTW_HTML_TABLE,"YES")
@list()

This generates the HTML for a table from selected records in the file QIWS/QCUSTCDT.
When requested as a Net.data page the response should be -

CUSNUM	LSTNAM	INIT	STREET	CITY
938485	Johnson	J A	3 Alpine Way	Helen
389572	Stevens	K L	208 Snow Pass	Denver
475938	Doe	J W	59 Archer Rd	Sutter
192837	Lee	F L	5963 Oak St	Hector

Notice that the column headings for the table have been automatically populated with the corresponding database field name.

Back to Tutorial