Working with Net.Data Table Functions
Author: Craig Pelkie
||Net.Data Table Functions|
||Any supported Net.Data environment. AS/400: IBM HTTP Server for AS/400 (5769-DG1), V3R2, V3R7, V4Rx+. |
About this Document:
Although Net.Data will automatically generate an HTML table to display the results of an SQL SELECT statement, the default table may not have as refined a look as you want for your application. Using Net.Data table handling functions, you can access the data returned in a result set and apply your own HTML table formatting to the data.
This article describes several techniques you can use to generate your own HTML tables in Net.Data macros. Sample code is also included that you can download and work with on your system.
Note: The following files can be viewed in the browser by clicking the link.
Table1 - Net.Data macro code to produce a simple (unformatted) HTML table.
Table2 - Net.Data macro code to produce an HTML table using Net.Data %report block.
Table3 - Net.Data macro code to produce an HTML table using Net.Data @dtw_tb functions.
Table4 - Net.Data macro code to produce an HTML table using Net.Data @dtw_tb functions, also includes clickable link and detail Web page.
NDTableFunctions.pdf - PDF file that describes the use of the functions. (Same as the html file above.)
Note: To download these files, left-click on the link and use the browser's "file/save" menu option or right-click on the link and choose "save link as".