ODAC (V9.5.15) study notes (iv) Tcustomdadataset (2)

2. Connection related

name
connection	style= "FONT-SIZE:14PX;" > 	point to a database connection object
	 

3. Data acquisition

Name	Type	Description
Fetchrows	Integer	Gets the number of entries for a one-time fetch of data records from the database server, with the default of 25.
Isquery	Boolean	When the dataset is prepare, determine if SQL is a SELECT statement and can return data
Refreshrecord		Retrieves the current record value from the database and refreshes the content display, using SQL determined by the Sqlrefresh property
Refreshoptions	Trefreshoptions	The option to refresh the record being edited, including: Roafterinsert Flush when inserting Roafterupdate Refresh when editing Robeforeedit Refresh before editing The default is []
Paramcheck		Checking and automatically generating parameter lists with SQL
ParamCount	Integer	Number of parameters
Params		Parameter collection
Datatypemap	Tdamaprules	Managing mappings between different data types and field types when datasets are turned on
Unidirectional	Boolean	In general, the cursor of a dataset is bidirectional, and when set to true, the cursor becomes one-way so that less memory is consumed
Createblobstream		Constructs a memory stream object to operate on the BLOB field data, which directly affects the field value, reading and writing to the data stream
Fetched	Boolean	Check whether the dataset has taken all records
Fetching	Boolean	Checks whether the dataset is in the process of acquiring data
Fetchingall		Command data set get all records
Beforefetch		Get the event triggered before and after the data
Afterfetch

ODAC (V9.5.15) study notes (iv) Tcustomdadataset (2)