Data Edit Mode
Use this feature found in the Tree or in the Results Window to switch to the Data Edit Mode for a table.
The Data Edit Mode allows you to modify the contents of a table directly from a grid, so you don’t have to create an UPDATE or INSERT statement for editing/creating individual records.
How does it work?
While in the Data Edit Mode you use the arrow keys to move in the grid. You modify some of the values of a record (row) and when moving to a different record Dev4Snow immediately creates and executes an UPDATE statement for the record that you just left. The WHERE clause for this statement includes all of the columns found in the table –even if the table contains a Primary Key, since PKs in Snowflake are not enforced.
If you edit the last empty row when moving to a different row Dev4Snow creates and executes an INSERT statement.
Null values are represented with the word “NULL”. You can also type in the word “NULL” to modify the current value to it if the column allows null values.
When to use this feature?
When NOT to use this feature?
How can I start the Data Edit Mode?
From the Tree menu use the following option:
Or alternatively, after running a query by using the Pencil icon in the Results Window:
Why is the Pencil icon not available in some cases?
The Pencil icon –to start the Data Edit Mode- will be available only when these conditions are met:
select [distinct] [top <N>] * from <table>...