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 <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/> |