Variable index | Method index | Bottom

Class: symantec.itools.db.pro.AutoDetail

Purpose	Adds a detail RelationView to a MultiView.
Hierarchy	`java.lang.Object \| +----symantec.itools.db.pro.Request \| +----symantec.itools.db.pro.AutoDetail`
Syntax	`public class AutoDetail extends Request`
Description	AutoDetail adds a detail RelationView to a MultiView.
See also	RelationView MultiView Request

Method index | Top | Bottom

AutoDetail: Creates an AutoDetail object.; Syntaxes:

Method index | Top | Bottom

MANY_TO_MANY: Specifies the many to many value for a cardinality setting.
MANY_TO_ONE: Specifies the many to one value for a cardinality setting.
ONE_TO_MANY: Specifies the one to many value for a cardinality setting.
ONE_TO_ONE: Specifies the one to one value for a cardinality setting.

Variable index | Top | Bottom

executeRequest( ): Creates a detail RelationView based on an AutoDetail object.
getDetailProperties( ): Returns an AutoDetail's detail properties.
join(int, int): Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.
setDetailProperties(Properties): Sets an AutoDetail's detail properties.

Constructor index | Method index | Top | Bottom

Constructor: AutoDetail

Purpose	Creates an AutoDetail object.
Syntax	`public AutoDetail(RelationView parenRelationView, ConnectionInfo cInfo)`
Parameters	parentRelationView = The parent RelationView that will have a detail RelationView created for it when the SQL statement for this object is executed. see db.pro.RelationView cInfo = All the connection information necessary to connect to a specific database (DSN). see db.pro.ConnectionInfo
Description	Creates an AutoDetail object.

Variable index | Method index | Top | Bottom

Variable: MANY_TO_MANY

Purpose	Specifies the many to many value for a cardinality setting.
Syntax	`public final static String MANY_TO_MANY`

Variable: MANY_TO_ONE

Purpose	Specifies the many to one value for a cardinality setting.
Syntax	`public final static String MANY_TO_ONE`

Variable: ONE_TO_MANY

Purpose	Specifies the one to many value for a cardinality setting.
Syntax	`public final static String ONE_TO_MANY`

Variable: ONE_TO_ONE

Purpose	Specifies the one to one value for a cardinality setting.
Syntax	`public final static String ONE_TO_ONE`

Variable index | Method index | Top | Bottom

Method: executeRequest

Purpose	Creates a detail RelationView based on an AutoDetail object.
Syntax	`public RelationView executeRequest( ) throws SQLException`
Parameters	None.
Description	Creates a detail RelationView based on an AutoDetail's ConnectionInfo, SQL string, Request properties, and detail properties. The master RelationView is the one that the AutoDetail is based on. Each time the master RelationView's current record changes, the detail RelationView creates a new set of records based on the join settings.
Overrides	executeRequest in class Request
See also	RelationView

Method: getDetailProperties

Purpose	Returns an AutoDetail's detail properties.
Syntax	`public Properties getDetailProperties( )`
Parameters	None.
Description	Returns the detail object properties.

Method: join

Purpose	Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.
Syntax	`public void join(int paramIndex, int resultCol) throws SQLException`
Parameters	paramIndex = Parameter to set from the resultCol value. resultCol = Result column or projection number to set the paramIndex parameter to.
Description	Specifies how to set a parameter in an AutoDetail's SQL statement from a master RelationView's projection.

Method: setDetailProperties

Purpose	Sets an AutoDetail's detail properties.
Syntax	`public void setDetailProperties(Properties detailProps)`
Parameters	Properties = java.util.Properties object containing detail properties. This object defines the cardinality property which is the cardinality setting for a detail RelationView created by a SQL statement. Possible values: ONE_TO_ONE ONE_TO_MANY MANY_TO_ONE MANY_TO_MANY The default value is ONE_TO_MANY.
Description	Sets detail properties. Since these properties have default values, you don't need to call setDetailProperties to execute a Request.
See also	RelationView

Variable index | Method index | Top

Copyright © 1996 Symantec Corporation. All rights reserved.