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	QueryBuilder can use SELECT ROWS x' andSELECT ROWS x TO y'
qboCanUseLimit	QueryBuilder can use LIMIT x
qboCanUseLimitSkip	QueryBuilder can use `LIMIT x OFFSET y'
qboCanUseOffsetSkip	QueryBuilder can use `OFFSET x'
qboCanUseSelectFirst	QueryBuilder can use `SELECT FIRST x'
qboCanUseSelectSkip	QueryBuilder can use `SELECT SKIP x'
qboCanUseSelectTop	QueryBuilder can use `SELECT TOP x'
qboCanUseSelectTopSkip	QueryBuilder can use `SELECT TOP x, y'
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/>