Issues with Editor's Code Insight Pick List. After typing the dot (.) lead before column name, the drop down pick list does not show on complex statements. (4289110)

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Issues with Editor's Code Insight Pick List. After typing the dot (.) lead before column name, the drop down pick list does not show on complex statements.
Description

Issues with Toad v12.8 Editor's Code Insight Pick List. After typing the dot (.) lead before column name, the drop down pick list does not show on complex statements.
Examples:
A)

-- Works in Toad 12.8
select * from OE.ORDERS ord
where ORD.ORDER_ID = 2456

-- Does not work in Toad 12.8. Works fine in 12.7.
insert into OE.ORDERS ord
(ord.

B)

-- This works in 12.7, but not in 12.8
select
from PROD.ADDRESS adr, PROD.ASSOC_ENTITY_ADDRS aea
where ADR.ADDRESS_TYPE_CD = :typcd
and ADR.ADDRESS_ID = AEA.ADDRESS_ID
and AEA.ENTITY_TYPE_CD = 'PRS'
and AEA.ENTITY_ID not in
(select PAR.PERSON_ID
from PROD.PARTICIPANT par
where PAR.PROGRAM_ID = :progid
and PAR.PARTICIPANT_STATUS_CD = 'ENR'
and PAR.PERSON_ID = aea.
Resolution

WORKAROUND:
None
STATUS:
This issue is fixed in Toad for Oracle 12.9. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
Defect ID

TOR-499

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Issues with Editor's Code Insight Pick List. After typing the dot (.) lead before column name, the drop down pick list does not show on complex statements. (4289110)

Title

Description

Resolution

Defect ID

Leave a Comment