Re: A newbie need help!! Any saviors?

In article <1994Nov21.201909.24230_at_wmichgw>, x93aroor_at_wmich.edu writes:
|> Hello Gurus,
|> A couple of questions from a newbie:
|>
|> Note: This is Oracle dbms and tools for dos
|>
|> 1) When in sql*plus can I redirect a select statement so that it prints the
|> output or writes it to a file?(instead of printing the result of the query
|> onto the screen)
|>

Try 'spool filename' before you issue the select.

|> 2) I am using the report-writer to generate some reports. I need to let the
|> user fill in the dates that the query would use. eg. The no of hours put on a
|> certain job from date1 to date2.
|>
|> My understanding is :
|> If I do not want to use the paramform feature of the reportwriter, I can pass
|> it on as a parameter from a sql*form. Is there any other "neat" way?
|>
|> I have created a non-base table form that enquires the start_date and
|> end_date from the user and then executes a trigger as under:-
|>
|> host( 'runrep report=timerep userid=james/mypass batch=yes begin_date
|> =:start_date end_date=:end_date ', no_screen);
|>
|> begin_date and end_date are variables in the query of the report writer.
|>
|> start_date and end_date are fields in my form that the user fills in.
|>
|> I have tried playing around with placement of the single quotes yet cannot
|> get it to work. Can someone PLEASE help!!
|>
|> some of the problems:
|> 1) If I actually hardcode the date it works, but when I return to my form, I get
|> an error that reads something like "no cursor to form", or I get a stack
|> dump and the program crashes.
|>
|> How can I pass on the user id and password without explicitly stating as
|> above? Is it available as a variable?
|>
|> Thanks in advance to all of you!!!
|> -Chandru
|>
|>
|>
Received on Wed Nov 23 1994 - 02:32:08 CET