📄 asqlitequery.htm
字号:
<html>
<head>
<title>No title</title>
<meta name="author" content="Albert Drent">
<meta name="generator" content="Namo WebEditor">
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<table border="1" cellspacing="0" bordercolordark="white" bordercolorlight="black" width="746">
<tr>
<td width="195" align="left" valign="top" rowspan="24">
<p><img src="img3.gif" border="0"></p>
</td>
<td width="541" colspan="2"><font color="blue">blue</font> properties are only available in TASGSQLite3 components, not in the TASGSQLite components.</td>
</tr>
<tr>
<td width="126">Active</td>
<td width="411"><font face="Arial"><span style="font-size:9pt;">Set to true to open the table. Same effect can be achieved by the method 'Open'</span></font></td>
</tr>
<tr>
<td width="126">AutoCalcFields</td>
<td width="411">Set to true for automatic calculation of fields. See Borland documentation.</td>
</tr>
<tr>
<td width="126">Autocommit</td>
<td width="411">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. </td>
</tr>
<tr>
<td width="126"><span style="font-size:9pt;"><font face="Arial" color="red">Connection</font></span></td>
<td width="411">Connector for the TASQLite3DB component</td>
</tr>
<tr>
<td width="126">Filter</td>
<td width="411">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.</td>
</tr>
<tr>
<td width="126">Filtered</td>
<td width="411"><font face="Arial"><span style="font-size:9pt;">If set, then the Filter property will be used, otherwise ignored</span></font></td>
</tr>
<tr>
<td width="126">Master fields</td>
<td width="411">Contains refrences to the master fields used for a master-detail relationship</td>
</tr>
<tr>
<td width="126"><font color="red">Mastersource</font></td>
<td width="411">Connector for a TDatasource component, needed to setup a master-detail relationship</td>
</tr>
<tr>
<td width="126">MaxResult</td>
<td width="411">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.</td>
</tr>
<tr>
<td width="126">Name</td>
<td width="411">Name of the component</td>
</tr>
<tr>
<td width="126">RawSQL</td>
<td width="411">If set, the SQL statement will not be prepared and parsed, but sent to SQlite directly</td>
</tr>
<tr>
<td width="126"><font color="blue">ReadOnly</font></td>
<td width="411">If set, inserts, updates and deletes will generate an exception. (It will generate this only at post time)</td>
</tr>
<tr>
<td width="126">SQL</td>
<td width="411">Contains sql statement to be executed</td>
</tr>
<tr>
<td width="126"><font color="blue">SQLCursor</font></td>
<td width="411">If set, an SQL cursor will appear on database access.</td>
</tr>
<tr>
<td width="126">SQLiteDateFormat</td>
<td width="411">
<p>If set, datetime values will be stored in the standardformat <b> yyyy-mm-dd hh:nn:ss.zzz </b>This format is independent to locale settings.</p>
</td>
</tr>
<tr>
<td width="126">StartResult</td>
<td width="411">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 <i>limit x,y</i> sql clause)</td>
</tr>
<tr>
<td width="126">TableDateFormat</td>
<td width="411">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.</td>
</tr>
<tr>
<td width="126">Tablename</td>
<td width="411">Name of the table to use. (Dropdown box will reveil all tables within the database)</td>
</tr>
<tr>
<td width="126"><font face="Arial"><span style="font-size:9pt;">Tag</span></font></td>
<td width="411"><font face="Arial"><span style="font-size:9pt;">Tag (see Borland documentation)</span></font></td>
</tr>
<tr>
<td width="126"><span style="font-size:9pt;"><font face="Arial" color="blue">TransactionType</font></span></td>
<td width="411"><font face="Arial"><span style="font-size:9pt;">Can be set to blank (= default), default, deferred, immediate and exclusive). For usage see the sqlite documentation on </span></font><span style="font-size:9pt;"><a href="http://www.sqlite.org."><font face="Arial">www.sqlite.org.</font></a></span><font face="Arial"><span style="font-size:9pt;"> This value is used when using transactions without declaring it's type.</span></font></td>
</tr>
<tr>
<td width="126">TypeLess</td>
<td width="411"><font face="Arial"><span style="font-size:9pt;">If set typecasting of the fields is disabled. No conversion between the database field and Delphi will be performed.</span></font></td>
</tr>
<tr>
<td width="126">UniDirectional</td>
<td width="411">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.</td>
</tr>
<tr>
<td width="126"><font color="red">UpdateSQL</font></td>
<td width="411">Placeholder for a TASQLiteUpdateSQL component. This is needed if you want to maintain a 'live' resultset. </td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -