Does anyone know if there is any documentation on the use of ? ? in the following select statement?

SELECT TABLE WITH INITIALS EQ ?"Employee Initials"?

INITIALS is a multivalued field. This is the prompt that comes up.

¨X¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨

¨U Enter Employee Initials ¨U

¨U¨U

¨^¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨a

What I want to do is be able to enter a list of initials at select time so that the select statement would look like:

SELECT TABLE WITH INITIALS EQ "ABC" "DEF" "GHI" "JKL" …

and an unlimited number of initials could be entered.

Entering the following at the prompt works:

ABC" "DEF" "GHI" "JKL

Is there something simpler?

¨X¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨

¨U Enter Employee Initials ¨U

¨U¨U

¨^¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨T¨a

Is supposed to be:

*————————*

Enter Employee Initials

*————————*

A more intuitive way to do this is to eliminate the quotes:

]]SELECT TABLE WITH INITIALS EQ ?"Employee Initials"?

instead,

SELECT TABLE WITH INITIALS EQ ?Enter Employee Initials in Quotes?

That way, they enter "ABC" "DEF" "GHI" and it will work

HTH

Don M.

Jenna,

I have used AREV for 10 years now. I have never seen or heard of anything more that this "inline" prompting can do.

It is definately not like other pick "inline" prompting. I think you might have to continue the way you are going, or build an RBASIC program around the sentence.

When I converted to AREV I had to create a subroutine to handle the same problem. You might want to consider doing the same.

You could call the subroutine "PROMPT_USER". Then you could prefix your sentence with "PROMPT_USER". That way the "PROMPT_USER" subroutine could handle the prompting and then execute the sentence.

You could then have your "PROMPT_USER" subroutine break down the "inline prompt" into 3 seperate sections seperated by a comma. Action, Prompt, Validation. Action could be like "R" for recurring, kinda like R" ". That way you get the " " between each prompt.

Like a date prompt would look like this…

PROMPT_USER SELECT INVOICE WITH DATE EQ ]"

There is no Action. The prompt is "Enter date ", and the validation is "D" for date.

Or in a case like you want…

PROMPT_USER SELECT INVOICE WITH INITIALS EQ ]"

The action is "R" for recurring string, and the string is " ". The prompt is "Enter string ". So it will prompt until the user enters NULL or simply the ENTER key. For the entries of ABC and DEF and GHI, the result would look like this… "ABC" "DEF" "GHI".

So it is possible for you to achieve your desiered results. The prompt user subroutine will replace the "inline prompt" with the entered string or strings and then execute the select statement.

try

SELECT VOC ?"item"?…

the 3 dots should keep prompting until a null is entered

http://www.sprezzatura.com/revmedia/v1i7a22.htm

http://www.sprezzatura.com/revmedia/v3i3a9.htm

The Sprezzatura Group

World Leaders in all things RevSoft

Unfortunately, the all-important three dots are missing from that second document (lost in conversion to web page?).

Noticed that but the text mentions them aw what the heck - shamed into fixing it

The Sprezzatura Group

World Leaders in all things RevSoft

You guys are awesome! That was exactly what I was looking for.

View this thread on the forum...