|
blue properties are only available in TASGSQLite3 for SQLite3 components, not in the TASGSQLite for SQLite2 components. | |
Active | Set to true to open the table. Same effect can be achieved by the method 'Open' | |
AutoCalcFields | Set to true for automatic calculation of fields. See Borland documentation. | |
Autocommit | Set to true if you want to autocommit your changes. The transaction type used depends on the declaration in the appropiate property. If not set the transactiontype of the connection will be used. | |
Connection | Connector for the TASQLite3DB component | |
Filter | Placeholder for a filter. You can enter any valid argument here including 'group by', 'having' and 'order'. It will be appended to the generated sql. | |
Filtered | If set, then the Filter property will be used, otherwise ignored | |
Master fields | Contains refrences to the master fields used for a master-detail relationship | |
Mastersource | Connector for a TDatasource component, needed to setup a master-detail relationship | |
MaxResult | Limits count of resultset to the number of records entered here. Keep 0 to retrieve full resultset (which might consume a lot of time and memory on large resultsets since these will be stored within a in-memory table. | |
Name | Name of the component | |
PrimaryAutoInc | If set, and the table has been created with 'integer primary key' then inserting a record will automatically generate a unique key. | |
ReadOnly | If set, inserts, updates and deletes will generate an exception. (It will generate this only at post time) | |
SQLCursor | If set, an SQL cursor will appear on database access. | |
SQLiteDateFormat |
If set, datetime values will be stored in the standardformat yyyy-mm-dd hh:nn:ss.zzz This format is independent to locale settings. |
|
StartResult | If not 0 this is the first row of the resultset to be returned. I.e. if StartResult=100 and Maxresult=10 then records 100 t/m 110 will be returned (it will generate the limit x,y sql clause) | |
TableDateFormat | Needed for backward compatibility. If date values in the database are stored in a locale way then entering a format here will make the values readable. If you want to update the table with the same dateformat you need to set the shortdateformat and dateseparator global variables in your application too. | |
Tablename | Name of the table to use. (Dropdown box will reveil all tables within the database) | |
Tag | Tag (see Borland documentation) | |
TransactionType | Can be set to blank (= default), default, deferred, immediate and exclusive). For usage see the sqlite documentation on www.sqlite.org. This value is used when using transactions without declaring it's type. | |
UniDirectional | Create a unidirectonal resultset. This will prevent the creation of an internal storage of the resultset. It's very useful for large resultsets without the need for DBGrids. | |
TypeLess | If set typecasting of the fields is disabled. No conversion between the database field and Delphi will be performed. |