in 11.5 can't view nested cursors in date grid
Wendy Penfold <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
When I run the following query with nested cursors in the editor, I can
view the first level of nested cursor by double clicking (CURSOR), but
not subsequent levels--although it does pop up the 'Cursor Edit' window,
like it is trying... It was a while ago, but I do remember being
impressed that this feature worked in a prior version of Toad.
SELECT Szbstdn_pidm,
Szbstdn_num_semesters_adj,
Szbstdn_housing_id,
Szbstdn_icpeer_username,
Q1.Szbques_code,
Q1.Szbques_order,
Q1.Szbques_required || ' ' || Q1.Szbques_label
Szbques_label,
Q1.Szbques_question_text,
Q1.Szbques_control_type,
Q1.Szbques_footnote,
Q1.Szbques_filter_label,
CURSOR (
SELECT Q2.Szbques_sub_order,
Q2.Szbques_question_text,
CURSOR (
SELECT Szbansw_answer_number,
Szbansw_label,
Szbansw_answer_text,
Szbansw_default_answer,
Szbansw_ques_code
|| '#;;#'
|| Szbansw_ques_sub_order
|| '#;;#'
|| Szbansw_answer_number
|| '#;;#'
Update_key
FROM Szbansw A
WHERE A.Szbansw_ques_code =
Q2.Szbques_code
AND Q2.Szbques_sub_order =
A.Szbansw_ques_sub_order
AND NOT ( A.Szbansw_ques_code =
'CAMPUSAREA'
--FRESHMAN CANT LIVE
IN APARTMENTS_
AND
A.Szbansw_answer_number IN
(5, 6)
AND
G.Sgbstdn_styp_code = 'F')
ORDER BY A.Szbansw_ques_sub_order,
A.Szbansw_answer_number)
Options,
CURSOR (
SELECT Szsprfl_answer_number, Answer_text
FROM Szqansw R
WHERE R.Szsprfl_pidm = S.Szbstdn_pidm
AND R.Szsprfl_ques_code =
Q2.Szbques_code
AND Q2.Szbques_sub_order =
R.Szsprfl_ques_sub_order)
Responses
FROM Szbques Q2
WHERE Q1.Szbques_code = Q2.Szbques_code
AND Q2.Szbques_control_type <> 'RANK'
AND NOT ( Q2.Szbques_code = 'CAMPUSAREA'
--FRESHMAN CANT LIVE IN APARTMENTS_
AND Q2.Szbques_sub_order IN (5, 6)
AND G.Sgbstdn_styp_code = 'F')
ORDER BY Q2.Szbques_order,
Q2.Szbques_sub_order NULLS FIRST)
Questions
FROM Sgbstdn G, Szbstdn S, Szbques Q1
WHERE G.Sgbstdn_pidm = P_pidm
AND G.Sgbstdn_pidm = S.Szbstdn_pidm
AND G.Sgbstdn_term_code_eff =
(SELECT MAX (B.Sgbstdn_term_code_eff)
FROM Sgbstdn B
WHERE G.Sgbstdn_pidm = B.Sgbstdn_pidm
AND B.Sgbstdn_term_code_eff <=
ithaca.szhousterm ())
AND Sgbstdn_stst_code = 'AS'
AND Szbques_sub_order = 0
ORDER BY Q1.Szbques_order
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/