constructor __construct [line 348]
method BeginTrans [line 124]
Begins a new transaction against the database server.
Call BeginTrans to begin a new transaction against the database server.
Updates, insertions, and deletions that take place after a call to StartTransaction are held by the server until an application calls CompleteTrans with true to commit the changes or false to Rollback
Tags:
Overridden in child classes as:
- Database::BeginTrans()
- MySQLDatabase::BeginTrans()
- OracleDatabase::BeginTrans()
method Close [line 380]
Closes the connection.
Call Close to disconnect from the remote source of database information. Before the connection component is deactivated, all associated datasets are closed. Calling Close is the same as setting the Connected property to false.
Tags:
method CompleteTrans [line 150]
bool CompleteTrans(
[bool
$autocomplete = true])
|
|
Permanently stores updates, insertions, and deletions of data associated with
the current transaction, and ends the current transactions, but if false is sent in the autocomplete parameter, then a rollback is performed and then Cancels all updates, insertions, and deletions for the current transaction and ends the transaction.
Call CompleteTrans to permanently store to the database server all updates, insertions, and deletions of data associated with the current transaction and then end the transaction. The current transaction is the last transaction started by calling BeginTrans.
If you send false on the autocomplete parameter, then it cancels all updates, insertions, and deletions for the current transaction and to end the transaction. The current transaction is the last transaction started by calling BeginTrans.
Tags:
Overridden in child classes as:
- Database::CompleteTrans()
- MySQLDatabase::CompleteTrans()
- OracleDatabase::CompleteTrans()
Parameters:
method DBDate [line 190]
method defaultClients [line 255]
method defaultConnected [line 445]
method defaultDataSets [line 95]
method defaultOnAfterConnect [line 272]
void defaultOnAfterConnect(
)
|
|
method defaultOnAfterDisconnect [line 311]
void defaultOnAfterDisconnect(
)
|
|
method defaultOnBeforeConnect [line 289]
void defaultOnBeforeConnect(
)
|
|
method defaultOnBeforeDisconnect [line 327]
void defaultOnBeforeDisconnect(
)
|
|
method defaultOnCustomConnect [line 295]
void defaultOnCustomConnect(
)
|
|
method defaultOnLogin [line 346]
method DoConnect [line 457]
Provides the interface for a method that opens a connection.
The Connected property uses DoConnect to establish a connection. Descendant classes override the DoConnect method to establish their connection as appropriate. As implemented in CustomConnection, DoConnect does nothing.
Tags:
Overridden in child classes as:
- Database::DoConnect()
- MySQLDatabase::DoConnect()
- OracleDatabase::DoConnect()
method DoDisconnect [line 471]
method getOnCustomConnect [line 293]
void getOnCustomConnect(
)
|
|
method loaded [line 386]
Overrides
Component::loaded() (Initializes the component after the form file has been read into memory.)
method MetaFields [line 109]
method Open [line 365]
Opens the connection.
Call Open to establish a connection to the remote source of database information. Open sets the Connected property to true.
Tags:
method Param [line 225]
string Param(
string
$input)
|
|
Returns a parameter formatted depending on the database type
When writting parametrized queries, use this method to get a parameter formatted in a valid format for the current database type.
Tags:
Overridden in child classes as:
- Database::Param()
- MySQLDatabase::Param()
- OracleDatabase::Param()
Parameters:
method Prepare [line 209]
void Prepare(
string
$query)
|
|
Sends a query to the server for optimization prior to execution.
Call Prepare to have a remote database server allocate resources for the query and to perform additional optimizations.
If the query will only be executed once, the application does not need to explicitly call Prepare. Executing an unprepared query generates these calls automatically. However, if the same query is to be executed repeatedly, it is more efficient to prevent these automatic calls by calling Prepare explicitly.
Overridden in child classes as:
- Database::Prepare()
- MySQLDatabase::Prepare()
- OracleDatabase::Prepare()
- Prepares a query to be executed and performs parameter optimizations
Parameters:
method QuoteStr [line 241]
method readClients [line 253]
Returns the clients of this database
Tags:
method readConnected [line 414]
Determines whether a connection has been established to the remote source of data.
Set Connected to true to open the connection. Set Connected to false to terminate the connection.
Setting Connected to true generates a OnBeforeConnect event, calls the protected DoConnect method to establish the connection, and generates an OnAfterConnect event. In addition, when setting Connected to true.
Setting Connected to false generates a OnBeforeDisconnect event, calls the protected DoConnect method to drop the connection, and generates an OnAfterDisconnect event.
When deriving custom connection components from CustomConnection, override readConnected to return true when a connection is established, and override DoConnect and DoDisconnect to create and drop the connection.
Tags:
Overridden in child classes as:
- Database::readConnected()
- Specifies if the database is connected or not
- IBDatabase::readConnected()
- MySQLDatabase::readConnected()
- OracleDatabase::readConnected()
method readDataSets [line 93]
Provides an indexed array of all active datasets for a database component.
Use DataSets to access active datasets associated with a database component. An active dataset is one that is currently open.
Tags:
method readOnAfterConnect [line 270]
mixed readOnAfterConnect(
)
|
|
Occurs after a connection is established.
Write an OnAfterConnect event handler to take application-specific actions immediately after the connection component opens a connection to the remote source of database information.
Tags:
method readOnAfterDisconnect [line 309]
mixed readOnAfterDisconnect(
)
|
|
Occurs after the connection closes.
Write an OnAfterDisconnect event handler to take application-specific actions after the connection component drops a connection.
Tags:
method readOnBeforeConnect [line 287]
mixed readOnBeforeConnect(
)
|
|
Occurs immediately before establishing a connection.
Write a OnBeforeConnect event handler to take application-specific actions before the connection component opens a connection to the remote source of database information.
Tags:
method readOnBeforeDisconnect [line 325]
mixed readOnBeforeDisconnect(
)
|
|
Occurs immediately before the connection closes.
Write a BeforeDisconnect event handler to take application-specific actions before dropping a connection.
Tags:
method readOnLogin [line 344]
Occurs when an application connects to a database.
Write an OnLogin event handler to take specific actions when an application attempts to connect to a database.
If there is no OnLogin event handler, the current UserName and Password are the ones used from the UserName and UserPassword properties.
These values are then passed to the remote server.
method SendConnectEvent [line 167]
void SendConnectEvent(
$connecting
$connecting)
|
|
Send a connect event to all the datasets, both for connecting and disconnecting
This is an internal method used to fire a dataset connect event to all attached datasets.
Tags:
Parameters:
method setOnCustomConnect [line 294]
void setOnCustomConnect(
$value)
|
|
Parameters:
method writeClients [line 254]
void writeClients(
$value)
|
|
Parameters:
method writeConnected [line 415]
void writeConnected(
$value)
|
|
Parameters:
method writeDataSets [line 94]
void writeDataSets(
$value)
|
|
Parameters:
method writeOnAfterConnect [line 271]
void writeOnAfterConnect(
$value)
|
|
Parameters:
method writeOnAfterDisconnect [line 310]
void writeOnAfterDisconnect(
$value)
|
|
Parameters:
method writeOnBeforeConnect [line 288]
void writeOnBeforeConnect(
$value)
|
|
Parameters:
method writeOnBeforeDisconnect [line 326]
void writeOnBeforeDisconnect(
$value)
|
|
Parameters:
method writeOnLogin [line 345]
void writeOnLogin(
$value)
|
|
Parameters: