2. Editing data
OrmFactory provides a flexible environment for viewing and editing database data. You can modify, insert, or delete rows in tables, including joined tables, directly from the interface.
Opening the data editor
Data editing is primarily done through the Query Window, which is always associated with a specific connection.
- Open a new Query Window from the menu: Query → New query window.
- Or right-click a connection in the Project Explorer and select Open query window.
You can also open a Query Window directly from a table or from a layout via Query data in the context menu. In this case, a SELECT * FROM table query is automatically executed:
Note: The Query Window is the main interface for executing queries, viewing results, and initiating data editing.
Editing overview
Once the Query Window is open, you can start editing data in the data area:
- Changes in joined tables are supported.
- Insert new rows using the empty row at the bottom of the grid. Filling any cell converts it into a pending insert.
- Delete rows via the context menu. Deleted rows are marked visually until changes are applied.
- All changes are applied using Preview, Apply, or Discard. For details on editing workflow, see 2.2. Edit mode
Preview/Apply/Discard: Preview shows the SQL statements generated for your changes. Apply executes them, and Discard cancels any pending edits.
Import and export
OrmFactory allows moving data to and from external formats:
- Export is available directly from the Query Window. For supported formats and settings, see 2.3. Export data
- Import is initiated from the Project Explorer on a table. For supported formats and detailed workflow, see 2.4. Import data
- Export is performed in a streaming mode, allowing efficient handling of large datasets without loading everything into memory.
- Import also uses a streaming approach with configurable batch sizes, so large files can be processed without consuming excessive memory.
This parent page provides an overview of Editing data. For detailed instructions and interface guidance, follow the links to the respective articles.