/// <summary>
/// Rollback the active transaction. Transactions may be nested.
/// </summary>
public override void RollbackTransaction()
{
VistaDBSQLQuery query = CreateSQLQuery();
query.SQL = "ROLLBACK TRANSACTION";
query.ExecSQL();
query.DropQuery();
}
/// <summary>
/// Begin a transaction. Transactions may be nested.
/// </summary>
public override bool BeginTransaction()
{
VistaDBSQLQuery query = CreateSQLQuery();
query.SQL = "BEGIN TRANSACTION";
query.ExecSQL();
query.DropQuery();
return(true);
}
/// <summary>
/// Commit an active transaction. Transactions may be nested.
/// </summary>
public override bool CommitTransaction()
{
VistaDBSQLQuery query = CreateSQLQuery();
query.SQL = "COMMIT TRANSACTION";
query.ExecSQL();
query.DropQuery();
return(true);
}
/// <summary>
/// Overloaded. Releases the resources used by the component.
/// </summary>
/// <param name="disposing">True for external disposing</param>
protected override void Dispose(bool disposing)
{
if (sqlQuery != null)
{
sqlQuery.DropQuery();
}
sqlQuery = null;
base.Dispose(disposing);
}