Toad World® Forums

Scripting and passing parameters

The following script runs ok without a date range, but when I want to add a date range, toad does not ask for them when running and the result CSV file is blank.

When I run my sql in toad directly it stops and ask to input the 2 prompts, but does not when calling toad from command line. How can I do this?

FORMAT=DELIMOTHER
DELIMCHAR=,
QUOTES=YES
COLUMNS=YES
LOWERCASECOLUMNS=NO
OUTPUTDIR=c:
BEGINQRY c:\fitt\export.csv
SELECT * FROM IND_MAINTENANCES
where pre_maint_created_date between :fromdate and :todate
ENDQRY
CLOSETOAD

Guy

Hi Guy,

may I just know the version of TDM you have installed, please?

Thank you,
Lukas

oupss…
Toad for Oracle 8.6.1.0

No problem, Guy. Just go on to http://toadfororacle.com/forumindex.jspa?categoryID=649 and file your question with them.

Regards,
Lukas

Took a left turn when should of gone right…ha ha…sorry…
Just filed it in the proper forum…

Thanks