Sql Navigator - 5.5 - Use of & symbol

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

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