You specify and control the operation of the Select bean by opening the property sheet
for the Select bean and setting the value of the displayed properties. To open the
property sheet of a Select bean on the Visual Composition Editor surface:
- Right click the Select bean. The bean menu displays.
- Click Properties. The Properties sheet displays.

You can control:
- The name of the Select bean. Specify the name as the beanName property value.
- Whether to enable inserts, updates, and deletes for result sets which contain
user-defined (distinct) types. Specify this in the distinctTypesEnabled
property value. Check the Show Expert Features checkbox to display this
property.
- Whether as many rows as possible should be fetched into the cache as soon as you execute
your query (given your settings for the above properties), or rows should be fetched only
as you ask for them. Specify this in the fillCacheOnExecute property
value. Check the Show Expert Features checkbox to display this property.
- Whether to force generation of searched rather than positioned SQL UPDATE and DELETE
statements for the result set returned by the statement. Specify this in the forceSearchedUpdate.
property value. Check the Show Expert Features checkbox to display this
property.
- Whether to acquire and hold a database lock for a row while it is the current row.
Specify this in the lockRows property value. Check the Show Expert Features
checkbox to display this property.
- The maximum number of packets allowed in the cache at one time. (Older packets may be
displaced as newer packets are fetched.) Specify this in the maximumPacketsInCache
property value. Check the Show Expert Features checkbox to display this
property.
- The maximum number of rows you can fetch into the cache over time. Specify this in the maximumRows
property value. Check the Show Expert Features checkbox to display this
property.
- The number of rows in a packet. Specify this
in the packetSize property value. Check the Show Expert Features
checkbox to display this property.
- The database connection characteristics and SQL statement. Specify these as a composite
value for the query property. See Specifying a Connection
and SQL Statement.
- Whether the result set is updatable. Specify this in the readOnly property value.
- The maximum number of seconds allowed for the statement to execute. Specify this in the timeout
property value. The default is 0, which means no maximum. Check the Show Expert Features checkbox to display this
property.
Specifying a connection and SQL statement
Select
