Toad World® Forums

Problem with autocomple using joins and table alias

I’ve having a problem using auto complete when I join a table and subquently use the table alias. For example, the following won’t auto complete. I’ve confirmed the “issue” on multiple computers.

select *

from CAPS.ENTITY_UNENCUMBERED_EQ_VW ent

left outer join CAPS.BUSINESS_DATE bd

on ent.

The “ent.” and “bd.” won’t autocomplete. I’ve tried reinstalling. I’ve tried chaning my autocomplete settings. Nothing has worked so far.

There were a few problems with Code Insight and ANSI join syntax that have been resolved for 12.9. 12.9 will be released early summer.

I should have added… your problem is one of those resolved. It works in beta.

Thanks!