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:

SYNTAX
SQLExplorer> @ConnectTimeout number_of_seconds ; 

HasFetchLimit

The HasFetchLimit property allows you to change the default value of true to the override setting of false:

SYNTAX
SQLExplorer> @HasFetchLimit { true | 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:

SYNTAX
SQLExplorer> @EscapeTimeout number_of_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:

SYNTAX
SQLExplorer> @ReportFormat { standard | by label } ; 

The following example shows data from the family table in the sports2000 database, presented in standard format:

@FetchLimit 5 ;
@ReportFormat standard ;

select relativename, relation, coveredonbenefits, from pub.family ;

RelativeName      Relation          CoveredOnBenefits 
----------------  ----------        ----------------- 
Jenny Koberlein   Daughter          true              
Ken Koberlein     Spouse            true              
Bill Andrews      Son               true              
Sam Andrews       Spouse            true              
Kelly Smith       Daughter          true               

The following example shows the same data from the family table in the sports2000 database, presented in by label format:

@FetchLimit 5 ;
@ReportFormat by label ;

select relativename, relation, coveredonbenefits, from pub.family ;

rec              col                   value

1                RelativeName         Jenny Koberlein
1                Relation             Daughter
1                CoveredOnBenefits    true
1                RelativeName         Ken Koberlein
1                Relation             Spouse
1                CoveredOnBenefits    true
2                RelativeName         Bill Andrews
2                Relation             Son
2                CoveredOnBenefits    true
2                RelativeName         Sam Andrews
2                Relation             Spouse
2                CoveredOnBenefits    true
3                RelativeName         Kelly Smith
3                Relation             Daughter
3                CoveredOnBenefits    true 

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