| QueryMacros Properties |
The QueryMacros type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | Columns |
List of columns to select
|
| DefaultSource |
Default query source
|
| Distinct |
If set to true, returns only distinct (different) values.
|
| GroupBy |
List of columns to group by
|
| Having |
Where condition for the GroupBy clause
|
| OrderBy |
Order by
|
| Output |
Output from non query statement. Allows to return data from inserted and deleted rows.
|
| Source |
Query source
|
| TopN |
Top N records
|
| Total |
Total items expression
|
| Values |
List of values for the update / insert query
|
| Where |
Where condition
|
See Also