RAD Studio VCL Reference
ContentsIndex
TSQLDataSet Members Public Methods
Public Methods
 
Name 
Description 
 
Increments the reference count for this interface. 
 
Decrements the reference count for this interface. 
 
Returns a pointer to the buffer for the active record. 
 
Responds after the last constructor has executed. 
 
Adds a new, empty record to the end of the dataset. 
 
Adds a new, populated record to the end of the dataset and posts it. 
 
Copies the contents of another, similar object. 
 
Performs any necessary actions before the first destructor is called. 
 
Responds before the first destructor executes. 
 
Indicates the validity of a specified bookmark. 
 
Cancels modifications to the active record if those changes are not yet posted. 
 
Automatically posts or cancels data changes when the active record changes. 
 
Returns a pointer to the runtime type information (RTTI) table for the object type. 
 
Returns a string indicating the type of the object instance (as opposed to the type of the variable passed as an argument). 
 
Determines whether an object is of a specific type. 
 
Returns the type of the immediate ancestor of a class. 
 
Returns the class reference for the object's class. 
 
Performs finalization on long strings, variants, and interface variables within a class. 
 
Clears the contents of all fields for the active record. 
 
Closes a dataset. 
 
Implements a virtual function to compare two bookmarks. 
 
Indicates whether data-aware controls update their display to reflect changes to the dataset. 
 
This is CopyFields, a member of class TDataSet. 
 
Creates an instance of a TSQLDataSet component. 
 
This is the overview for the Create constructor overload. 
 
Provides the interface for a method that creates a blob stream for a Binary large object (BLOB) field in the dataset. 
 
Creates a blob stream for a Binary large object (BLOB) field in the dataset. 
 
Marks the internal cursor position as invalid. 
 
Provides the interface for a method that processes message records. 
 
Deletes the active record and positions the dataset on the next record. 
 
Disposes of the component and its owned components. 
 
Destroys the TPersistent instance and frees its memory. 
 
Destroys the TDataSet instance. 
 
Destroys the TCustomSQLDataSet instance. 
 
Disposes of an object instance. 
 
Destroys all owned components. 
 
Indicates that the component and its owned components are about to be destroyed. 
 
Disables data display in data-aware controls associated with the dataset. 
 
Calls message-handling methods for the object, based on the contents of the Message parameter. 
 
Edit 
Enables editing of data in the dataset. 
 
Re-enables data display in data-aware controls associated with the dataset. 
 
Checks if the current instance and the parameter are equal. 
 
Executes a query or stored procedure that does not return a set of records. 
 
Executes an action. 
 
This is the overview for the FieldAddress method overload. 
 
Finds a field based on its name. 
 
Indicates whether a given component is owned by the component. 
 
Searches for a specified field in the dataset. 
 
Implements a virtual method for positioning the dataset on the first record, respecting any filters. 
 
Implements a virtual method for positioning the dataset on the last record, respecting any filters. 
 
Implements a virtual method for positioning the dataset on the next record, respecting any filters. 
 
Implements a virtual method for positioning the dataset on the previous record, respecting any filters. 
 
Moves to the first record in the dataset. 
 
Free 
Destroys an object and frees its associated memory, if necessary. 
 
Frees the resources allocated for a specified bookmark. 
 
Deallocates memory allocated by a previous call to the System::TObject::NewInstance method. 
 
Ensures that AComponent is notified that the component is going to be destroyed. 
 
Frees the interface reference for components that were created from COM classes. 
 
Reads BLOB data into a buffer. 
 
Retrieves the current value of a BLOB field into a buffer. 
 
Allocates a bookmark for the active record in the dataset. 
 
This is GetCommandNames, a member of class TCustomSQLDataSet. 
 
Returns a reference to the component associated by the implementing class. 
 
Implements a virtual function to retrieve the current record in a buffer. 
 
Fills a list with a dataset for every detail dataset that is not the value of a nested dataset field. 
 
Introduces a method to list the field components that link this dataset as a detail of a master dataset. 
 
Lists the field components that link this dataset as a detail of a master dataset. 
 
Returns a TComponent enumerator. 
 
This is the overview for the GetFieldData method overload. 
 
This is the overview for the GetFieldData method overload. 
 
Retrieves a specified set of field objects into a list. 
 
This is the overview for the GetFieldNames method overload. 
 
Returns an integer containing the hash code. 
 
Retrieves a specified interface. 
 
Returns the entry for a specific interface implemented in a class. 
 
Returns a pointer to a structure containing all of the interfaces implemented by a given class. 
 
This is the overview for the GetKeyFieldNames method overload. 
 
Returns a string used by the Object Inspector. 
 
Returns the name of the object as it appears in the Object Inspector. 
 
Returns the containing Component. 
 
Returns the character or characters to use in generated SQL statements to enclose quoted strings. 
 
Implements a virtual method to position the dataset on the record to which a specified bookmark points. 
 
Verifies whether the component has a parent. 
 
Determines the relationship of two object types. 
 
Initializes a newly allocated object instance to all zeros and initializes the instance's virtual method table pointer. 
 
Inserts a new, empty record in the dataset. 
 
Establishes the component as the owner of a specified component. 
 
Inserts a new, populated record to the dataset and posts it. 
 
Returns the size in bytes of each instance of the object type. 
 
Indicates whether the dataset contains no records. 
 
Indicates whether the component implements a specified interface. 
 
Indicates whether a dataset is linked to a specified data source. 
 
Indicates whether the underlying database table uses record numbers to indicate the order of records. 
 
Indicates whether the dataset can use record numbers to indicate the order of records. 
 
Last 
Moves to the last record in the dataset. 
 
Implements a virtual method for searching a dataset for a specified record and making it the active record. 
 
Implements a virtual method for searching a dataset for a specified record and making it the active record. 
 
Implements a virtual method to retrieve field values from a record that matches specified search values. 
 
Implements a virtual method to retrieve field values from a record that matches specified search values. 
 
This is the overview for the MethodAddress method overload. 
 
Returns the name of a class method by address. 
 
Moves to another record relative to the active record in the dataset. 
 
Allocates memory for an instance of an object type and returns a pointer to that new instance. 
 
Next 
Moves to the next record in the dataset. 
 
Open 
Opens the dataset. 
 
Locates a parameter in the Params property collection. 
 
Post 
Implements a virtual method to write a modified record to the database or change log. 
 
Performs a prepare on the SQL statement. 
 
Moves to the previous record in the dataset. 
 
Ends a transaction that was started by a call to PSStartTransaction
 
Ends a transaction that was started by a call to PSStartTransaction
 
Executes the SQL command associated with the dataset. 
 
Executes the SQL command associated with the dataset. 
 
Executes a specified SQL command. 
 
Executes a specified SQL command. 
 
Returns information that is stored in data packets as Name/Value pairs. 
 
Returns information that is stored in data packets as Name/Value pairs. 
 
Gets the SQL command to be executed by PSExecute
 
Gets the SQL command to be executed by PSExecute
 
Gets the command type to be executed by PSExecute
 
Gets the command type to be executed by PSExecute
 
Returns the definition of an index that imposes the default order on the data included in data packets. 
 
Returns the definition of an index that imposes the default order on the data included in data packets. 
 
Returns the definitions of all specified indexes defined for the dataset. 
 
Returns the definitions of all specified indexes defined for the dataset. 
 
Returns the names of all fields required to uniquely identify records in the data packet. 
 
Returns the names of all fields required to uniquely identify records in the data packet. 
 
Returns the current parameter values of the dataset. 
 
Returns the current parameter values of the dataset. 
 
Returns the character or characters to use in generated SQL statements to enclose quoted strings. 
 
Returns the character or characters to use in generated SQL statements to enclose quoted strings. 
 
Returns the name of the dataset table that appears in generated SQL statements. 
 
Returns the name of the dataset table that appears in generated SQL statements. 
 
Generates an EUpdateError object based on another exception object. 
 
Generates an EUpdateError object based on another exception object. 
 
Indicates whether actions against the dataset occur in the context of a transaction. 
 
Indicates whether actions against the dataset occur in the context of a transaction. 
 
Indicates whether the dataset includes native SQL support. 
 
Indicates whether the dataset includes native SQL support. 
 
Indicates whether the dataset can execute SQL statements. 
 
Indicates whether the dataset can execute SQL statements. 
 
Resets the dataset so that it is positioned on the first record. 
 
Resets the dataset so that it is positioned on the first record. 
 
Assigns a specified SQL command to be executed by PSExecute
 
Assigns a specified SQL command to be executed by PSExecute
 
Assigns the specified parameter values to the dataset. 
 
Assigns the specified parameter values to the dataset. 
 
Starts a transaction that encapsulates all activity until a call to PSEndTransaction
 
Starts a transaction that encapsulates all activity until a call to PSEndTransaction
 
Applies a single update to the underlying database table or tables. 
 
Applies a single update to the underlying database table or tables. 
 
Returns a reference to a specified interface if the object supports that interface. 
 
Establishes or removes internal links that cause this component to be notified when the implementer of a specified interface is destroyed. 
 
Re-fetches data from the database to update a dataset's view of data. 
 
Removes a specified component specified from the component's Components list. 
 
Disables destruction notification that was enabled by FreeNotification 
 
Re-fetches the active record and the records that precede and follow it. 
 
Handles exceptions in methods declared using the safecall calling convention. 
 
Handles exceptions in methods declared using the safecall calling convention. 
 
Sets the values for all fields in a record 
 
Indicates whether the dataset represents metadata from the server, and if so, what kind. 
 
Identifies whether the component is a subcomponent. 
 
Returns a string containing the class name. 
 
Implements a virtual procedure to copy a data string from a source to a destination, optionally performing character translation during the copy. 
 
Returns a string containing the unit name. 
 
Updates the state of an action. 
 
Positions the cursor on the active record. 
 
Ensures that data-aware controls and detail datasets reflect record updates. 
 
Reports the update status for the active record. 
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.