QueryDef object methods
Method name
Description
BuildField
Selects a field to include in the query's search results.
BuildFilterOperator
Creates the top-level
QueryFilterNode Object
for the query.
BuildUniqueKeyField
Builds and returns a unique key query field.
CreateTopNode
Creates a new root filter node, automatically attaches the old top node as its child.
GetFieldByPosition
Returns a QueryFieldDef object with the specified position.
GetPrimaryEntityDefName
Returns the primary EntityDef name for the QueryDef.
IsFieldLegalForQuery
Returns a Bool indicating whether a field is legal to be included in a query.
Save
Saves the query to the specified file.
Remarque :
For all Perl Get and Set methods that map to Visual Basic Properties, see the Properties section of this object.
Additional Perl Methods that map to Visual Basic properties:
Method name
Description
CreateTopNode
Creates a new root filter node, automatically attaches the old top node as its child.
Get
IsSQLGenerated
Returns a Bool indicating whether any fields of the query are SQL generated.
Get
Name
Returns the name associated with the query.
Get
QueryFieldDefs
Returns the collection of QueryFieldDef objects included in the query.
Get
SQL
Returns the SQL string associated with the query.
IsAggregated
Returns a Boolean indicating whether any fields of the query are aggregated.
IsDirty
Returns a Boolean indicating whether the query has changed.
IsMultiType
Returns a Boolean indicating whether the QueryDef object is multitype.
Get
QueryType
Returns an Integer indicating list, report, or chart.
Set
Name
Sets the name associated with the query.
Set
SQL
Sets the SQL string associated with the query.
BuildField
BuildFilterOperator
BuildUniqueKeyField
CreateTopNode
GetFieldByPosition
GetPrimaryEntityDefName
IsFieldLegalForQuery
Save
Sujet parent :
QueryDef Object
Commentaires en retour