Progress
Version 9
Product Update Bulletin
SQL Explorer Tool Updates
This section describes the new and changed options available in the SQL Explorer tool.
SQL Explorer Toolbar Icons
Icons on the SQL Explorer toolbar that are now consistent with the MS-Windows industry standard.
Changes To the File Menu’s Save and the Save As Options
The Save As option now behaves the way the Save option functions in earlier versions. SQL Explorer presents a file dialog box, and you select a filename.
The behavior of the Save option has also changed: the text in the input pane is now saved in the previously opened file.
Options On the New View Menu
The new View menu provides the following options:
- Enable Output Display — Directs SQL Explorer to echo the output to the output pane. To enable the output display, choose View
Enable Output Display. (To disable the display, choose View
Enable Output Display again.)
- Table Format — Allows you to alternate between table format and ASCII format.
- Next Result Set — The FetchLimit property specifies the maximum number of records to be retrieved from the database. The default value for FetchLimit is 101 records. When you choose View
Next Result Set, SQL Explorer retrieves the next set of records, up to the maximum set in FetchLimit. For example, if you set FetchLimit to 25 and execute a fetch operation, SQL Explorer returns the first 25 records to you. If you then choose View
Next Result Set, SQL Explorer returns the next 25 records that satisfy the query. When there are no more result sets, the Next Result Set menu item is grayed.
- Previous Result Set — The Previous Result Set option is the inverse of the Next Result Set option. SQL Explorer returns the number of records specified in the FetchLimit property. Using a combination of View
Next Result Set and View
Previous Result Set, you can scroll forward and backward through the database. When there are no previous result sets, the Previous Result Set menu item is dimmed.
- Options — SQL Explorer properties are now grouped into four categories of operation:
SQL Explorer Tool Online Help
The SQL Explorer tool includes enhanced online HTML help.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |