
General Notice: BOB is going to retire...please see details here. General Notice: No events within the next 45 days. |
Author |
Message |
Ed Prieto Forum Member


Joined: 08 Jun 2004
               Posts: 2

|
Posted: Wed Jun 09, 2004 12:17 pm Post subject: Using User Response to Select Specific Data |
|
|
In one Query I request Inventory records for a specific point in time (eg. wk 5) based on a user prompt/user response.
In the second Query I request future demand based on a submission date, one week later than former query. (eg. wk 6) In the data set I have demand for the next 6 weeks, 6,7,8,9,10........
I created a user response varible (char) and performed tonumber fromula to create number. I need to bring the two queries together to calculate estimated days of inventory. The problem is that I get # computation errors. If I define the varible where wk is = 6 for eg. the data works. I want the report to be dynamic based on either user response.
Help.
 |
|
Back to top |
|
 |
dcdas Forum Associate


Joined: 17 Jun 2002
                
*2 Posts: 751 Location: Atlanta

|
Posted: Wed Jun 09, 2004 1:11 pm Post subject: Re: Using User Response to Select Specific Data |
|
|
In your first query use the to_char(date,'WW')=@prompt(..)
and in your second query use to_char(submission_date,'WW') > @PROMPT(use same prompt as first..)
(FOR oracle) _________________ Durgesh Das
IntercontinentalExchange
durgesh.das@theice.com |
|
Back to top |
|
 |
|
|