| Package | stimulsoft.report.dictionary.dataSources |
| Class | public class StiSqlSource |
| Inheritance | StiSqlSource  StiDataTableSource StiDataStoreSource StiDataSource StiObject Object |
| Subclasses | StiCustomSource, StiDB2Source, StiDotConnectUniversalSource, StiEffiProzSource, StiFirebirdSource, StiInformixSource, StiJdbcSource, StiMongoDBSource, StiMSAccessSource, StiMySqlSource, StiOdbcSource, StiOleDbSource, StiOracleODPSource, StiOracleSource, StiPostgreSQLSource, StiSqlCeSource, StiSQLiteSource, StiSybaseAdsSource, StiSybaseAseSource, StiUndefinedDataSource, StiUniDirectSource, StiVistaDBSource |
| Property | Defined By | ||
|---|---|---|---|
 | alias : String Gets or sets of the Data Source alias. | StiDataSource | |
| allowExpressions : Boolean Gets or sets value which indicates that sql query of the datasource can contain script expressions or no. | StiSqlSource | ||
| columns : StiDataColumnsCollection Gets or sets the column collection. | StiDataSource | |
| commandTimeout : int Gets or sets a number of seconds to wait while attempting to execute a command, before canceling the attempt and generate an error. | StiSqlSource | ||
| connectionOrder : int Gets or sets value which indicates in which order that datasource will be connect to the data. | StiDataSource | |
| connectOnStart : Boolean [override] Gets or sets value which indicates that datasource not connect to the data automatically. | StiSqlSource | ||
| count : int [read-only] Gets count of elements. | StiDataSource | |
| dataName : String Please instead property DataName use property NameInSource. | StiDataStoreSource | |
| dataTable : DataTable Gets DataTable. | StiDataSource | |
| detailRows : Array = null | StiDataSource | |
| dictionary : StiDictionary Gets or sets the dictionary in which this Data Source is located. | StiDataSource | |
| inherited : Boolean | StiDataSource | |
| initForSubreport : Boolean = false | StiDataSource | |
| isBof : Boolean Gets value indicates that this position specifies to the beginning of data. | StiDataSource | |
| isConnected : Boolean [read-only] Gets value indicates which Data Source is connected with data. | StiDataSource | |
| isEmpty : Boolean [read-only] Gets value indicates that no data. | StiDataSource | |
| isEof : Boolean Gets value indicates that this position specifies to the data end. | StiDataSource | |
| isInited : Boolean = false | StiDataSource | |
| name : String Gets or sets of the Data Source name. | StiDataSource | |
| nameInSource : String Gets or sets the name of Data Source in source of data. | StiDataStoreSource | |
| parameters : StiDataParametersCollection [override] Gets or sets the parameter collection of the SQL query. | StiSqlSource | ||
| position : int Gets the current position. | StiDataSource | |
| realCount : int [read-only] | StiDataSource | |
| reconnectOnEachRow : Boolean Gets or sets value which indicates that datasource reconnect on each master row in master-detail reports. | StiSqlSource | ||
| ref : int | StiDataSource | |
| rows : StiRowsCollection | StiDataSource | |
| rowToLevel : StiHashtable = null | StiDataSource | |
| sqlCommand : String Gets or sets a SQL statement to execute at the Data Source. | StiSqlSource | ||
| states : StiStatesManager [read-only] Gets the component states manager. | StiDataSource | |
| Method | Defined By | ||
|---|---|---|---|
StiSqlSource(nameInSource:String, name:String, alias:String, sqlCommand:String, connectOnStart:Boolean = true, reconnectOnEachRow:Boolean = false, commandTimeout:int = 30) | StiSqlSource | ||
| checkColumnsIndexs():void | StiDataSource | |
| clearAllStates():void Clear all earlier saved object states. | StiDataSource | |
| clone(... args):Object [override] | StiDataSource | |
| connect(datas:StiDataCollection = null, loadData:Boolean = true):void Connect Data Source to data. | StiDataSource | |
| disconnect():void | StiDataSource | |
equals(object:Object):Boolean [override] | StiSqlSource | ||
| first():void Sets a position at the beginning. | StiDataSource | |
| getCategoryName():String [override] | StiDataTableSource | |
| getChildDataSource(relationName:String):StiDataSource Returns the child Data Source by the relation name. | StiDataSource | |
| Returns a collection of Child relations. | StiDataSource | |
| getColumnIndex(columnName:String):int | StiDataSource | |
| getConditions(dataBand:StiDataBand):Array | StiDataSource | |
| getData(columnName:String, index:int = -1):Object | StiDataSource | |
| StiDataSource | ||
| StiDataSource | ||
| getLabel():String | StiDataSource | |
| getLevel():int | StiDataSource | |
| getParentData(relationName:String):StiDataRow Returns the parent row with data for the indicated relation. | StiDataSource | |
| getParentDataSource(relationName:String):StiDataSource Returns the parent Data Source by the relation name. | StiDataSource | |
| Returns the colection of Parent relations. | StiDataSource | |
| getShortTypeName():String Get a short object type name (without library path). | StiObject | |
| getType():Class | StiObject | |
| getTypeName():String | StiObject | |
| isSimple(object:*):Boolean [static] | StiObject | |
| last():void Sets a position on the last element. | StiDataSource | |
memberwiseClone():Object [override] | StiSqlSource | ||
| next():void Sets a position on the next element. | StiDataSource | |
| prior():void Sets a position on the previous element. | StiDataSource | |
| resetData():void | StiDataSource | |
| resetDetailsRows():void | StiDataSource | |
| restoreState(stateName:String):void Restores the earlier saved object state. | StiDataSource | |
| saveState(stateName:String):void Saves the current state of an object. | StiDataSource | |
| setData(dataBand:StiDataBand, relationName:String, filterMethod:Object, sortColumns:Array, reinit:Boolean, component:StiComponent):void | StiDataSource | |
| setDetails(relationName:String):void Set the details data for Data Source. | StiDataSource | |
| setFilter(filterMethod:Object):void Apply filter to data. | StiDataSource | |
| setSort(conditions:Array, sortColumns:Array, component:StiComponent, databand:StiDataBand, groupHeaders:StiComponentsCollection):void Sorts data. | StiDataSource | |
| synchronizeColumns():void | StiDataSource | |
| toString():String | StiDataSource | |
| allowExpressions | property |
Hide Inherited Public Properties
Show Inherited Public PropertiesallowExpressions:BooleanGets or sets value which indicates that sql query of the datasource can contain script expressions or no.
public function get allowExpressions():Boolean public function set allowExpressions(value:Boolean):void| commandTimeout | property |
commandTimeout:intGets or sets a number of seconds to wait while attempting to execute a command, before canceling the attempt and generate an error. Default is 30.
public function get commandTimeout():int public function set commandTimeout(value:int):void| connectOnStart | property |
connectOnStart:Boolean[override] Gets or sets value which indicates that datasource not connect to the data automatically.
public function get connectOnStart():Boolean public function set connectOnStart(value:Boolean):void| parameters | property |
parameters:StiDataParametersCollection[override] Gets or sets the parameter collection of the SQL query.
public function get parameters():StiDataParametersCollection public function set parameters(value:StiDataParametersCollection):void| reconnectOnEachRow | property |
reconnectOnEachRow:BooleanGets or sets value which indicates that datasource reconnect on each master row in master-detail reports.
public function get reconnectOnEachRow():Boolean public function set reconnectOnEachRow(value:Boolean):void| sqlCommand | property |
sqlCommand:StringGets or sets a SQL statement to execute at the Data Source.
public function get sqlCommand():String public function set sqlCommand(value:String):void| StiSqlSource | () | Constructor |
public function StiSqlSource(nameInSource:String, name:String, alias:String, sqlCommand:String, connectOnStart:Boolean = true, reconnectOnEachRow:Boolean = false, commandTimeout:int = 30)nameInSource:String | |
name:String | |
alias:String | |
sqlCommand:String | |
connectOnStart:Boolean (default = true) | |
reconnectOnEachRow:Boolean (default = false) | |
commandTimeout:int (default = 30) |
| equals | () | method |
override public function equals(object:Object):BooleanParameters
object:Object |
Boolean |
| memberwiseClone | () | method |
override public function memberwiseClone():ObjectReturnsObject |