DataViewModuleIntegrationUISpec

DataView Module Integration UI Spec

This document describes the user interface for how the DataView module will be integrated into the Database Explorer SQL Editor

User Interface

The SQL editor is the same. The panel showing results that we have today is replaced with a new panel that displays results from the dataview module.

• Note that the user can select the "New Tab For Each ResultSet" checkbox. If this is checked and the editor contains multiple statements that return results, then each set of results is displayed in a new tab. If this is not checked, then only the first statement that returns results is displayed.

• The results are associated with the editor. If you have multiple editors open, each of them will have their own results pane. That is the same as how it is today.

• The new version of the results pane has some nice new features:

• Can edit the results and apply changes 1
• Can insert and delete rows from the table the results are based on 1
• Sort results based on column (ascending/descending toggle)
• Pagination

1 These features are not available for results from a statement that involves joins or a view, or is from the execution of a stored procedure

• This page was last modified on 6 November 2009, at 15:26.
• This page has been accessed 10 times.