Classics Forum

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

Posted By:
Date:

This is not allowed in ACE directly but I have done the following two work
arounds;

1) You could prompt for a range of input values for the class_code such as;

INPUT
PROMPT FOR s_code USING
"Enter Starting Class Code? "
PROMPT FOR e_code USING
" Enter Ending Class Code? "
END

Then your WHERE would look like this;

WHERE class_code BETWEEN $s_code AND $e_code

Of course this only works if the codes are in sequence. But this works well
since users can enter a single value by entering the same value for each
prompt or all values if they enter 0 (zero) and z.

2) You could setup variables for the estimated maximum number of values that
the user may typically enter and then simply prompt for each value and
entering SPACES for each unused value.

There may other solutions using stored procedures.

Regards,
Rich

email: rghiz@attbi.com



-----Original Message-----
From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] On Behalf
Of Jay Zwagerman
Sent: Thursday, February 27, 2003 3:18 PM
To: classics@iiug.org
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.