473,472 Members | 1,715 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

qmf - alternative query columns

hi there,

is there in a QMF forms the ability to show in a report columnn
the value of different data columns depending on the value of a
certain data column?

tia
MIchael Tepperis-von der Ohe (logicacmg)
Nov 12 '05 #1
2 2504

"Michael TEpperis" <te******@web.de> wrote in message
news:96*************************@posting.google.co m...
hi there,

is there in a QMF forms the ability to show in a report columnn
the value of different data columns depending on the value of a
certain data column?

I'm not very clear on what you are actually trying to do. I can think of at
least two or three ways to interpret your question, each of which would have
a different answer. If you can clarify precisely the scenario you want to
achieve, I can probably give you a more comprehensive answer.

However, as an initial remark, you can *probably* do what you want with some
combination of FORM.CONDITIONS, QMF's REXX support and QMF's variable
capabilities.

I haven't used QMF in several years now so I'm rusty now. However, I was
pretty fluent at one point and I have access to the manuals (but not to a
copy of QMF itself) so I may be able to answer your question in more detail
if you make it more specific. (I could do even better if you could give me
access to a QMF system, maybe a small test system that actually had a bit of
sample data in it. ;-)

It would help to know which version of QMF you are running and on what
platform. CICS, for example, does not support some features that may be
critical for your requirements.

Rhino
Nov 12 '05 #2
"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message news:<ua*******************@news20.bellglobal.com> ...
"Michael TEpperis" <te******@web.de> wrote in message
news:96*************************@posting.google.co m...
hi there,

It would help to know which version of QMF you are running and on what
platform. CICS, for example, does not support some features that may be
critical for your requirements.


thanks for offering help. meanwhile I found a other solution
using the FORM.DETAILS and the FORM.CONDITIONS panel.

Michael
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Bing Wu | last post by:
Hi Folks, I have a very large table containing 170 million rows of coordinats: CREATE TABLE "DB2ADMIN"."COORDINATE" ( "FID" INTEGER NOT NULL , "AID" INTEGER NOT NULL , "X" REAL NOT NULL ,...
6
by: jjturon | last post by:
Can anyone help me?? I am trying to pass a Select Query variable to a table using Dlookup and return the value to same select query but to another field. Ex. SalesManID ...
2
by: scott.k.fraley | last post by:
....and the SELECT thats trying to pull from said Query doesn't like it one bit! ;) I'm working on this project (in Access 2002) and there is a report who's RecordSource is the following...
6
by: C10B | last post by:
hi, I have a table with several million rows. Each row is simply the date and time a certain page was viewed. eg page1 1-1-00 page2 2-1-00 page1 16-1-00 page1 17-1-00
11
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
4
by: m.wanstall | last post by:
I have a crosstab query that compiles data for Months of the year. I have a stacked select query on top of that crosstab query that uses the latest 2 months data and exports it to a fixed length...
5
by: wugon.net | last post by:
question: db2 LUW V8 UNION ALL with table function month() have bad query performance Env: db2 LUW V8 + FP14 Problem : We have history data from 2005/01/01 ~ 2007/05/xx in single big...
2
by: RP | last post by:
I have three columns in a Grid (Third-Party), which is populated through code without using DB DataSource. The columns are: Date, Amount and Type. At present I created a DataSet to fill the entire...
1
by: Leigh | last post by:
This is the query I have to update a column in one table, by comparing 2 of its columns to with the columns of another table. The WIE_Physician table has 1655 records, hence the loop, and the...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.