Enhancement Suggestion for Schema Panel and Cache

• 
  Thank you for your post into the forum.
  
  SQL Prompt displays object definitions in a schema panel, when you select an object name in the candidate list, providing that you have not selected the option to 'hide' the Schema panel (SQL Prompt Options->Pop-up Behavior tab->Schemal Panel).
  
  The 'Ctrl + Space' keys are the hotkeys to bring up the candidate list.
  
  To refresh the cache file for the database you are using in your query editor, on the SQL Prompt menu, click Refresh Cache, or press CTRL+SHIFT+D.
  
  Hope the above helps.
  
  Eddie Davis
  Technical Support
  Red Gate Software Ltd
  E-Mail: support@red-gate.com

  Eddie D August 16, 2007 15:42

  - 0 +
• 
  The CTRL+SHIFT+D hotkey answers my cache refresh
  
  Thanks
  
  But as for the schema panel, what you said is not always accurate.
  Consider the following
  
  I have the Aliases setting set to Enable Alias Assignment
  
  I have tables
  TableA
  TableB
  
  Here are examples of 'Ctrl + Space' sequences:
  Select * From Tab[Ctrl + Space] -- This brings up the object definition dialog and the Schema Panel just fine.
  However,
  SELECT * FROM dbo.TableA[Ctrl + Space]
  Produces
  SELECT * FROM dbo.TableA ta -- no object definition dialog popup is ever displayed because intellisence has completed the statement
  
  So if my object name can be determined by intellisence the object definition dialog never has a chance to popup.
  
  I did, however, investigate a couple of other scenarios.
  If I use this statment "SELECT * FROM dbo.TableA"
  Put my cursor on the T and press [Ctrl + Space] then the object definition dialog comes up along with the Schema Panel.
  So it is all about where your cursor resides when you press [Ctrl + Space] and if intellisence can determine your object name without the object definition dialog.
  
  In any case, an explicit hot key for the schema panel would be nice.
  
  Thanks,

  kepr00 August 16, 2007 16:13

  - 0 +
• 
  Thanks for the request. Your right there is no way of doing that at the moment. I have added this issue to our list of enhancements for SQL Prompt so it will get considered for future versions. Thanks for the feedback.
  
  Lionel

  Lionel August 23, 2007 10:36

  - 0 +

Add comment

Please sign in to leave a comment.