Date:         Thu, 27 Jun 2002 11:04:36 -0400
Reply-To:     painter@email.unc.edu
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         painter@email.unc.edu
Subject:      Re: "Prompt for Value" option when getting data
In-Reply-To:  <sd1aeeb4.043@mhrh.state.ri.us>
Content-Type: text/plain; charset=us-ascii; format=flowed

Can you set the program up to run in production mode? If so, then it is
very simple to insert macro symbols into the syntax that will generate a
pop-up window for the user to enter values into.

- John

--On Thursday, June 27, 2002 10:53 AM -0400 Jane McGinn
<JMcGinn@mhrh.state.ri.us> wrote:

> Happy Dog Days Everyone!!!
>
> I am trying to create code that will prompt the user to enter Month and
> Year they wish to receive reports on.
>
> I created a database called RepPeriod that only has two fields (month and
> year).  I noticed there is a "prompt for value" feature in the ODBC
> configuration screens.  When I went through the following steps, I was
> promted for Month and Year one time, but when I pasted the syntax,
> highlighted and ran it, I was not prompted.
>
> The drop down options I am chosing in the syntax screen are File...Open
> Database...New Query...highlight my file RepPeriod, click Next, drag the
> two fields (month and year) over to the retrieve fields box, I drag the
> month and year over to Expresion1, lines one and 2, respectively, I click
> the "=" sign in the Relation field, and place the cursor in the
> expression 2 box on line 1.  Then I click "Prompt for Value" on the
> bottom left of the screen.  I fill out all the information for Month and
> then do the same for Year, then click "AND" in the Connector field, and
> then click Next, click Next again, and then click "Finish".  I get
> prompted with the "Enter value for Query" box and fill in my Month, and
> then the Year, and this works for this one time.
>
> However, when I paste the syntax and run it a second time, I do not get
> prompted.  It just selects the values I had put in the first time.  Does
> anyone know how to make it prompt me every time I run the code?
>
> Any ideas are greatly appreciated.
>
> Jane McGinn