41 lines
2.8 KiB
XML
41 lines
2.8 KiB
XML
<?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"/>
|
|
<bookmark xml-lang="en-US" branch="hid/.uno:DBQueryPropertiesDialog" id="bm_id3143281" localize="false"/>
|
|
<h1 id="hd_id3154780">Query Properties Dialog</h1>
|
|
<paragraph xml-lang="en-US" id="par_id3152820" role="paragraph"><ahelp hid=".">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.</ahelp></paragraph>
|
|
<section id="howtoget">
|
|
<paragraph role="paragraph" id="par_id3153761" xml-lang="en-US">In the Query Design View, choose <emph>Edit - Query Properties</emph>.
|
|
</paragraph>
|
|
</section>
|
|
<h2 id="hd_id3154927">Distinct Values</h2>
|
|
<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"/>
|
|
<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/___object_1___" id="bm_id3155941" localize="false"/>
|
|
<h2 id="hd_id3151226">Limit</h2>
|
|
<paragraph xml-lang="en-US" id="par_id3153683" role="paragraph"><ahelp hid=".">Adds a Limit to set the maximum number of records to return.</ahelp></paragraph>
|
|
</body>
|
|
</helpdocument>
|