× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi, I need suggestions about STRQMQRY.

I'm used to make fast printouts with QMQRY creating a
member containing the sql code (&SQL) and one containing
the form formatting code (&FORM). The output is not the
best but it's ok. How can I include my parameters (&D2 &D3)
in the page heading?

Example of the query:

 STRQMQRY   QMQRY(&SQL) OUTPUT(*PRINT) +
             QMFORM(&FORM) SETVAR((DATAA &D2) (DATAF &D3))


The sql code is:

select tfcdpaese,  tfdescri40, abcdutente, abragsoc1e
from  tabpae0f join dbana01l on tfcdpaese  = abcdpaese
where abstatorec = ' ' and
(abdtfinero is not null and abdtfinero >= &DATAA
and abdtfinero <= &DATAF )
order by tfcdpaese ,abcdutente

The form code is:

H QM4 05 F 01 E V W E R 01 03 02/02/26 18:29
V 1001 050 Query description
T 1110 004 004 1114 007 1115 006 1118 003 1113 062
R         0      1   Col_heading1
R         1      2   Col_heading2
R         1      3   Col_heading3
R         1      4   Col_heading4
T 1210 003 003 1212 004 1213 006 1214 055
R 1    CENTER ********************************************
R 2    CENTER *** Title .............................. ***
R 3    CENTER ********************************************
V 1201 001 0
V 1202 001 2
V 1301 001 2
V 1302 001 0
V 1401 002 NO
V 1402 004 2
V 1403 006 0
E

TIA
Marco

__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.