Packageat.db.sql
Classpublic class SQLEngineStatement
ImplementsISQLStatement

An implementation of the ISQLStatement interface. This class is the basis for all database transaction data in the SQL Engine.



Public Properties
 PropertyDefined by
  executionTime : Number
Returns the SQL query's execution time
SQLEngineStatement
  itemClass : Class
[write-only] Sets the itemClass for the SQLStatement.
SQLEngineStatement
  lastId : int
[read-only] Returns the last inserted id from the SQL query.
SQLEngineStatement
  paramCollection : Array
Returns the array of ISQLParams for this statement.
SQLEngineStatement
  results : Object
This method returns the results from the executed SQL Statement.
SQLEngineStatement
  SQLQueryText : String
Returns the SQL query used in this statement.
SQLEngineStatement
  SQLStmt : SQLStatement
[read-only] Returns the flash.data.SQLStatement for this SQLEngineStatement.
SQLEngineStatement
Public Methods
 MethodDefined by
  
SQLEngineStatement(sqlQueryText:String = null)
Constructor for the SQLEngineStatement.
SQLEngineStatement
  
onSQLResults(e:SQLEvent):void
Internal result handler that populates the SQLEngineStatements results and lastId properties.
SQLEngineStatement
  
parseParams(value:Object):void
This method is the implementaion of the ISQLStatement's parseParams.
SQLEngineStatement
Property detail
executionTimeproperty
executionTime:Number  [read-write]

Returns the SQL query's execution time

Implementation
    public function get executionTime():Number
    public function set executionTime(value:Number):void
itemClassproperty 
itemClass:Class  [write-only]

Sets the itemClass for the SQLStatement. When the results are returned after the SQL statement has been execute. It will return the results in an array of strongly typed objects specified by the itemClass.

Implementation
    public function set itemClass(value:Class):void

See also

flash.data.SQLStatement
lastIdproperty 
lastId:int  [read-only]

Returns the last inserted id from the SQL query.

Implementation
    public function get lastId():int
paramCollectionproperty 
paramCollection:Array  [read-write]

Returns the array of ISQLParams for this statement. If no params are supplied it returns an array with a single object that contains a property "noParams" and it's value is "true". In the parseParams() function it will watch for this value and skip the addition of parameters to the SQLStatement.

Implementation
    public function get paramCollection():Array
    public function set paramCollection(value:Array):void
resultsproperty 
results:Object  [read-write]

This method returns the results from the executed SQL Statement.

Implementation
    public function get results():Object
    public function set results(value:Object):void
SQLQueryTextproperty 
SQLQueryText:String  [read-write]

Returns the SQL query used in this statement.

Implementation
    public function get SQLQueryText():String
    public function set SQLQueryText(value:String):void
SQLStmtproperty 
SQLStmt:SQLStatement  [read-only]

Returns the flash.data.SQLStatement for this SQLEngineStatement.

Implementation
    public function get SQLStmt():SQLStatement
Constructor detail
SQLEngineStatement()constructor
public function SQLEngineStatement(sqlQueryText:String = null)

Constructor for the SQLEngineStatement.

Parameters
sqlQueryText:String (default = null) — Optional. The SQL query that is to be used with this statement.
Method detail
onSQLResults()method
public function onSQLResults(e:SQLEvent):void

Internal result handler that populates the SQLEngineStatements results and lastId properties.

Parameters
e:SQLEvent
parseParams()method 
public function parseParams(value:Object):void

This method is the implementaion of the ISQLStatement's parseParams. This method processes the value (parameter object) and applies value object's properties to the parameters specified in the SQL statement.

Parameters
value:Object

See also

at.tracking.sql.paramCollection