Toad World® Forums

Toad Insight and Master Detail Browser Issues.


#1

Toad Beta 12.5.0.13, 32 Bit

1. Toad Insight is broken.

In our schema, table names have a T prefix, So if I type “select * from T_” I no longer get a pick-list to pick table names from. Even if I press + <.> nothing happens. Toad Insight options are enabled correctly in Options. I’ve tried switching the Toad Insight options on and off , it doesn’t fix it. + does work.


2. Master Detail Browser Issues

a) “View Edit query…” does not obey syntax highlighting settings. I have a dark background and white text, but I am shown white background with white text so cannot see my query.

b) “View Edit query…” for child datasets does not show the actual SQL the grid is running (i.e. with the parameter from the parent, i.e. the actual SQL driving the grid). It simply shows the select … from CHILDTABLE.

c) Minor issue but the “View Edit query…” hint is named wrong on child datasets.


#2

Hi Paul,

I won’t comment on Toad Insight other than to tell you that Michael will comment on it. He’s been making some changes so it is cancellable.

Master detail items a) and c) are fixed.

Regarding b) - hmm, yes, you are correct. The where clause is changed automatically by a 3rd party component that we use to access Oracle. I could try to find that part of the query and add it in for the sake of the ‘view/edit’ dialog, but then I’d have to take it back out again when the dialog is closed (without breaking the query) and still apply whatever other changes you might have made to the query. I’d rather not go down that road, as it seems prone to (my) errors. You can still make whatever changes you’d like to the query, and the ‘where’ clause continue to be adjusted on the fly.


#3

CTRL+. is fixed in next beta.

On 01/16/2014 05:48 AM, PaulZip wrote:

Toad Insight and Master Detail Browser Issues.

Thread created by PaulZip
Toad Beta 12.5.0.13, 32 Bit

1. Toad Insight is broken.

In our schema, table names have a T prefix, So if I type “select * from T_” I no longer get a pick-list to pick table names from. Even if I press + <.> nothing happens. Toad Insight options are enabled correctly in Options. I’ve tried switching the
Toad Insight options on and off , it doesn’t fix it. + does work.


2. Master Detail Browser Issues

a) “View Edit query…” does not obey syntax highlighting settings. I have a dark background and white text, but I am shown white background with white text so cannot see my query.

b) “View Edit query…” for child datasets does not show the actual SQL the grid is running (i.e. with the parameter from the parent, i.e. the actual SQL driving the grid). It simply shows the select … from CHILDTABLE.

c) Minor issue but the “View Edit query…” hint is named wrong on child datasets.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#4

Hi John, thanks for that.

OK, I understand. Could you add another option to copy the full child query including parameters to clipboard, I use TOAD’s Master Detail Browser a lot and have always wished this was an option. If you are using ODAC controls I think it’s TOraQuery.FinalSQL


#5

You can grab it with spool SQL. Will that do?


#6

Not as convenient as a single button press or menu item, I have to remember to switch it on and then off afterwards.

I have some complicated Master Detail Browser (MDB) configurations to help in visualising in my system development or in investigating bugs. It’s a fantastic TOAD facility and prevents me having to rewrite many joined queries over and over. But in identifying an issue I often need to capture the query or record in question. So I suppose what I’m after is two different cases here.

  1. Capture the SQL for the whole child dataset (with master source parameters included)

  2. Capture the SQL for the child record in question

Perhaps this belongs on the DBgrid popup menu so is available anywhere in the system? I’ve seen the same facility it in other third party DB tools and it’s something a few of my colleague have often thought would be useful on MDB or TOAD itself.


#7
  1. I could sneak that in by including that data on the view/edit query if you do a CTRL+Click on the view/edit button instead of just a click (in this case, the view/edit dialog would have to be read-only)

  2. hmmm…I guess you’d want to do that with primary key, is that right? And if there isn’t one, then RowID? This reminds me of another request I heard once before - maybe it would work for you too - the other request was to add a format in “export dataset” that would generate a “select … from dual” to give a result just like the selected (or all) rows. It wouldn’t work for LOBs but for most other datatypes it would work. What do you think about that?

I am not necessarily proposing this as a solution, but it’s not tough to do this now if you don’t mind using rowid - just enable the “show RowID” option then you could copy the rowid out of the grid and then go to the editor with the rowid. Of course with multiple rows selected it would be a bit of a pain.


#8

I added the CTRL+Click thing for next beta. After doing so, I realized that this makes your second request fairly easy. You can do it like this:

  1. Select the PK column (or any column that uniquely identifies the row - you can repeat this step more than once if multiple columns)

  2. Click the drop-down arrow on the funnel icon on the toolbar, then choose “Filter by current value”

  3. CTRL+Click on the view/edit query button to see the query


#9

I’m not sure your solution would work for tables with a compound PK (I suppose ROWID could be used if filtering allows it), but CTRL+Click will be a useful addition!


#10

For compound PKs, you can just “filter by current value” more than one time if you need to. It will add to the where clause each time you do that.