Fields
Grid
Displays the results of the last successfully executed SELECT statement or stored procedure.
Editing, Inserting and Deleting Records
To edit a record, simply type or paste your revisions into the cells of the results grid. Cells that have been edited display with a green background. To insert a record, use the insert option in the edit menu (see edit/insert below for details). To delete records, select the records you want to delete and use the delete option in the edit menu (see edit/delete below for details). Use the undo option in the edit menu to reverse your changes to edited cells or inserted records prior to saving (see edit/undo below for details). To save your changes, use the save option in the file menu. Changes saved in the results grid are treated the same as UPDATE, INSERT, and DELETE commands by the database. As a result, you can use the ROLLBACK command to undo your results grid changes even after you have saved them.
Working With BLOB Data
If the results grid contains Binary Large Object (BLOB) data, the respective cells in the results grid will display "BLOB" instead of the actual BLOB data. BLOB data is generally either too large, or of the wrong type, to be viewed within the cells of the results grid. To work with the BLOB data, select the cell containing the BLOB data and click the view detail button. In the view detail (BLOB) you can edit, view, copy or save the BLOB data to a file.
Tip: If you leave the view detail (BLOB) window open as you scroll through the results grid, the window will remain on top and automatically update to display the BLOB data contained within the currently selected cell.
Auto-Size Columns
To auto-size a column in the grid, double-click on the column heading. To auto-size all
columns in the grid, double-click on the row number column heading. Use results tab options to specify whether
column headings should be included or excluded from the column auto-size calculation.
Date/Time Format
Date/Time formatting is controlled by the "regional settings" in the Windows
Control Panel. To change date/time formatting, select "settings" then
"control panel" from your windows start menu, then select "regional
settings." See Windows help for details. Note, if you intend to pass a date/time to
Oracle, it must be in the format 'YYYY-MM-DD HH24:MI:SS'. To enable Oracle to accept this date format you may have to send the following SQL command: ALTER SESSION SET NLS_Date_Format = 'YYYY-MM-DD HH24:MI:SS';. Alternatively, the SQL function
TO_DATE() can be used to format date/time data passed to Oracle.
Column Headings
Use the "AS" keyword in your SELECT statement to override the default column headings in the results grid. For example: The SQL command "SELECT ColumnName AS MyOverride FROM TableName" will cause "MyOverride" to appear as the column heading in the results grid instead of the default column heading.
Sum
Displays the sum of the amounts in the currently selected cells in the results grid. Use results tab options to turn sum calculation
on or off.
Buttons
Cancel
Cancel the load of the current query results into the grid. This button is only visible
while query results are being loaded into the grid. If you cancel a load, the File\Save As
menu option will still save the complete query results in .ADO and .SQL format even though the complete
results were not loaded into the grid.
View Detail
Display and work with the BLOB data contained in the currently selected cell in the results grid (the View Detail window will appear). This button is only visible when you select a cell that contains BLOB data.
Menu / Toolbar
 File/Save Results
Save the changes in the results grid. Saved changes are treated the same as UPDATE, INSERT, and DELETE commands by the database. As a result, you may be able to use the ROLLBACK command to reverse your changes even after you have saved them (depending on your auto commit selection in command tab options).
 File/Save As
Save the current query results to a file. You can save the results in ADO
(.ADO), HTML (.HTM), text (.TXT), or SQL (.SQL) format by selecting the desired
format from the save as type list in the save as dialog. The ADO and SQL options
are only available if the last query executed was a SELECT or EXEC
statement. Use results tab options to specify the HTML template file that will be used to format results saved as an HTML document. Results saved in SQL format are saved as INSERT statements.
Use results tab options to specify the delimiter for results saved as a text file.
Tip:
If you save using the ADO format, you can use Process/Insert Data to
move selected data from one table, database or database provider (i.e. MS
Access to Oracle, Oracle to MS SQL Server, etc.) to another.
 Edit/Copy
Copy the text in the currently selected cells to the clipboard. If you select an entire
column, the column heading is also copied to the clipboard. Use results tab options to specify the copy delimiter.
 Edit/Paste
Paste the data in the clipboard into the currently selected cells. If you paste into an insert row and your paste data contains multiple records, additional insert rows will be generated automatically to accommodate the data for each pasted record. Use results tab options to specify the paste delimiter.
 Edit/Insert
Insert a new record in the results grid. Type or paste the data for the new record into cells of the inserted row. If you want to paste multiple records into the results grid, first insert a new record, then use edit/paste to paste the new records into the inserted row -- additional insert rows will be generated automatically to accommodate each record in the paste data. Inserted records display with a yellow background.
Tip: If your new record contains a field that the database populates automatically (such as an auto-number or globally unique identifier column), you must leave this field blank in the grid, thus allowing the database to populate the field for you when you save the new record. QueryODBC will display the value(s) assigned by the database after you save the new record.
 Edit/Delete
Delete the selected record(s) in the results grid. Deleted records display with a red background.
Edit/Undo
Reverse the changes to the selected edited cell or inserted record. This option is only available if you have not yet saved your changes. If you have saved your changes you may still be able to reverse the changes by executing the ROLLBACK command in the command tab (depending on your auto commit selection in command tab options).
 Edit/Find/Replace
Find or replace text in the currently selected cells in the results grid. The
find drop list displays all previous search text for the current session.
Use the Trim replaced text checkbox to trim leading and
trailing spaces from the updated cell text resulting from the replace
operation. This checkbox is helpful in avoiding problems with maximum
character limitations when performing replace operations on CHAR fields.
Note that the number of characters in a CHAR field is always equal to the
maximum since database systems pad these fields with trailing
spaces.
 Edit/Format Cells
If focus is in the results grid, change the format of amounts in the
currently selected cells. If focus is in the Sum editbox, change the format of the Sum
editbox.
Edit/Font
Change the font, font size, font bold, and font italic attributes of the text in the
results grid. Note, the selected font is also applied to the command text field, the statistics
text field and the schema grid.
 Process/Sort
Sort all rows in the results grid by the currently selected column(s). If more than one
column is selected, the leftmost selected column is used as the first sort key. Additional
selected columns are used as the second and greater sort keys (i.e. 2nd selected column
from the left is used as second sort key, 3rd selected column from the left is used as the
third sort key, etc.).
If you wish to sort amount data, the amount cells must be formatted
using generic format (no commas, or percents – see Edit/Format Cells above).
Additionally, amounts greater than 2,147,483,647 or less than -2,147,483,648 will not be
sorted. If you wish to sort by a column that contains amounts greater than 2,147,483,647
or less than -2,147,483,648, use the ORDER BY keyword in your query instead of this menu
option to perform the sort.
 Process/Options
Display results tab options.
| 
