|
Properties TASQLiteQuery
|
|
property Active
|
Set property to 'true' to open the query.
You can also use the method 'open'.
|
|
property Autocommit
|
If set to true then every sql statement
is automatically surrounded by a transaction.
If you want more statements within one transaction
you should set this property to 'false'
and use the methods 'StartTransaction' and
'Commit' or 'RollBack' from the TASQLDatabase
component.
|
|
property Connection
|
TASQLiteDatabase component
|
|
property Filter
|
Property is used to create a subselection
on the selected table. In fact, this entry
will by appended to the 'where' clause of the query.
This field is also used if a master-detail
relation is defined.
|
|
property Filtered
|
Enables filtering.
|
|
property Masterfields
|
Brings up a dialog for entering master-detail
relationship
|
|
property Mastersource
|
Master TDatasource
|
|
property MaxResults
|
Maximum number of rows to return after
a 'select from'
|
|
property Name
|
Name of the component (standard Delphi)
|
|
property RawSQL
|
Setting this property to 'true' will
suppress the parsing of the sql statement.
It is useful if you do not want to use parameter queries
and supply full sql. It will increase speed
and allows you to enter data which contains
characters which are normally being parsed
(like : and ?)
|
|
property SQL
|
StringList property to enter SQL statements
|
|
property StartResult
|
Number of first row to return after a
'select from'
|
|
property Tag
|
Standard Delphi
|
|
property Typeless
|
Set this property to 'true' to use the
standard functionality of SQLite. This database
is typeless, so you can enter alphanumeric
data in numeric fields. However, if you
want to have the types checked set this
property to 'false' and the data will have
to be of the correct type.
|
|
property UpdateSQL
|
Placeholder for TASQLiteUpdateSQL component.
|
|
events
|
All standard TQuery events of Delphi
are supported:
property BeforeOpen; property
AfterOpen; property
BeforeClose; property
AfterClose; property
BeforeInsert; property
AfterInsert; property
BeforeEdit; property
AfterEdit; property
BeforePost; propertyAfterPost; property
BeforeCancel; property
AfterCancel; property
BeforeDelete; property
AfterDelete; property
BeforeScroll; property
AfterScroll; property
BeforeRefresh; property
AfterRefresh; property
OnCalcFields; property
OnDeleteError; property
OnEditError; property
OnNewRecord; property
OnPostError;
|
|
Methods
|
|
ExecSQL
|
Used to execute a query where you do
not need a cursor
|
