<?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 you can set two properties of the SQL Query, i.e. whether to return distinct values, and whether to limit the result set.</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">Adds a Limit to set the maximum number of records to return.</paragraph>
</body>
</helpdocument>