You can navigate through multiple SQL statements tabs using the following methods.
Click the tab set located at the bottom of the window.
Use the SQL | Go to SQL function which navigates to a specify SQL number.
Use the navigation buttons on the toolbar or select the corresponding menu item.
Menu | Button |
Navigate | First SQL |
|
Navigate | Previous SQL |
|
Navigate | Next SQL |
|
Navigate | Last SQL |
|
You can edit the data in the Database Explorer, the SQL Worksheet, the Run Result, and the Parameters windows. When the data is display, a button bar displays at the bottom of the pane when you can edit the data. This button bar offers functions to view, edit, insert and delete data.
To navigate through data you can either use the scroll bar or use the Navigator buttons (First Record, Previous Record, Next Record, and Last Record). Depending on the amount of data, scrolling to the bottom of the page or executing the Last Record function may take a long time as all records are retrieved from the database.
To edit the record's column, place the cursor on the record that you want to edit and click Edit Record . You can change the data in the grid. Press the tab key or use the mouse to move to the next column. Once you complete the modification, click Commit or Rollback .
To insert a new record, place the cursor on the record that you want the new record inserted before and click Insert Record . Enter data for each column, press the tab key or use the mouse to move to the next column. Once you have completed entering the data, click Commit or Rollback .
To delete a record, place the cursor on the record that you want to delete and click Delete Record . Click OK on the confirmation dialog to confirm that the record you want to delete is correct. The Delete Record is automatically committed on your database.
To refresh the data, click Refresh .
Note: Not all Views are updateable; a general rule is that any UPDATE, DELETE, or INSERT statement on a join view can be modified if only one underlying base table exists.
You can copy the data from a single cell into the windows clipboard from the Database Explorer, the SQL Worksheet, the Run Result, and the Parameters windows.
To copy data
Highlight the cell with data.
Right-click and select Copy.
The three most popular comment delimiters used within SQL statements are recognized as valid SQL syntax:
Other comment delimiters are not accepted as valid SQL syntax. Due to the lack of uniform standards in the presentation of comments within source code, it is not practical to implement each and every commenting indicator.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center