![]() Select the isolation level for database transactions and the way the transactions are committed.Īuto: the current transaction is committed automatically when you submit your local changes to the database server. Submit local changes to the database server. Preview DML of changes that you made to the table. You can select a scope of different cells and revert values in this scope.įor more information about reverting changes, see Submit changes to a database. Revert changes that you made to a cell value. Also, you can press Ctrl and click the necessary rows. To select multiple rows, click numbers in the gutter. ![]() Terminate execution of the current statement or statements.įor more information about working with rows, see Tables. Also, use the Reload Page button when you want to apply a new page size limit setting after its change. Reload data for the table view to synchronize the data that you see in the editor with the contents of the database. Alternatively, to disable the page size restriction, clear the Limit page size to checkbox. In the Limit page size to field, type a new size of a result set page. Alternatively, open settings ( Ctrl+Alt+S) and navigate to Tools | Database | Data Editor and Viewer. To change the size of a result set page, click the Change page size button and select the size. You can change it here by clicking and selecting the necessary limit or in settings. You can see the limit between the navigation buttons. If all the rows are currently shown, navigation icons and the corresponding commands are inactive. If this number is less than the number of rows in the table, only a subset of all the rows is shown at a time. Use navigation icons and corresponding commands for switching between pages that show the table data and change the page size.Ī number of rows that you see on the toolbar are referred to as a result set page. Most of the available functions are accessed by means of controls on the toolbar, context menu commands for the data cells, and associated keyboard shortcuts. In this mode, you can filter and sort data, edit value of the cells directly, and work with rows of the data table. The data editor opens in the query console in-editor results.įor more information about the In-Editor Results, refer to In-Editor Results. The data editor opens in a Result tab of the Services tool window.įor more information about a Result tab of a Services tool window, refer to Result tabs.Ĭlick the In-Editor Results button on the toolbar and run a query. To work with a query results set, in a query console, do one of the following: Right-click an object and select Edit Data. Select a database object and click the Edit Data icon ( ) on the toolbar. To work with a database object data, in the Database tool window, do one of the following: Some of the actions are only available for a database objects data. In AppCode, the data editor lets you work with a database object data and a query results set. The database object data in a Table view. (For database objects data only.) Filtering and sorting queries pane. ![]() In the data editor, you can sort, filter, add, edit and remove the data as well as perform other, associated tasks. The data editor provides a user interface for working with data. ![]()
0 Comments
Leave a Reply. |