Using Net.Data Table Functions

Working with Net.Data Table Functions

Terms of Use
	1.	You may freely download this file or set of files for use within your site or at your client sites.
	2.	You must keep all of the original copyrights and other notifications with all copies of the file(s) that you download from this site.
	3.	You may use any of the code or techniques described in your own programs.
	4.	You may not develop any article, publication, Web page or other document that is based entirely or substantially on any of the information or code that you download.
	5.	You may link directly to www.web400.com from any of your Web sites. Please do not link directly to internal pages on this site.
	6.	Use of any materials, files, descriptions, code, procedures, etc., that you obtain from this Web site is AT YOUR OWN RISK. DO NOT USE any of the materials, files, descriptions, code, procedures, etc., if you are uncertain what the effect might be, and if you do not have adequate backup and recovery to correct any possible problems.
	7.	I do not offer "free" support for any of the material available on this site. Consulting services are available by request for a fee.

File name: Net.Data Table Functions

Environment: Any supported Net.Data environment. AS/400: IBM HTTP Server for AS/400 (5769-DG1), V3R2, V3R7, V4Rx+.

Date Posted: April 17, 2000

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.

Link to the article:

NetDataTableFunctions.html - Web page that describes the use of the functions.

Download Files:

NetDataTableFunctions.doc - Microsoft Word document that describes the use of the functions. (Same as the html file above.)

Note: for the following four files, you can view them in the browser by clicking the link. To save the files, right-click and select the "Save Target As..." option.

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.

Craig Pelkie
Bits & Bytes Programming, Inc.
craig@web400.com

File name:	Net.Data Table Functions
Environment:	Any supported Net.Data environment. AS/400: IBM HTTP Server for AS/400 (5769-DG1), V3R2, V3R7, V4Rx+.
Date Posted:	April 17, 2000