Message-ID:

"Time is an illusion. Lunchtime doubly so." -- Ford Prefect, _Hitchhiker's Guide to the Galaxy_

computers / comp.sys.ibm.as400.misc / QMQRY - Column headings

QMQRY - Column headings

<0bf611ae-99f3-4777-94ff-43db21505d2cn@googlegroups.com>

https://news.novabbs.org/computers/article-flat.php?id=151&group=comp.sys.ibm.as400.misc#151

copy link Newsgroups: comp.sys.ibm.as400.misc

X-Received: by 2002:a05:622a:64c:b0:2f9:a4c:b4f0 with SMTP id a12-20020a05622a064c00b002f90a4cb4f0mr6838655qtb.380.1653035677026;
Fri, 20 May 2022 01:34:37 -0700 (PDT)
X-Received: by 2002:a05:6214:20e2:b0:45a:84aa:b10c with SMTP id
2-20020a05621420e200b0045a84aab10cmr7009399qvk.130.1653035676788; Fri, 20 May
2022 01:34:36 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 20 May 2022 01:34:36 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=212.125.72.190; posting-account=CbXeegoAAADQDO2hUuoHzzB_MsMYbbfC
NNTP-Posting-Host: 212.125.72.190
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <0bf611ae-99f3-4777-94ff-43db21505d2cn@googlegroups.com>
Subject: QMQRY - Column headings
From: brutto.giovanni@gmail.com (Giovanni Brutto)
Injection-Date: Fri, 20 May 2022 08:34:37 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1116

by: Giovanni Brutto - Fri, 20 May 2022 08:34 UTC

Re: QMQRY - Column headings

<c40658b4-d26e-4664-b6f4-dd3c430a6029n@googlegroups.com>

copy mid

https://news.novabbs.org/computers/article-flat.php?id=152&group=comp.sys.ibm.as400.misc#152

copy link Newsgroups: comp.sys.ibm.as400.misc

X-Received: by 2002:a05:6214:1c83:b0:443:6749:51f8 with SMTP id ib3-20020a0562141c8300b00443674951f8mr7933849qvb.74.1653054805802;
Fri, 20 May 2022 06:53:25 -0700 (PDT)
X-Received: by 2002:a05:620a:4449:b0:6a0:3f3c:c29d with SMTP id
w9-20020a05620a444900b006a03f3cc29dmr6193774qkp.25.1653054805588; Fri, 20 May
2022 06:53:25 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 20 May 2022 06:53:25 -0700 (PDT)
In-Reply-To: <0bf611ae-99f3-4777-94ff-43db21505d2cn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2.116.209.98; posting-account=rCmTcwkAAACvOkqqHCyaQUDcqgmXdPfg
NNTP-Posting-Host: 2.116.209.98
References: <0bf611ae-99f3-4777-94ff-43db21505d2cn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c40658b4-d26e-4664-b6f4-dd3c430a6029n@googlegroups.com>
Subject: Re: QMQRY - Column headings
From: rbombelli@gmail.com (Roberto Bombelli)
Injection-Date: Fri, 20 May 2022 13:53:25 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
X-Received-Bytes: 1853

by: Roberto Bombelli - Fri, 20 May 2022 13:53 UTC

Hi giovanni,
I think it's possible; You mast put a variable in the SQL like this :

select
codice,
descrizione as &variable
from libreria.tabella
where desclizione like 'AL%'
order by 001

and u can send variable (&variable) from CLP o RPG

If u will run from QM it ask for variable

Il giorno venerdì 20 maggio 2022 alle 10:34:38 UTC+2 Giovanni Brutto ha scritto:
> Hi everyone,
>
> Anyone know how to add variable on a QMFORM column headings?
>
> Thanks for the help.
>
> Regards
> Giovanni

Subject	Author
QMQRY - Column headings	Giovanni Brutto
QMQRY - Column headings	Roberto Bombelli