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 <r...@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 <zolnaitamas2...@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>
_______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-commits