Please see TMySQLQuery properties short descriptions below:
Derived from TDataSet
Specifies whether or not a dataset is open.
Determines when the OnCalcFields event is triggered.
Indicates whether or not a cursor is positioned at the first record in a dataset.
Specifies the current bookmark in the dataset.
Does not affect on dataset behavior.
Indicates whether a dataset's underlying field components are generated dynamically when the dataset is opened.
Indicates whether or not a cursor is positioned at the last record in a dataset.
Indicates the number of field components associated with the dataset.
Points to the list of field definitions for the dataset.
Lists the field components of a dataset.
Lists all non-aggregate field components of the dataset.
Provides access to the values for all fields in the active record for the dataset.
Indicates whether or not moving to a different record is successful.
Indicates whether the active record is modified.
Designates the name of the dataset as referenced by other components.
Specifies whether fields are to be stored hierarchically or flattened out in the Fields property.
Determines whether a unique TField object is created for each element of an array field.
Indicates the current operating mode of the dataset.
Derived from TMySQLDataSet
Determines that database records can be located by sequence numbers.
Specifies whether server-generated field values are refetched automatically.
Indicates count of resultsets available to fetch from multiresultset query or stored procedure. This property is useful when query or stored procedure returns more than one dataset.
Determines how many record buffers are read in each block.
Determines whether BLOB fields are cached in memory.
Specifies the database component for which this dataset represents one or more tables.
Specifies the text of the current filter for a dataset.
Specifies whether filtering is active for a dataset.
Specifies whether filtering is case insensitive, and whether or not partial comparisons are permitted when filtering records.
Specifies the size of the key for the current index of the dataset.
Get last inserted value of AUTO_INCREMENT column from MySQL server.
Specifies the resultset to associate with component when it become active. This property is useful when query or stored procedure returns more than one dataset.
Indicates the current record in the dataset.
Indicates the total number of records associated with the dataset.
Indicates the size of a record in the dataset.
Specifies field names and sorting order to sort opened dataset by these fields on the client side without refetching data from server.
Determines how MySQL finds records when updating to an SQL database.
Specifies the update object component used to update a read-only result set.
In TMySQLQuery
Specifies the data source component from which to extract current field values to use with same-name parameters in the query SQL statement.
Specifies the cursor handle for the query.
Specifies whether the parameter list for a query is regenerated if the SQL property changes at runtime.
Indicates the current number of parameters for the query.
Contains the parameters for a query SQL statement.
Determines whether or not a query is prepared for execution.
Allows to choose what kind of comments to cut from SQL query text before sending it to server.
Specifies whether an application expects to receive a live result set when the query executes.
Returns the number of rows operated upon by the latest query execution.
Contains the text of the SQL statement to execute for the query.
Points to the binary data stream that represents an SQL query statement or result set.
Points to the actual text of the SQL query passed to MySQL.
Determines whether or not bidirectional cursors are enabled for a query's result set.