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

1.SQL related

Name	Type	Description
Basesql	String	Raw SQL statements that have not been processed by Addwhere, Setorderby, Filtersql, etc.
Finalsql	String	Final SQL statements processed by Addwhere, Setorderby, Filtersql, etc.
Savesql		Saves the value in the SQL property to Basesql so that it can be restored after processing
Restoresql		Restore statements from Basesql to SQL properties
Sqlsaved	Boolean	Whether SQL is saved to Basesql
Sql	TStrings
Filtersql		Filter conditions added to the Where condition
Addwhere		Add a Where condition
deletewhere	 	remove the Where condition
conditions	tdaconditions	Span style= "FONT-SIZE:14PX;" > is used to increase the where condition into SQL, which is a collection object, so its greatest feature is the ability to enable different conditions depending on the circumstances without having to re-set the condition content. unitable1.conditions.add (' 2 ', ' sal>2500 '); unitable1.conditions.enable; unitable1.open; select * from EMP where (job= "MANAGER") and (sal<2500)
Sqldelete Sqlinsert Sqlupdate	TStrings	Delete, insert, and update SQL, the parameter must be a field name plus a colon, such as: :D Ep_no For updates, deletions, you need to use the field's original data values as parameters, you need to use old_ to identify, such as: : Old_dep_no
Sqlrefresh	TStrings	SQL used when calling the Refreshrecord method to refresh the contents of the current record requires the same
Sqllock		SQL statement used to form record lock
Sqlreccount		When DataSet properties: Fetchall=false Options.queryreccount=true SQL statement to get the number of datasets when opening a dataset
Macrocount	Integer	The number of macros
Macros	Tmacros	Odac added the use of the & macro variable name as an alternative parameter in SQL
Getorderby		Get the order by content in SQL
Setorderby		Set order by content in SQL

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