| Package | at.db.sql |
| Class | public class SQLEngineStatement |
| Implements | ISQLStatement |
| Property | Defined 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 | ||
| Method | Defined 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 | ||
| executionTime | property |
executionTime:Number [read-write]Returns the SQL query's execution time
Implementation public function get executionTime():Number
public function set executionTime(value:Number):void
| itemClass | property |
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.
public function set itemClass(value:Class):void
See also
| lastId | property |
lastId:int [read-only]Returns the last inserted id from the SQL query.
Implementation public function get lastId():int
| paramCollection | property |
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.
public function get paramCollection():Array
public function set paramCollection(value:Array):void
| results | property |
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
| SQLQueryText | property |
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
| SQLStmt | property |
SQLStmt:SQLStatement [read-only]Returns the flash.data.SQLStatement for this SQLEngineStatement.
Implementation public function get SQLStmt():SQLStatement
| SQLEngineStatement | () | constructor |
public function SQLEngineStatement(sqlQueryText:String = null)Constructor for the SQLEngineStatement.
ParameterssqlQueryText:String (default = null) |
| onSQLResults | () | method |
public function onSQLResults(e:SQLEvent):voidInternal result handler that populates the SQLEngineStatements results and lastId properties.
Parameterse:SQLEvent |
| parseParams | () | method |
public function parseParams(value:Object):voidThis 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.
Parametersvalue:Object |
See also