Properties TASQLiteTable

property  Active

Set property to 'true' to open the table. You can also use the method 'open'.

property  Autocommit

If set to true then every sql statement (generated automatically) 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 is the 'where' clause of the query 'select * from <tablename> where <filter>

property Filtered

Enable/disable filter. Set to 'true' to enable filtering.

property  Masterfields

Will bring up dialog to enter master-detail field 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 PrimaryAutoInc

Only functional if your table has a 'index primary key' field. If this is the case and this property is set to true then the primary key will be filled with the first higher value of the primary index. (Like select max(primarykey) from table + 1. Otherwise this setting is ignored.

property StartResult

Number of first row to return after a 'select from'

property TableName

Pulldown for all available tablenames

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.

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