TDAQueryBuilderOption

Overview

Specifies rules that will be used for generation of SQL statement

Location

  • Unit: uDASimpleQueryBuilder.pas
Value Description
qboAlwaysGenerateTableName Adds table name to field name:
<br/>SELECT table.field FROM table<br/>
qboCanRows
qboCanUseLimit
qboCanUseLimitSkip
qboCanUseOffsetSkip
qboCanUseSelectFirst
qboCanUseSelectSkip
qboCanUseSelectTop
qboCanUseSelectTopSkip
qboGenerateDynamicWhereStatement Generates {WHERE} macro
<br/>SELECT table.field FROM table WHERE {WHERE}<br/>
qboGeneratePseudoJoinCondition Adds <join condition> into statement in case join conditional is missing:
<br/>SELECT table1.field, table2.field FROM table1 LEFT OUTER JOIN table2 on (<join condition>)<br/>
qboGenerateSimpleSelect Generates * in select instead of field names:
<br/>SELECT * FROM table<br/>
qboSelectDistinct Generates DISTINCT in select:
<br/>SELECT DISTINCT field FROM table<br/>
qboUseSelectCount Generates COUNT(*) in select:
<br/>SELECT COUNT(*) FROM table<br/>
qboUseSelectSkip Generates SKIP ### in select:
<br/>SELECT SKIP ### field FROM table<br/>