%{-------------------------------------------------------------%}
%{ Table1.ndm -- Net.Data table processing, example 1 %}
%{ Use Net.Data default table processing to format HTML. %}
%{ %}
%{ Copyright (c) 2000, Craig Pelkie %}
%{ ALL RIGHTS RESERVED %}
%{-------------------------------------------------------------%}
%{-------------------------------------------------------------%}
%{ Define section for the macro %}
%{-------------------------------------------------------------%}
%define {
DATABASE = "*LOCAL"
DTW_HTML_TABLE = "YES"
%}
%{-------------------------------------------------------------%}
%{ RUNSQL- run the SQL statement, generate default report %}
%{-------------------------------------------------------------%}
%function(DTW_SQL) RUNSQL() {
select * from qiws.qcustcdt order by cusnum
%}
%{-------------------------------------------------------------%}
%{ INPUT - initial section called, calls RUNSQL macro function %}
%{-------------------------------------------------------------%}
%html(INPUT) {
Net.Data macro Table1.ndm
Net.Data macro Table1.ndm
@RUNSQL()
%}