Toad World® Forums

Sql Navigator - 5.5 - Use of & symbol


#1

I want to use the & symbol to execute a resuable query, such as

SELECT * FROM EMP WHERE EMPNUM = ‘&EMPNUM’;

When I execute the statement above, the SQL Editor should prompts me to enter the value for the employee name at run time.

But in this version (ver-5.5.2) it is not prompting for the value instead it is checking in the table where EMPNUM = ‘EMPNUM’ and hence returning no rows.

Any solutions?

Thanx in advance…

Sujit


#2

Hi Sujit,

You need to turn on the Scan Defines option before executing the statement. Please make sure the Scan Defines button in code editor toolbar is pressed.

Hope this helps,
Vincent