Classics Forum

Re: Multiple inputs on 1 input line in an Ace Report

Posted By:
Date:

No. It looks to me like you need I4GL, or you need a more sophisticated
way of running the report than using the INPUT section in ACE. Probably,
you'd make the report non-interactive, but it would retrieve some
parameters from the command line -- see the example I sent. You'd have a
table into which you could stuff a list of class codes, with an appropriate
ID number also associated with it (primary key id_number, class_code).
You'd then pass the ID code to the report on the command line - and the
report would join with the table. The driving code would prompt for the
control data (date, class codes, etc) and stuff the appropriate values into
the table, and pass the others into the report as parameters. The hardest
part would be validating things like dates.

In I4GL, you'd probably have some code to allow the user to enter a list of
values, which would then be stuffed into a temporary table (so you would
not need the ID column - the temp table is private to this run of the I4GL
program).

The big problem is that unless you're using dynamic SQL (not possible in
ACE - feasible in I4GL if you want to do it), you can't create an IN clause
with a variable number of items in it. If there's a finite (smallish)
upper bound on the number of items, you could use:
IN(var1, var2, var3, var4, ..., varN)
and if the user only provides two values, use the second value in each of
var3..varN. But that is all pretty icky and not very ACE-friendly either.

You're beginning to push the limits of what ACE can do...

--
Jonathan Leffler (jleffler@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management Solutions
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"


|---------+---------------------------->
| | "Jay Zwagerman" |
| | <jay2@iafalls.com|
| | > |
| | Sent by: |
| | forum.subscriber@|
| | iiug.org |
| | |
| | |
| | 02/27/2003 12:17 |
| | PM |
| | |
|---------+---------------------------->
>---------------------------------------------------------------------------------------------------------------------------------------------|
| |
| To: classics@iiug.org |
| cc: |
| Subject: Multiple inputs on 1 input line in an Ace Report [103] |
| |
>---------------------------------------------------------------------------------------------------------------------------------------------|




Since you were so helpful on my last post, I thought I would try this
question.

I am wondering if it is possible to enter more than 1 name on a single
input line of an Ace Report? For example, I want to enter ME, WE, and AR
for class code. In the form you can just put a pipe between them and it
will query for all of them. In the table, the class code can have multiple
entries such as

select customer.name, class_code from tablea
where customer.number in ('1','2')

Name class_code
Larry Day HG
Jeff Wagner HG WE AR ME

I know this isn't set up very well, but I can't change the table.

So my input prompt would be something like this.
Input Class code: ME|WE|AR

But my report is only pulling from the first input (ME). How do I get it
to pull from all 3 codes?

Messages In This Thread

• Multiple inputs on 1 input line in an Ace Report
  Jay Zwagerman -- Tuesday, 15 April 2003, at 3:55 p.m.
  • RE: Multiple inputs on 1 input line in an Ace Report
    Richard E. Ghiz -- Tuesday, 15 April 2003, at 3:55 p.m.
    • Re: RE: Multiple inputs on 1 input line in an Ace Report
      Jay Zwagerman -- Tuesday, 15 April 2003, at 3:55 p.m.
  • Re: Multiple inputs on 1 input line in an Ace Report
    Jonathan Leffler -- Tuesday, 15 April 2003, at 3:55 p.m.
    • Re: Re: Multiple inputs on 1 input line in an Ace Report
      Jay Zwagerman -- Tuesday, 15 April 2003, at 3:55 p.m.

Classics Forum is maintained by Administrator with WebBBS 5.12.