Integration with Query Designer

Note: This feature works only with Visual Studio 2005 and higher.

Oracle Developer Tools for Visual Studio provides integration with the Microsoft Query Designer which permits you to create and modify queries, using several panes that provide for input and results.

This section includes Oracle-specific limitations for using Query Designer. For generic documentation on using Query Designer, please see the Microsoft documentation at: http://msdn2.microsoft.com/en-us/library/ms172013(vs.80).aspx.

When the Query Designer is launched in Server Explorer or in any node under the connection, the following limitations apply:

• Menu for Query Designer Windows has these limitations:

  • The Add Table command shows only Tables and Views

  • The Verify SQL command (from the individual panes and the Query Designer toolbar) is not supported by Oracle Developer Tools and displays a message box to indicate this.

  • The Query Type of Make Table is not supported.

• This designer does not generate SQL statements with Oracle specific join syntax

  To work around this, you can use syntax such Left Inner Join, Right Outer Join instead of using the plus () symbol. You can modify this query to include Oracle-specific syntax, however, this causes the Query Designer to throw an error. You may ignore the error and proceed with the query. The query executes and a message box appears indicating any errors from the execution.

• Certain properties for Query Designer Window are not supported

  The following Query Designer properties are not supported when launched from Oracle connections in Server Explorer: Destination Table, GROUP BY extension, SQL Comment, Top, Expression, Percent, and With Ties.

• GUI object properties only allow modification of Join properties

  Any GUI objects, including Tables, Views, and Joins, that are added to the diagram, can be viewed, but only the join properties can be modified.

  Other objects support read-only properties.