TADStoredProc Members

The following tables list the members exposed by TADStoredProc.

Event	Description
AfterApplyUpdates	Fires after cached updates are applied to DB.
AfterExecute	Fires after SQL command execution is finished.
AfterGetRecord	Fires after fetching next rowset one time for each fetched record.
AfterGetRecords	Fires after fetching next rowset.
AfterRowRequest	Fires after fetching record.
BeforeApplyUpdates	Fires before cached updates are applied to DB.
BeforeExecute	Fires before SQL command execution is started.
BeforeGetRecords	Fires before fetching next rowset.
BeforeRowRequest	Fires before fetching record.
OnCommandChanged	Fires after the SQL property value is changed.
OnError	The event fires when an error happens, while dataset is communicating with DBMS.
OnExecuteError	The event is triggered when an error happens, while executing a Array DML query.
OnMasterSetValues	Fires after a detailed dataset has set detailed query parameters.
OnReconcileError	Fires when a dataset needs to reconcile an update to a record that cannot not be applied.
OnUpdateError	Fires if an exception is generated when updates are applied to a database.
OnUpdateRecord	Occurs when record update is applying to a database.

TADStoredProc Class

Method	Description
AbortJob	Use the AbortJob method to abort current dataset operation.
AddIndex	Creates a new client index for the dataset.
ApplyMaster	Applies a master-detail relation to this detail dataset.
ApplyRange	Applies a range to the dataset.
ApplyUpdates	Applies changes for all records in the dataset change log to the database.
AttachTable	Use the AttachTable to attach the dataset to existing DatS table or view.
AttachTable	Attaches dataset to existing DatS table and optionaly view.
BeginBatch	Optimizes dataset functionality for batch updates.
CancelRange	Cancels range for the dataset.
CancelUpdates	Removes all records from the change log and restores the dataset rows to its prior editing state.
CloneCursor	Shares the data belonging to another dataset.
CommitUpdates	Clears the changes log and marks all records as not modified.
CopyDataSet	Copies records from source dataset to this dataset.
CopyRecord	Copies all record fields from source dataset to the Self dataset.
CreateDataSet	Creates new empty internal data storage for dataset.
CreateExpression	Creates expression evaluator for dataset.
DeleteIndex	Deletes an client index for the dataset.
DeleteIndexes	Deletes all client indexes for the dataset.
DescriptionsAvailable	Determines if parameter information is available from the stored procedure on the server.
DisableConstraints	Disables the enforcement of the client constraints.
Disconnect	Disconnects the dataset from DBMS.
Disconnect	Disconnects the dataset from DBMS.
Disconnect	Use Disconnect method to release DBMS resources, used by this dataset.
EditKey	Enables modification of the search key buffer.
EditRangeEnd	Enables changing the ending value for an existing range.
EditRangeStart	Enables changing the starting value for an existing range.
EmptyDataSet	Removes all records from the dataset internal data storage.
EnableConstraints	Reenables enforcement of the client constraints when records are posted.
EndBatch	Restores normal dataset functionality after batch updates.
ExecFunc	Executes a stored function in the DBMS session and returns its value.
ExecFunc	Executes the specified stored function in the DBMS session and returns its value.
ExecFunc	Executes the specified stored function, assigns parameter values for the stored function arguments and returns its value.
ExecFunc	Executes the specified stored function, assigns parameter data type and values for the stored proc arguments and returns its value.
ExecProc	Executes the specified stored procedure in the DBMS session.
ExecProc	Executes the specified stored procedure in the DBMS session.
ExecProc	Executes the specified stored procedure and assigns parameter values for the stored proc arguments.
ExecProc	Executes the specified stored procedure and assigns parameter data type and values for the stored proc arguments.
Execute	Executes an SQL command.
FetchAgain	Allows to fetch additional records.
FetchAll	Retrieves all records from the current resultset and stores them into internal DatS table.
FetchBlobs	Retrieves BLOB field values from database for current record.
FetchDetails	Retrieves nested datasets from database for current record.
FetchNext	A shortcut to the GetNextPacket method.
FindKey	Searches for a record containing specified index field values.
FindMacro	Returns macro by its name.
FindNearest	Searches for a record containing specified index field values.
FindParam	Finds the parameter in Params property by a given name.
GetColumnField	Returns field corresponding to DatS column.
GetDetailLinkFields	Lists the field objects that link this dataset as a detail of a master dataset.
GetFieldColumn	Returns DatS column corresponding to field.
GetGroupState	Indicates where the current record sits within a specified group of records.
GetIndexNames	Fills the list by client index names.
GetNextPacket	Fetches the next rowset from the DBMS.
GetParentRow	Returns parent row of this nested dataset.
GetResults	Forces DBMS to return the output parameter values.
GetRow	Returns DatS row.
GotoCurrent	Sets the current record in this dataset the same as the current record in another, cloned dataset.
GotoKey	Searches for a record, using values in the key buffer.
GotoNearest	Searches for a closest record, using values in the key buffer.
IsIndexed	Returns True, if dataset has current client index.
IsLinked	Returns True, if dataset is linked to another dataset.
IsRanged	Returns True, whether the dataset records are limited by a range.
LoadFromFile	Loads a dataset's data from a file.
LoadFromFileAtOpen	Returns True, if dataset content will be loaded from file at Open.
LoadFromStream	Loads a dataset's data from a stream.
Locate	Searches the dataset for a record with specified field values and makes it current.
LocateEx	Searches the dataset for a specified record by predicate expression and makes that record current or returns its index.
LocateEx	Searches the dataset for a specified record by its fields values and makes that record current or returns its index.
Lookup	Searches the dataset for a record with specified key field values and returns result field values.
LookupEx	Searches the dataset for a record by predicate expression and returns result field values.
LookupEx	Searches the dataset for a record with specified key field values and returns result field values.
MacroByName	Returns macro by its name.
NextRecordSet	Go to the next cursor, returned by the SQL command.
Offline	Sets dataset to offline mode.
Open	Executes the specified SQL statement and opens dataset.
Open	Executes the specified SQL statement with specified parameter values and opens dataset.
Open	Executes the specified SQL statement with specified parameter values and opens dataset.
OpenOrExecute	Executes SQL command and optionally opens dataset.
ParamByName	Searches parameter by its name.
Prepare	Prepares SQL command for execution.
Reconcile	Clears successfully updated records from the dataset's cache of changes.
RefreshRecord	Rereads field values of the current record from a data source.
RefreshUnknownRecord	Registers new record and optionally rereads it field values from a data source.
Release	Releases all dataset cursors.
RevertRecord	Undoes changes to the current record.
SaveToFile	Saves a dataset's data to a file.
SaveToFileAtClose	Returns True, if dataset content will be saved to file at Close.
SaveToStream	Saves a dataset's data to a stream.
ServerAppend	Used by TADDataMove to edit directly DBMS data.
ServerCancel	Used by TADDataMove to edit directly DBMS data.
ServerDelete	Used by TADDataMove to edit directly DBMS data.
ServerDeleteAll	Deletes all records from an associated database table.
ServerEdit	Used by TADDataMove to edit directly DBMS data.
ServerGotoKey	Used by TADDataMove to edit directly DBMS data.
ServerPerform	Used by TADDataMove to edit directly DBMS data.
ServerSetKey	Used by TADDataMove to edit directly DBMS data.
SetFieldAttributes	Setups fields ProviderFlags.
SetKey	Starts the enter key values mode.
SetRange	Sets the starting and ending values of a range, and applies it.
SetRangeEnd	Sets the ending values of a range.
SetRangeStart	Sets the starting values of a range.
UndoLastChange	Undoes the last modification to the dataset records.
Unprepare	Releases SQL command resources.
UpdateAttributes	Actualize changes to the client default expressions and auto-incremental fields.
UpdateConstraints	Actualize changes to the client constraints.
UpdateStatus	Returns the modification status for current record.

Property	Description
ActiveStoredUsage	Controls how to use Active property value saved to DFM.
Adapter	The reference to a data adapter.
Aggregates	The collection of client side aggregates, defined for dataset.
AggregatesActive	Controls automatic calculation of aggregate values.
CachedUpdates	Specifies whether dataset will log changes to the data without immediate applying of them to the database.
CatalogName	Limits the stored procedure names to the specified catalog.
ChangeCount	Gets the number of changes in the change log.
CloneSource	Gets the dataset (if any) with which this dataset shares data.
Command	The reference to a command, used to execute / open queries.
Connection	Specifies the AnyDAC connection component to use.
ConnectionName	Specifies the AnyDAC connection to use by its name.
Constraints	Specifies record-level client constraints that must be met when editing the data.
ConstraintsEnabled	Specifies whether the dataset perform constraint checking.
Data	Represents the data of the dataset, allowing to copy full data of one dataset into another.
DatSManager	The reference to the inmemory data storage manager.
DatSManager	Returns the reference to the internal data storage manager.
Delta	Represents the changed records of the dataset.
DetailFields	Gets / sets fields in detail dataset, used to establish a master-detail relationship with this dataset.
FetchOptions	The set of options to control rows fetching.
FilterChanges	Specifies what kinds of changed records must be "visible" in the dataset.
FilteredData	Represents the currently "visible" data of the dataset.
FormatOptions	The set of options to control data representation.
GroupingLevel	Returns the depth of grouping support provided by the current index.
IndexDefs	Returns indexes definition for the dataset.
Indexes	Lists all client indexes that apply to the dataset.
IndexesActive	Controls automatic maintenance of Index'es.
IndexFieldCount	Returns the number of fields that make up the current index.
IndexFieldNames	Lists the field names to use as an index.
IndexFields	Returns the fields that make up the current index.
IndexName	Gets / sets the current index for the dataset by its name.
KeyExclusive	Controls the exclusion of upper and lower boundaries for a range.
KeyFieldCount	Controls the number of indexed field values to use for key search or range setup.
LocalSQL	The reference to a Local SQL engine.
MacroCount	Returns the number of macro in Macros collection.
Macros	The collection of macro substitution variables.
MasterFields	Gets / sets fields in master dataset, used to establish a master-detail relationship with this dataset.
MasterLink	Returns data link object servicing connection with master dataset.
MasterSource	Gets / sets a master data source, used to establish a master-detail relationship with this dataset.
Overload	Specifies which Oracle overloaded packaged stored procedure to execute.
PackageName	Limits the stored procedure names to the specified package name.
ParamBindMode	Determines the order in which a component’s parameters are assigned to the parameter list for SQL command on the DBMS.
ParamCount	Returns the number of parameters for the stored procedure.
ParamCount	Returns the current number of parameters in the command text.
Params	Contains the parameters for a SQL statement.
ParentDataSet	Returns the reference to parent dataset, if this one is nested.
PointedConnection	The actual connection object.
Prepared	Gets or sets command prepare for execution status.
ResourceOptions	The set of options to control resources usage.
RowError	Returns an exception object associated with the current dataset record.
RowsAffected	Returns the number of rows operated upon by the latest query execution.
RowsAffected	Returns the number of rows operated upon by the latest query execution.
SavePoint	Gets / sets the change log version number.
SchemaAdapter	Gets or sets a reference to a schema adapter, as a Centralized Cached Updates log.
SchemaName	Limits the stored procedure names to the specified schema.
ServerEditRequest	Used by TADDataMove to edit directly DBMS data.
SourceEOF	Specifies if no more records to fetch from current cursor.
SourceView	The reference to DatS view object, by which rows the dataset is navigating.
StoredProcName	Identifies the name of the stored procedure on the server to call.
Table	The reference to DatS table object, actually representing the internal data storage.
Transaction	Gets / sets reference to transaction object.
UpdateObject	Specifies the update object component used to post updates by dataset.
UpdateOptions	The set of options to control updates posting.
Updates	The dataset change log.
UpdatesPending	Indicates whether the changes log is not empty.
UpdateTransaction	Gets / sets reference to transaction object.
View	The reference to base DatS view object.

Events, TADStoredProc Class, Legend, Methods, Properties