[Libreoffice-commits] help.git: 2 commits - AllLangHelp_shared.mk source/text
Zolnai Tamás
root at linux-dre0.site
Mon Mar 4 11:19:49 PST 2013
AllLangHelp_shared.mk | 2 +
source/text/shared/02/limit.xhp | 26 ++++++++++++++
source/text/shared/02/querypropdlg.xhp | 39 ++++++++++++++++++++++
source/text/shared/explorer/database/02010100.xhp | 3 +
4 files changed, 70 insertions(+)
New commits:
commit 80057f99f605bb833eaa93a6cfc21b593a302783
Author: Zolnai Tamás <root at linux-dre0.site>
Date: Sun Mar 3 00:47:05 2013 +0100
Add help for Limit
Change-Id: I15ae938b8e07298191246231b00efae0c1315a74
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index 86043e5..d30624b 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -493,6 +493,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
helpcontent2/source/text/shared/02/colortoolbar \
helpcontent2/source/text/shared/02/flowcharts \
helpcontent2/source/text/shared/02/fontwork \
+ helpcontent2/source/text/shared/02/limit \
helpcontent2/source/text/shared/02/more_controls \
helpcontent2/source/text/shared/02/paintbrush \
helpcontent2/source/text/shared/02/querypropdlg \
diff --git a/source/text/shared/02/limit.xhp b/source/text/shared/02/limit.xhp
new file mode 100644
index 0000000..297c0eb
--- /dev/null
+++ b/source/text/shared/02/limit.xhp
@@ -0,0 +1,26 @@
+<?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="textshared02limitxml" indexer="include">
+ <title id="tit" xml-lang="en-US">Limit</title>
+ <filename>/text/shared/02/limit.xhp</filename>
+ </topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149991"><bookmark_value>SQL; LIMIT clause</bookmark_value>
+</bookmark>
+<paragraph role="heading" id="hd_id3149991" xml-lang="en-US" level="1">Limit</paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:DBLimit" id="bm_id3147588" localize="false"/>
+<paragraph role="paragraph" id="par_id3154894" xml-lang="en-US"><ahelp hid=".">Expands the created select statement of the <link href="text/shared/explorer/database/02010100.xhp" name="SQL Query">SQL Query</link> by the LIMIT X clause</ahelp>. This can be used to limit your SQL Query results to those that fall within the the first X number of it.</paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/shared/explorer/database/02010100.xhp b/source/text/shared/explorer/database/02010100.xhp
index fb3990f..2a832d1 100644
--- a/source/text/shared/explorer/database/02010100.xhp
+++ b/source/text/shared/explorer/database/02010100.xhp
@@ -313,6 +313,9 @@
<paragraph role="paragraph" id="par_id3150436" xml-lang="en-US" l10n="U" oldref="159">For example, if the name "Smith" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name "Smith" will occur only once.</paragraph>
<paragraph role="paragraph" id="par_id3152352" xml-lang="en-US" l10n="U" oldref="160">For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have "Smith in Chicago" once in your address book and "Smith in London" twice. With the<emph> Distinct Values</emph> command, the query will use the two fields "last name" and "city" and return the query result "Smith in Chicago" once and "Smith in London" once.</paragraph>
<paragraph role="paragraph" id="par_id3149825" xml-lang="en-US" l10n="U" oldref="161">In SQL, this command corresponds to the DISTINCT predicate.</paragraph>
+<paragraph role="heading" id="hd_id3153290" xml-lang="en-US" level="3">Limit</paragraph>
+<paragraph role="paragraph" id="par_id3147501" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Allows you to maximize the number of records with which query returns.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3152350" xml-lang="en-US">If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria.</paragraph>
<paragraph role="heading" id="hd_id3148926" xml-lang="en-US" level="3" l10n="U" oldref="37">Formulating filter conditions</paragraph>
<section id="abfragekriterien">
<paragraph role="paragraph" id="par_id3153162" xml-lang="en-US" l10n="U" oldref="38">When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:</paragraph>
commit 8274992b1f66d9fb5766afd9fc427038f64de5e0
Author: Zolnai Tamás <zolnaitamas2000 at gmail.com>
Date: Fri Mar 1 22:51:00 2013 +0100
Add help for Query Properties Dialog
Change-Id: I063c669c9b101214ac9b205aa40489a65facb858
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk
index 99b9555..86043e5 100644
--- a/AllLangHelp_shared.mk
+++ b/AllLangHelp_shared.mk
@@ -495,6 +495,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\
helpcontent2/source/text/shared/02/fontwork \
helpcontent2/source/text/shared/02/more_controls \
helpcontent2/source/text/shared/02/paintbrush \
+ helpcontent2/source/text/shared/02/querypropdlg \
helpcontent2/source/text/shared/02/stars \
helpcontent2/source/text/shared/02/symbolshapes \
helpcontent2/source/text/shared/04/01010000 \
diff --git a/source/text/shared/02/querypropdlg.xhp b/source/text/shared/02/querypropdlg.xhp
new file mode 100644
index 0000000..08745db
--- /dev/null
+++ b/source/text/shared/02/querypropdlg.xhp
@@ -0,0 +1,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>
More information about the Libreoffice-commits
mailing list