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 Database, Field, Join, and Table objects.

Properties

Name	Data Type	Description
Databases	Object	A reference to the Databases collection.
Fields	Object	A reference to the Fields collection.
FilterConditions	Object	A reference to the FilterConditions collection.
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.
Tables	Object	A reference to the Tables collection.

Methods

Name	Description
AddToWhere	Adds a condition to the WHERE clause of a SQL statement.
GetFieldsFromSQLStatement	Returns a collection of field names used in a SQL statement.
GetTableFromSQLStatement	Returns the table specified in the FROM clause of 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.

See Also
Application Object | Databases Collection | Fields Collection | FilterConditions Collection | Joins Collection | Tables Collection