Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MS SQL Maestro online Help

Prev  Return to chapter overview Next 

Editing grid data

MS SQL Maestro allows you to edit data in grids directly. Just click on the cell to edit and enter the new cell value. For column, which is linked by foreign key with a (single) column from another table, use lookup editor. The editor displays the contents of parent table’s columns within the drop-down window. To invoke the editor double click on a selected cell.

 

 

You can also use the Data Input Form for this purpose. To invoke the dialog use the appropriate item from the popup menu. It's fields display the values of the current grid row.

Use the Insert button to add the form values as a new row to the grid.

Use the Post button to update the current row.

The Cancel button reverts all the field values within a form to their initial values (or to the last posted values).

The Previous and Next buttons allow you to navigate the grid without closing the Data Input Form.
 



Prev  Return to chapter overview Next