Insert/Update Wizard

The Insert Wizard and Update Wizard let you add a new row or change an existing row without writing SQL by hand. You fill in the fields you want, SyncriTab builds the statement for you, and you execute it with one click.

Overview

Both wizards show the table's columns as a form. As you type values, SyncriTab generates the INSERT or UPDATE statement live in a syntax-highlighted SQL panel at the bottom. You can review the statement before executing it, and the dialog closes automatically when the statement succeeds.

The wizards work with tables and views that have a primary key. Auto-increment (identity) columns are shown but cannot be edited, because the database assigns their values automatically.

Insert Wizard

Opening the Insert Wizard

The Insert Wizard is available when you are viewing a table's data through Browse Data in the catalog pane. Right-click anywhere in the Browse Data grid and choose Insert new record from the menu.

The Insert Wizard is not available from a query result grid. To insert a row using a query, write an INSERT statement in the SQL editor and run it.

Using the Insert Wizard

The wizard opens a dialog with a row for each column in the table:

Column name — the name of the column.
Data type — the column's SQL data type, such as varchar(30) or int.
Value — a text box where you type the value to insert. Leave it blank to skip the column entirely; SyncriTab leaves that column out of the generated statement.

Auto-increment (identity) columns are shown with a grayed-out value box and cannot be edited. SyncriTab never includes them in the INSERT statement.

As you type, the SQL panel at the bottom updates the generated statement. For example, if a Customer table has an auto-increment id, a fullname, and a dob column, and you type only a name, the panel shows:

INSERT INTO Customer (fullname) VALUES ('John Smith')

If you skip a column entirely it is omitted from the statement; the database uses whatever default value or null the column allows.

Inserting a NULL

To insert an explicit NULL (rather than just skipping a column), type $$NULL in the value box. SyncriTab replaces it with an unquoted NULL in the generated statement.

Executing the Insert

Click Execute to run the generated INSERT statement. SyncriTab reports success or shows the database error in red.

If Auto-close on success is checked (the default), the dialog closes automatically after a successful insert. Uncheck it if you want to insert several rows one after another; the form stays open so you can clear it and fill in the next row.

Update Wizard

Opening the Update Wizard

You can open the Update Wizard in two ways:

From a Browse Data grid: right-click a row in the Browse Data grid (available from the catalog pane) and choose Update selected record, or simply double-click the row.
From a query result: run a query against a single table and double-click any row in the result grid. This works only when the query reads from one table and that table has a primary key. If the table has no primary key, SyncriTab shows an error and the wizard does not open.

Using the Update Wizard

The Update Wizard shows the same column list as the Insert Wizard, but it has an extra Current value column showing what the row contains right now. The New value column is pre-filled with the same values, so the generated UPDATE statement starts as a no-op and only changes as you edit fields.

Each row also has an Ignore toggle. When a column is marked Ignore, it is left out of the SET clause. A field is ignored automatically if you clear its new-value box. Double-click a row, or click its Ignore button, to toggle it.

Primary key columns identify which row to update. They appear in the WHERE clause of the generated statement and their new-value boxes are disabled to prevent accidentally changing the key.

As you edit values, SyncriTab regenerates the UPDATE statement live. For example:

UPDATE Customer SET fullname = 'Jane Smith', dob = '1990-05-14' WHERE id = 42

Setting a column to NULL

To set a nullable column to NULL, type $$NULL in its new-value box. SyncriTab renders it as an unquoted NULL in the SET clause.

Executing the Update

Click Execute to run the generated UPDATE statement. SyncriTab reports success or shows the database error. If the update succeeds and the row is visible in the grid, the grid cell updates immediately to reflect the new value.

As with the Insert Wizard, Auto-close on success closes the dialog after a successful update when checked.

The SQL panel

The SQL panel at the bottom of both wizards shows the generated statement with syntax highlighting. It is read-only: you cannot edit the statement directly. If the generated statement isn't what you want, adjust the values in the fields above and the panel updates accordingly.

To run a custom statement instead, close the wizard and type directly in the SQL editor. See Running Queries & Results.

Limitations

The Insert Wizard is only available from a Browse Data grid, not from a query result.
The Update Wizard from a query result is available only when the query reads from exactly one table.
The table must have a primary key for the Update Wizard to work. Without one, the wizard cannot build a unique WHERE clause.
The wizards run a single INSERT or UPDATE each time. To apply changes in bulk, write a query instead.
If you connected with Manual Commit, the change is not saved to the database until you commit. If you roll back, the change is undone even though the wizard reported success.