Toad World® Forums

Toad (Code) Insight issues (12.12.0.18) 64 bit

when previous sql (sepearated with empty line) is not “completed” Toad inside does not work

consider just 2 statements in Editor (line numbers added)

1 alter

2

3 update mytable t

4 set t.

Even though incomplete alter statement should have no impact on TI, it breaks it,

the same when line 1 is

1 alter

When line one gets commented out

1-- alter

or for example

1 alter table test_table drop

or

1 alter ;

than suddenly TI can find it’s way around.

Same problem exists in 12.11.0.95

Incomplete SQL requires that the “Treat blank line as statement terminator” option is enabled on the Execute/Compile page in Options. However, that option does not work properly with your example. I’ll log.

Michael