About the SQLDataGrid in runtime

During run time, you can select the database table, view, or query that will populate the SQLDataGrid graphic and change the appearance of the data.

You can use the run-time application to perform the following tasks:

• Move columns

• Group columns

• Aggregate column values

• Filter columns

• Sort columns

If you have the appropriate permissions, you can also make the following changes to the database:

• Change the order of columns in an existing row.

• Insert a row into a table.

• Update a row in a table.

• Delete a row from a table.

  Note: You cannot update or delete a row in a table unless that table has a primary key defined. You can add new rows to a table without a primary key as long as that is the only action you are performing on the table.