diff options
| author | Zolnai Tamás <root@linux-dre0.site> | 2013-03-03 00:47:05 +0100 |
|---|---|---|
| committer | Zolnai Tamás <zolnaitamas2000@gmail.com> | 2013-03-04 17:12:40 +0100 |
| commit | 80057f99f605bb833eaa93a6cfc21b593a302783 (patch) | |
| tree | 193b9c1859fcdde5b3a2165cf150d2d26338e1e1 | |
| parent | 8274992b1f66d9fb5766afd9fc427038f64de5e0 (diff) | |
Add help for Limit
Change-Id: I15ae938b8e07298191246231b00efae0c1315a74
| -rw-r--r-- | AllLangHelp_shared.mk | 1 | ||||
| -rw-r--r-- | source/text/shared/02/limit.xhp | 26 | ||||
| -rw-r--r-- | source/text/shared/explorer/database/02010100.xhp | 3 |
3 files changed, 30 insertions, 0 deletions
diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index 86043e5ee5..d30624b900 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 0000000000..297c0ebc0f --- /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 fb3990f639..2a832d17ae 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> |