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 <nowiki>{{WHERE}}</nowiki><br />
qboGeneratePseudoJoinCondition Adds 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 />