Progress
Version 9
Product Update Bulletin
New Properties For GUI and Character Interfaces
The new properties described in this section are available for both the graphical and character SQL Explorer interfaces. For consistency, the syntax diagrams are in character-mode format.
ConnectTimeout
The ConnectTimeout property allows you to specify the maximum number of seconds SQL Explorer should wait when attempting to establish a connection, before terminating the connection request. The default value is 180 seconds:
HasFetchLimit
The HasFetchLimit property allows you to change the default value of true to the override setting of false:
The HasFetchLimit property is related to the FetchLimit property. Earlier versions of SQL Explorer enforces a fetch limit, and the default for the FetchLimit property remains at 101 records. Setting HasFetchLimit to false allows you to disable the fetch limit completely, without requiring you to set an artificially high FetchLimit.
EscapeTimeout
The EscapeTimeout property allows you to specify the maximum number of seconds SQL Explorer should wait before returning to the shell and executing a shell command. The default value for EscapeTimeout is 15 seconds:
ReportFormat
The ReportFormat property allows you to override the standard format display for output data. Setting this property to the by label format directs SQL Explorer to return data in an alternative format. A single output line in the by label format returns the record id, column name, and column value for one column in the result set:
The following example shows data from the family table in the sports2000 database, presented in standard format:
The following example shows the same data from the family table in the sports2000 database, presented in by label format:
NOTE: To change the display format of data you have already fetched, you first set the ReportFormat property, and then fetch the data again. SQL Explorer does not reformat the display of data that has already been fetched.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |