summaryrefslogtreecommitdiffstats
path: root/helpcontent2/source/text/shared/02/querypropdlg.xhp
diff options
context:
space:
mode:
Diffstat (limited to 'helpcontent2/source/text/shared/02/querypropdlg.xhp')
-rw-r--r--helpcontent2/source/text/shared/02/querypropdlg.xhp41
1 files changed, 41 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/02/querypropdlg.xhp b/helpcontent2/source/text/shared/02/querypropdlg.xhp
new file mode 100644
index 000000000..fd87ca7ee
--- /dev/null
+++ b/helpcontent2/source/text/shared/02/querypropdlg.xhp
@@ -0,0 +1,41 @@
+<?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"/>
+<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"><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>
+ <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"/>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/querypropertiesdialog/___object_1___" id="bm_id3155941" 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"><ahelp hid=".">Adds a Limit to set the maximum number of records to return.</ahelp></paragraph>
+ </body>
+</helpdocument>