Date: Thu, 27 Jun 2002 11:04:36 -0400
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
Subject: Re: "Prompt for Value" option when getting data
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.
--On Thursday, June 27, 2002 10:53 AM -0400 Jane McGinn
> 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