blob: 08745dbc5903d86190df2db6ecf983ae190a87d5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
-->
<meta>
<topic id="textshared02querypropdlgxml" indexer="include">
<title xml-lang="en-US" id="tit">Query Properties Dialog</title>
<filename>/text/shared/02/querypropdlg.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154788"><bookmark_value>queries; set properties</bookmark_value>
</bookmark>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/QueryPropertiesDialog" id="bm_id3143280" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3154780" role="heading" level="1">Query Properties Dialog</paragraph>
<paragraph xml-lang="en-US" id="par_id3152820" role="paragraph">In the <emph>Query Properties</emph> dialog, set properties belong to SQL Query, that you need your current task.</paragraph>
<section id="howtoget">
<paragraph role="paragraph" id="par_id3153761" xml-lang="en-US">In the Query Design View, choose <emph>Edit</emph> - <emph>Query Properties</emph>.
</paragraph>
</section>
<paragraph xml-lang="en-US" id="hd_id3154927" role="heading" level="2">Distinct Values</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/distinct" id="bm_id0305200912070090" localize="false"/>
<paragraph xml-lang="en-US" id="par_id030520091208050" role="paragraph"><ahelp hid="." visibility="hidden">Use distinct values in query.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/nondistinct" id="bm_id0305200912074470" localize="false"/>
<paragraph xml-lang="en-US" id="par_id0305200912080610" role="paragraph"><ahelp hid="." visibility="hidden">Not use distinct values in query.</ahelp></paragraph>
<paragraph xml-lang="en-US" id="par_id3156040" role="paragraph">Expands the created select statement of the SQL Query in the current column by the parameter DISTINCT. The consequence is that identical values occurring multiple times are listed only once.</paragraph>
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/limitbox" id="bm_id3155940" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3151226" role="heading" level="2">Limit</paragraph>
<paragraph xml-lang="en-US" id="par_id3153683" role="paragraph">Adding a Limit to maximize the number of records to return.</paragraph>
</body>
</helpdocument>
|
