Working with the Data Grid
In addition to the Editor pane, where you can manipulate data with the
INSERT, UPDATE, and DELETE statements, Teratrax Source Guard provides the
Results pane, which is a graphical interface for viewing or modifying data.
The Results pane has a number of features that you can access from the
Results Toolbar. The following is a list of the features on the toolbar from
left to right:
- First Row: Moves the row indicator to
the first row in the Results grid.
- Previous Row: Moves the row indicator
to the row before the current row in the Results grid.
- Next Row: Moves the row indicator to
the row after the current row in the Results grid.
- Last Row: Moves the row indicator to
the last row in the Results grid.
- Delete Current Row (Ctrl+Del): Deletes
the current row after prompting for confirmation.
- Insert New Row (Ctrl+Ins): Inserts a
new and empty row in the grid. Fill in the data in the columns of the new
row and move off the row to save the changes.
- Save Results As XML: Saves the data in
the Results grid to an Extensible Markup Language (XML) file. For a sample
XML file, click here to view the
authors table located in the pubs database.
- Saves Results As CSV: Saves the data in
the Results grid to a comma-separated values (CSV) file, with column names
as a header row, for use with Microsoft Excel. Teratrax Source Guard limits
the results that you can save in a CSV file to the first 65536 rows in the
grid (including header row). You can work with the 65536 rows in Excel.
- Save Results AS HTML: Saves the data in
the Results grid to a HyperText Markup Language (HTML) file with column
names as a header row. For a sample HTML file, click
here to view the
authors table located in the pubs database.
Updating Data
You can update data in a row by simply editing the text and moving off
the row to save the changes. Clicking inside a cell switches it to edit mode
with the text inside the cell selected. Press Enter or F2 to unselect the
text and move the cursor to the end of the cell. Once the cell is in edit
mode, you can type your changes or right-click to have access to
Undo, Cut, Copy, Paste, Delete, and Select All commands from the context menu.
Press ESC to cancel changes before leaving the row.
To process the update in the database, Teratrax Source Guard searches for a
unique index or primary key to uniquely identify the row in order to run the
update against the database. If a unique index or primary key is not found,
Teratrax Source Guard uses all columns in the table to uniquely identify the
row. If there are other rows that are identical based on all columns
(possible if table does not have a primary key or unique index), the update
will fail with the following error message:
"Key column information is insufficient or incorrect. Too many rows were
affected by update."
Column Width
You have complete flexibility with the size of columns in the grid.
Initially, Teratrax Source Guard defaults the width of all columns in the grid
to 110 pixels. Simply drag the edge of the column to resize it. If you resize
columns, Teratrax Source Guard will save the new column size the next time you
run a query.
Grid Behavior with text, ntext, timestamp,
varbinary, image, bit, and uniqueidentifier
Columns of data type text, ntext, timestamp, varbinary,
and image are not displayed in the grid. Instead, an indicator (for example,
MEMO) is displayed. Use the CONVERT function to display the underlying
values for these data types. The following explains the various grid
indicators:
- Columns of type text and ntext
are displayed in the grid as either "Memo" if the cell does not have data
in it or "MEMO" if it contains a value.
- Columns of type timestamp are displayed
in the grid as either "Byte" if the cell does not have data in it or
"BYTE" if it contains a value.
- Columns of type varbinary are displayed
in the grid as either "VarBytes" if the cell does not have data in it or "VARBYTES"
if it contains a value.
- Columns of type image are displayed in
the grid as either "Blob" if the cell does not have data in it or "BLOB"
if it contains a value.
Columns of type bit will display "True" for 1 and "False" for 0.
To edit these cells, Type "True" or "T" for 1 and "False" or "F" for 0. The
values in the database will still be saved as 1 and 0.
Columns of type uniqueidentifier will be displayed with the actual
value. To edit these cells, Type a uniqueidentifier value (for example,
{A9AEC7AB-88A5-41A0-9684-8A79ECD64547}).
When you save grid results, the underlying values (not the indicator)
will be saved in the XML, CSV, or HTML files.
|
