RE: RE: Question on Editor (Not beta version)...

Dear Bert,

See the scenario below

TOAD Version 9.6.1.1

Run the stmt 

select   'Test & Dev' My_Col

      -- , 'T & D' Another_Col

from dual;

Displays 

Test & Dev

----=========================

TOAD Version 11.0.0.116

Run the stmt 

select   'Test & Dev' My_Col

    --   , 'T & D' Another_Col

from dual;

Displays prompt dialog box

 

Second line is commented still TOAD is asking in prompt. I think TOAD
shouldn't read the COMMENTED code for prompt.

Why?

 

 

From: [email protected] [mailto:[email protected]] On Behalf Of
Bert Scalzo
Sent: Monday, December 19, 2011 12:21 PM
To: [email protected]
Subject: [toad] RE: Question on Editor (Not beta version)...  

Toad 11 behavior is correct - you have an ampersand that is not escaped
- so interpreted as variable - use sql plus set command to correct 

From: [email protected] [mailto:[email protected]] On Behalf Of
Malyavantham, Krishnamurthy T (Education Cabinet)
Sent: Monday, December 19, 2011 10:52 AM
To: [email protected]
Subject: [toad] Question on Editor (Not beta version)...
Importance: High 

TOAD Version 9.6.1.1

Run the stmt 

select 'Test & Dev' My_Col from dual;

Displays 

Test & Dev

----======================

TOAD Version 11.0.0.116

Run the stmt 

select 'Test & Dev' My_Col from dual;

Displays prompt dialog box

 

Why?

I know & in SQL prompt character.

Thanks
Krishnamurthy Malyavantham 

Department of Workforce Investment
Division of Technology Services
Systems Management Branch
500 Mero St., Capitol Plaza Tower, 9th Floor, Room # 903
Frankfort, Kentucky 40601
Phone: (502) - 564 - 4980
Fax: (502) - 564 - 9504
Email: [email protected]
<mailto:[email protected]>  

"Have a nice Day!" 
------------------------------------------------------------------------
---
The information contained in this e-mail message may be privileged,
confidential, and protected from disclosure. If you are not the intended
recipient, any dissemination, distribution, or copying is strictly
prohibited. If you think that you have received this e-mail message in
error, please inform the sender; and delete this message permanently
from your computer files.