Loading ...
Sorry, an error occurred while loading the content.

RE: [toad] Column name selection

Expand Messages
  • Jeff Smith
    Well that would explain why it s not working. For some reason Toad isn t looking for your object. Have you tried a simple test, say on SCOTT. HR. SCOTT.EMP. ?
    Message 1 of 10 , Sep 1, 2008
    • 0 Attachment
      Well that would explain why it's not working. For some reason Toad isn't looking for your object.

      Have you tried a simple test, say on

      SCOTT.
      HR.
      SCOTT.EMP.

      ?
      ________________________________________
      From: toad@yahoogroups.com [toad@yahoogroups.com] On Behalf Of Madvig, Daniel B [DBMadvig@...]
      Sent: Friday, August 29, 2008 5:37 PM
      To: toad@yahoogroups.com
      Subject: RE: [toad] Column name selection

      Doesn’t seem to be much there.

      [cid:image001.png@01C909F5.77C73030]

      Dan
      --
      Dan Madvig
      Northwestern College & Radio, St. Paul, MN
      651.631.5323
      From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Jeff Smith
      Sent: Friday, August 29, 2008 4:29 PM
      To: toad@yahoogroups.com
      Subject: RE: [toad] Column name selection


      Database > Spool SQL to screen

      This will show you the queries that Toad generates to make the magic happen in Toad.

      Scroll up on that option, do you have synonymns selected? We used to do public ones by default, but no longer for 9.6 for performance reasons. Your 'table' might actually be a synonym that points to a table or view.
      ________________________________________
      From: toad@yahoogroups.com<mailto:toad%40yahoogroups.com> [toad@yahoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of Madvig, Daniel B [DBMadvig@...<mailto:DBMadvig%40nwc.edu>]
      Sent: Friday, August 29, 2008 4:59 PM
      To: toad@yahoogroups.com<mailto:toad%40yahoogroups.com>
      Subject: RE: [toad] Column name selection

      Not sure what you mean by “debug with spool sql to screen”.

      My “Editor/Cose Assist/Toad Insight” looks like this:

      [cid:image001.png@01C909F0.40035110<mailto:image001.png%4001C909F0.40035110>]

      Dan
      --
      Dan Madvig
      Northwestern College & Radio, St. Paul, MN
      651.631.5323
      From: toad@yahoogroups.com<mailto:toad%40yahoogroups.com> [mailto:toad@yahoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of Jeff Smith
      Sent: Friday, August 29, 2008 3:46 PM
      To: 'toad@yahoogroups.com<mailto:%27toad%40yahoogroups.com>'
      Subject: Re: [toad] Column name selection


      Can u debug with spool sql to screen?

      Also, what options do u have set for code insight?

      ________________________________
      From: toad@yahoogroups.com<mailto:toad%40yahoogroups.com>
      To: toad@yahoogroups.com<mailto:toad%40yahoogroups.com>
      Sent: Fri Aug 29 13:03:29 2008
      Subject: [toad] Column name selection
      It seems I’ve lost more than just my mind. ☹

      It used to be that when I’d build a query in the editor, that when I typed the period after a table name a box would appear allowing me to choose column names from the list. That no longer happens; just a brief hour-glass and then nothing. Even Ctrl/Shift/t buys me nothing.

      Where have I stepped off the path?

      Toad 9.6.1.1

      Oh, and HAPPY PIRATES’ FRIDAY! This landlubber doesn’t speak it well.

      Dan
      --
      Dan Madvig
      Northwestern College & Radio, St. Paul, MN
      651.631.5323
    • Madvig, Daniel B
      I get the same multi-tabbed display as if I had done a describe tablename . Dan -- Dan Madvig Northwestern College & Radio, St. Paul, MN 651.631.5323 From:
      Message 2 of 10 , Sep 2, 2008
      • 0 Attachment

        I get the same multi-tabbed display as if I had done a ‘describe tablename’.

         

        Dan

        --

        Dan Madvig

        Northwestern College & Radio, St. Paul, MN

        651.631.5323

        From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Rob Zijlstra
        Sent: Saturday, August 30, 2008 7:54 AM
        To: toad@yahoogroups.com
        Subject: Re: [toad] Column name selection

         

        What happens when you place the cursor in the tablename and hit F4?

        2008/8/29 Madvig, Daniel B <DBMadvig@...>

        Good Evening, indeed.

         

        I haven't been to the pub yet, so I'm sure I'm typing the table name and alias correctly, and in the order you suggest. No luck.

         

        Dan

        --

        Dan Madvig

        Northwestern College & Radio, St. Paul, MN

        651.631.5323

        From: toad@yahoogroups.com [mailto:toad@yahoogroups.com] On Behalf Of Norman Dunbar
        Sent: Friday, August 29, 2008 4:24 PM


        To: toad@yahoogroups.com
        Subject: Re: [toad] Column name selection

         

        Evening Dan,



        > It seems I've lost more than just my mind. L
        I have that same problem many times! ;-)

        > It used to be that when I'd build a query in the editor, that when I
        > typed the period after a table name a box would appear allowing me to
        > choose column names from the list. That no longer happens; just a brief
        > hour-glass and then nothing. Even Ctrl/Shift/t buys me nothing.
        You have to start the query with something like this :

        SELECT
        FROM table_name alias

        Then go back up and type in "alias." as folows :

        SELECT alias.
        FROM table_name alias

        At that point, the list of columns will magically appear. If they don't
        the it is because the table name is invalid in that your current schema
        cannot see a table or synonym with that name. You may have to prefix it
        with a schema name.

        > Where have I stepped off the path?
        The path to enlightenment is narrow. Hope the above helps, it's how I
        usually do it.

        Cheers,
        Norm. [TeamT]




        --
        Regards, Met Vriendelijke Groeten

        Rob Zijlstra

      Your message has been successfully submitted and would be delivered to recipients shortly.