SQL question
Date: 30 Jul 1998 12:32:28 GMT
Message-ID: <6ppp4s$b50$1_at_pale-rider.INS.CWRU.Edu>
[Quoted] I wrote a SQL script that executes a simple SELECT statement. Within this statement, I want to prompt the user for the value of a certain field in the table I'm selecting from. It looks something like this:
select &fieldname from sometable where SomeConditionIsTrue
Ahead of this select statement I have a "spool" command so that all my output will be directed to a file. I don't want the output shown on the screen so I also have a "set term off" in there as well.
This works fine to suppress the screen output.. However... the user is no longer prompted for the value of &fieldname. The program still stops for the user to enter this information but there is no prompt saying what information is required.
My question is.. How can I keep the prompt for &fieldname but not have any of the select statement output appear on the screen?
Dennis Hancy
Eaton Corporation
Cleveland, OH
Received on Thu Jul 30 1998 - 14:32:28 CEST