isclosed?

Yesterday the campus was closed. YIPPEE!! Snowday! But that has nothing to do
with this. L

I recently upgraded to Toad 10.6. Also YIPPEE!!

But I’m a bit baffled. I know I typed “is not null”, but what
I see on my screen is “isclosed not null”. It’s happened more
than once, or I’d be willing to blame the fat fingers.

What gives?

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323

image001.jpeg

Do you have any shortcut string s defined – such as FORM to FROM which is
a god send – but when you get one wrong it just drives you crazy J
image001.jpeg

Not to my knowledge.

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg

It’s Code Insight I’d guess. Type “Is” and press CTRL+T. You’ll
see ISCLOSED and it’s likely the first item in the list. Press space bar and
it’s added to editor. What’s going on is that you likely have 1 of the 2 (or
both) Code Insight options enabled that allows it to display after any character
is types, not just after a period and I’d suspect that your delay for the popup
is either very fast or in the cases where you’ve seen this your typing was
slower and timed just perfectly to press the space as the popup is displayed.
The Available Identifiers and Expected Tokens items in Options|Editor|Code
Assist|Toad Insight Objects list allow the popup to display more frequently. You
can either uncheck those or increase the popup delay to ensure that you have
time to type without it interferring.

Michael
image001.jpeg

AHA! That’s the ticket. My “Delay pop-ups” was set to 100
(millisececonds) which worked fine in 9.7 for code-assist with column names.
Apparently 10.6 offers a lot more assistance. And my typing is more at the speed
of a turtle than that of a Toad. So I’ve upped the value to 1000.

We’ll see how that works. J

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg