| Author |
Message |
Casso
Joined: 03 Jul 2008
Posts: 9
Country: Russian Federation |
|
 SQL Assistant list items bug(?) |
 |
Hello,
Why when i get a list of available joins, all items are expanded.
Can i change this behaviour somewhere in options?
Last edited by Casso on Tue Nov 03, 2009 5:09 am; edited 1 time in total |
|
| Tue Nov 03, 2009 5:01 am |
  |
 |
Casso
Joined: 03 Jul 2008
Posts: 9
Country: Russian Federation |
|
| |
|
SQL Assistant version 4.8.29, Win XP Professional
I have seen this bug on MS SQL Server Managment Studio/
Last edited by Casso on Tue Nov 03, 2009 5:10 am; edited 1 time in total |
|
| Tue Nov 03, 2009 5:04 am |
|
|
Casso
Joined: 03 Jul 2008
Posts: 9
Country: Russian Federation |
|
| |
|
And another bug in PL\SQL Developer(ver. 7.0.0.1050)
When i put a cursor on some table name, it should appear list of columns, but it doesn't.
|
|
| Tue Nov 03, 2009 5:06 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
This is not a bug. It is a feature introduced in version 4.8. In most cases number of tables available for joins is limited to 1 or 3. To save developers several clicks on navigating and expanding the JOINs list, the column level is automatically expanded so that a complete join condition can be picked with a single click. See http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22965 item #4 for more info.
We have an enhancement task in the project tracking system for providing additional control over this feature. In the next version there should be options for controlling how many tables to expand in the JOINs list and whether to automatically expand the column level
***
For PL/SQL Developer target, on the Targets tab in the SQL Assistant Options please check "Display Mouse-over hints" option is set to Yes. also on DB Options tab, check "Show Keys and Indexed Columns"
|
|
| Tue Nov 03, 2009 9:16 am |
|
|
Casso
Joined: 03 Jul 2008
Posts: 9
Country: Russian Federation |
|
| |
|
Thank you for answer, i will wait for this option.
The option "Display Mouse-over hints" has already been set to Yes.
I changed "Show Keys and Indexed Columns" option to Yes, but it still doesn't appear.
|
|
| Tue Nov 03, 2009 10:20 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
Does Ctrl+mouse click on a table name work for you in your version of PL/SQL Developer?
|
|
| Tue Nov 03, 2009 11:32 am |
|
|
Casso
Joined: 03 Jul 2008
Posts: 9
Country: Russian Federation |
|
| |
|
No, PL\SQL Developer open native window with table description, instead of SQL Assistant "Show table data".
And i don't know where i can turn it off.
|
|
| Tue Nov 03, 2009 11:45 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
There is likely some software conflict. PL/SQL Developer intercepting and processing mouse related events before they reach SQL Assistant.
|
|
| Tue Nov 03, 2009 12:30 pm |
|
|
|
