The Command Properties dialog box is divided into six tabs. The General, Parameters, and Advanced tabs are used for setting properties of the Command and Parameter objects, while the Relation, Grouping, and Aggregates tabs are used for setting properties that are specific to Command hierarchies.
On the General tab, set the required properties of a Command object.
Command Name
The name of the Command object. This name references an individual Command object within a DataEnvironment object. The default is "Command" plus a unique number (for example, Command1). It is recommended that you change this to a more meaningful name, such as the name of the database object on which the Command object is based.
Note For child Command objects in a relation hierarchy, the Command Name is the field name of the parent Command object that contains a reference to the child.
Connection
The Connection object to which the Command object is related. You can view a list of all Connection objects in the current DataEnvironment object through the combo box.
Note Since the child and parent Command objects must have the same source connection, this feature is disabled in the child's Command Properties dialog box.
Source of Data
This frame contains the control group that specifies the type of data that is retrieved for the Command object.
Database Object
Specifies the database item on which the Command object is based. The options are Stored Procedure, Table, View, or Synonym.
Object Name
Provides a list of all database items of the specified Database Object.
SQL Statement
The SQL command that the Command object uses for its data source. Use the edit control to enter a SQL command.
SQL Builder
Accesses the query designer for a Command object when the command source is text.