|
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 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.