DataEngine Object

The DataEngine object provides the data-handling component for Stonefield Query. It contains a data dictionary, exposed to the rest of the application as collections of AppView, Database, Field, Join, and Table objects.

Properties

Name Data Type Description

AppViews Object A reference to the AppViews collection.

Databases Object A reference to the Databases collection.

ErrorMessage String The text of any error that occurs.

ExcludeConditions Object A reference to the FilterConditions collection containing exclusion conditions.

Fields Object A reference to the Fields collection.

FilterConditions Object A reference to the FilterConditions collection containing filter conditions.

IncludeJoinsInWhere Boolean Indicates whether joins are included in the WHERE clause. This corresponds to the Include Joins in the WHERE Clause configuration setting but allows it to be changed programmatically.

Joins Object A reference to the Joins collection.

PerformJoins Boolean Indicates whether Stonefield Query performs joins. This corresponds to the Stonefield Query Performs Joins configuration setting but allows it to be changed programmatically.

QuerySplit Boolean True if the query is being split into separate tables; Stonefield Query sometimes needs to do that, such as when the query references a virtual table.

Tables Object A reference to the Tables collection.

Name	Data Type	Description
AppViews	Object	A reference to the AppViews collection.
Databases	Object	A reference to the Databases collection.
ErrorMessage	String	The text of any error that occurs.
ExcludeConditions	Object	A reference to the FilterConditions collection containing exclusion conditions.
Fields	Object	A reference to the Fields collection.
FilterConditions	Object	A reference to the FilterConditions collection containing filter conditions.
IncludeJoinsInWhere	Boolean	Indicates whether joins are included in the WHERE clause. This corresponds to the Include Joins in the WHERE Clause configuration setting but allows it to be changed programmatically.
Joins	Object	A reference to the Joins collection.
PerformJoins	Boolean	Indicates whether Stonefield Query performs joins. This corresponds to the Stonefield Query Performs Joins configuration setting but allows it to be changed programmatically.
QuerySplit	Boolean	True if the query is being split into separate tables; Stonefield Query sometimes needs to do that, such as when the query references a virtual table.
Tables	Object	A reference to the Tables collection.

Methods

Name Description

AddToFavorites Adds a table or field to the Favorites table.

AddToFields Adds fields to the SELECT clause of a SQL statement.

AddToWhere Adds a condition to the WHERE clause of a SQL statement.

GetFieldsFromSQLStatement Returns a collection of field names used in a SQL statement.

GetTablesFromSQLStatement Returns a collection of table names used in a SQL statement.

GetValuesForField Prompts the user for the value of a field.

GetValuesForParameter Prompts the user for the value of a stored procedure parameter.

Name	Description
AddToFavorites	Adds a table or field to the Favorites table.
AddToFields	Adds fields to the SELECT clause of a SQL statement.
AddToWhere	Adds a condition to the WHERE clause of a SQL statement.
GetFieldsFromSQLStatement	Returns a collection of field names used in a SQL statement.
GetTablesFromSQLStatement	Returns a collection of table names used in a SQL statement.
GetValuesForField	Prompts the user for the value of a field.
GetValuesForParameter	Prompts the user for the value of a stored procedure parameter.