DML Dialog

In the main window, double-click on a row in the resultset grid to display the DML Dialog. Here you can edit the results of a single row to generate INSERTs, UPDATEs, DELETEs, or UPSERT statements.

Main Windows

The schema and table names are parsed from the last used SQL statement. If no table was found, then no SQL will be generated.

If the table you are modifying does not have a key, then the SQL UPDATE or DELETE statement will be generated without a WHERE clause. A warning will be shown at the top of the dialog. Be careful!

Back to Table of Contents.