%{-------------------------------------------------------------%}
%{ Table2.ndm -- Net.Data table processing, example 2 %}
%{ Use %report block in SQL function for more control. %}
%{ %}
%{ Copyright (c) 2000, Craig Pelkie %}
%{ ALL RIGHTS RESERVED %}
%{-------------------------------------------------------------%}
%{-------------------------------------------------------------%}
%{ Define section for the macro %}
%{-------------------------------------------------------------%}
%define {
DATABASE = "*LOCAL"
%}
%{-------------------------------------------------------------%}
%{ RUNSQL- run the SQL statement, generate default report %}
%{-------------------------------------------------------------%}
%function(DTW_SQL) RUNSQL() {
select * from qiws.qcustcdt order by cusnum
%report{
$(N1 )
Customer Number |
$(N2 )
Last Name |
$(N3 )
Initials |
$(N4 )
Street |
$(N5 )
City |
$(N6 )
State |
$(N7 )
Zip Code |
$(N8 )
Credit Limit |
$(N9 )
Charge Code |
$(N10)
Balance Due |
$(N11)
Credit Due |
%row{
| $(V1 ) |
$(V2 ) |
$(V3 ) |
$(V4 ) |
$(V5 ) |
$(V6 ) |
$(V7 ) |
$(V8 ) |
$(V9 ) |
$(V10) |
$(V11) |
%}
%}
%}
%{-------------------------------------------------------------%}
%{ INPUT - initial section called, calls RUNSQL macro function %}
%{-------------------------------------------------------------%}
%html(INPUT) {
Net.Data macro Table2.ndm
Net.Data macro Table2.ndm
@RUNSQL()
%}