Properties TASQLiteUpdateSQL
this component is needed if you want to use a TASQLiteQuery component and you want to have a 'live' resultset. With TASQLiteUpdateSQL and TASQLiteQuery you can create a working DBGrid with update facility. (Of course you can achieve this too with the TASQLiteTable component). Major difference: TASQLiteTable works with the internal recordnumber, where TASQLiteQuery is working on the keyfields.

property DeleteSQL

SQL statement to delete a record in the form:
delete from <tableid> where <mykey>=:mykey

property InsertSQL

SQL statement to insert a record in the form:
insert into <tableid> * or
insert into <tableid> (a,b,c) values * or
insert into <tableid> (a,b,c) values (:a, :b, :c)
See source for more details about this

property  UpdateSQL

SQL statement for update a record in the form
update <tableid> set * or
update <tableid> set a=:a, b=:b where <mykey>=:key
See source for more details about this

property Name

Name of component (standard Delphi)

property  Tag

Standard Delphi