TSQLTransaction class

Declaration

Inheritance

1. TSQLTransaction
2. TDBTransaction
3. TComponent
4. TPersistent
5. TObject

Description

TSQLTransaction represents the transaction in which one or more TSQLQuery instances are doing their work. It contains the methods for committing or doing a rollback of the results of query. At least one TSQLTransaction must be used for each TSQLConnection used in an application.

See also

• TSQLQuery
• TSQLConnection

Properties

Handle	public	Low-level transaction handle.
SQLConnection	public	Database as TSQLConnection.
Action	published	Currently unused in SQLDB.
Database	published	Database for which this component is handling connections.
Params	published	Transaction parameters.
Options	published	Transaction options.

Methods

UnPrepareStatements	protected
MaybeStartTransaction	protected
AllowClose	protected
CloseDataset	protected
GetHandle	protected
SetDatabase	protected
LogEvent	protected
Log	protected
Create	public	Create a new transaction.
Destroy	public	Destroy transaction component.
Commit	public	Commit the transaction, end transaction context.
CommitRetaining	public	Commit the transaction, retain transaction context.
Rollback	public	Roll back all changes made in the current transaction.
RollbackRetaining	public	Roll back changes made in the transaction, keep transaction context.
StartTransaction	public	Start a new transaction.
EndTransaction	public	End the transaction.

Inherited

From TDBTransaction (13)

Active CheckActive CheckDatabase CheckInactive CloseDataSets CloseTrans DatasetCount Datasets InternalHandleException Loaded OpenTrans RegisterDataset UnRegisterDataset

From TComponent (73)

_AddRef _Release BeforeDestruction CanObserve ChangeName ComObject ComponentCount ComponentIndex Components ComponentState ComponentStyle DefineProperties DesignInfo DestroyComponents Destroying ExecuteAction FindComponent FreeNotification FreeOnRelease GetChildOwner GetChildParent GetChildren GetDeltaStreams GetEnumerator GetIDsOfNames GetNamePath GetObservers GetOwner GetParentComponent GetTypeInfo GetTypeInfoCount HasParent iicrGetComponent InsertComponent Invoke IsImplementorOf Loading Name Notification ObserverAdded Observers OnGetDeltaStreams Owner PaletteCreated QueryInterface ReadDeltaState ReadDeltaStream ReadState ReferenceInterface RemoveComponent RemoveFreeNotification RemoveFreeNotifications SafeCallException SetAncestor SetChildOrder SetDesigning SetDesignInstance SetInline SetName SetParentComponent SetSubComponent Tag ToString TToStringNameMode UpdateAction Updated UpdateRegistry Updating ValidateContainer ValidateInsert ValidateRename VCLComObject WriteState

From TPersistent (5)

Assign AssignTo FPOAttachObserver FPODetachObserver FPONotifyObservers

From TObject (37)

AfterConstruction CheckDisposed ClassInfo ClassName ClassNameIs ClassParent ClassType CleanupInstance DefaultHandler DefaultHandlerStr Dispatch DispatchStr Disposed DisposeOf Equals FieldAddress Free FreeInstance GetDisposed GetHashCode GetInterface GetInterfaceByStr GetInterfaceEntry GetInterfaceEntryByStr GetInterfaceTable GetInterfaceWeak GetLastCastErrorInfo InheritsFrom InitInstance InstanceSize MethodAddress MethodName newinstance QualifiedClassName StringMessageTable SystemHasExtendedRTTI UnitName