diff options
Diffstat (limited to 'source/zh-CN/helpcontent2/source/text/shared/explorer/database.po')
| -rw-r--r-- | source/zh-CN/helpcontent2/source/text/shared/explorer/database.po | 3135 |
1 files changed, 3120 insertions, 15 deletions
diff --git a/source/zh-CN/helpcontent2/source/text/shared/explorer/database.po b/source/zh-CN/helpcontent2/source/text/shared/explorer/database.po index b874b9246c8..6c3f399a20a 100644 --- a/source/zh-CN/helpcontent2/source/text/shared/explorer/database.po +++ b/source/zh-CN/helpcontent2/source/text/shared/explorer/database.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2020-09-28 11:22+0200\n" +"POT-Creation-Date: 2020-10-23 13:36+0200\n" "PO-Revision-Date: 2019-07-10 01:38+0000\n" "Last-Translator: Dian LI <xslidian@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -16,6 +16,2760 @@ msgstr "" "X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1562722697.000000\n" +#. ugSgG +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"tit\n" +"help.text" +msgid "Queries" +msgstr "" + +#. nuBLG +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"bm_id3150445\n" +"help.text" +msgid "<bookmark_value>queries;overview (Base)</bookmark_value><bookmark_value>tables in databases; printing queries (Base)</bookmark_value><bookmark_value>printing; queries (Base)</bookmark_value><bookmark_value>queries; printing (Base)</bookmark_value>" +msgstr "<bookmark_value>查询; 概述 (Base)</bookmark_value><bookmark_value>数据库中的表格; 打印查询 (Base)</bookmark_value><bookmark_value>打印; 查询 (Base)</bookmark_value><bookmark_value>查询; 打印 (Base)</bookmark_value>" + +#. ABqD3 +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3150445\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02000000.xhp\" name=\"Queries\">Queries</link>" +msgstr "<link href=\"text/shared/explorer/database/02000000.xhp\" name=\"查询\">查询</link>" + +#. KaF9w +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3150499\n" +"help.text" +msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields." +msgstr "「查询」是表格的一种特殊视图。查询可以显示选中的记录或记录中选中的字段，也可以对记录排序。一个查询可以应用至一个表格，如果多个表格通过公用数据字段链接，也可应用至多个表格。" + +#. FG8C9 +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3147399\n" +"help.text" +msgid "Use queries to find records from data tables based on certain criteria. All queries created for a database are listed under the <emph>Queries</emph> entry. Since this entry contains the database queries, it is also called the \"query container\"." +msgstr "查询的用途是根据确定的条件从数据表中查找记录。针对一个数据库创建的所有查询，将在「<emph>查询</emph>」条目下被列出。因为该条目包含数据库的查询，人们也把它称作「查询包」。" + +#. AuJW3 +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3153750\n" +"help.text" +msgid "Printing Queries" +msgstr "打印查询" + +#. BVVMe +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3149183\n" +"help.text" +msgid "To print a query or table:" +msgstr "要打印查询或表格:" + +#. zDMbu +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3156426\n" +"help.text" +msgid "Open a text document (or a spreadsheet document if you prefer the specific printing functions of this type of document)." +msgstr "请打开一个文本文档 (或一个电子表格文档，如果您偏爱此种文档的特殊打印功能)。" + +#. KFWTE +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3149827\n" +"help.text" +msgid "Open the database file and click the Table icon if you want to print a table, or click the Query icon if you want to print a query." +msgstr "打开数据库文件，如果要打印表格，请点击「表格」图标，如果要打印查询，请点击「查询」图标。" + +#. 9ZPFm +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3149398\n" +"help.text" +msgid "Drag the name of the table or query into the open text document or spreadsheet. The dialog <link href=\"text/shared/02/12070000.xhp\" name=\"Insert Database Columns\">Insert Database Columns</link> opens." +msgstr "将表格或查询的名称拖到打开的文本文档或电子表格中。将打开对话框<link href=\"text/shared/02/12070000.xhp\" name=\"插入数据库列\">插入数据库列</link>。" + +#. m5TnG +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3150443\n" +"help.text" +msgid "Decide which columns = data fields you want to include. You can also click the <emph>AutoFormat</emph> button and select a corresponding formatting type. Close the dialog." +msgstr "确定要包括哪些列 (即数据字段)。也可点击「<emph>自动套用格式</emph>」按钮并选择相应的格式类型。关闭对话框。" + +#. AAQ4y +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3153561\n" +"help.text" +msgid "The query or table will be inserted into your document." +msgstr "查询或表格将被插入到文档中。" + +#. XDLzM +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3150503\n" +"help.text" +msgid "Print the document by choosing <emph>File - Print</emph>." +msgstr "选择「<emph>文件 - 打印</emph>」打印文档。" + +#. Kh9NG +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3153146\n" +"help.text" +msgid "You can also open the data source view (Ctrl+Shift+F4), select the entire database table in the data source view (click on the top left corner of the table), and then drag the selection to a text document or spreadsheet." +msgstr "您也可以打开数据源视图 (Ctrl+Shift+F4)，选择数据源视图中的整个数据库表格 (点击表格左上角)，然后将其拖到一个文本文档或电子表格中。" + +#. PJjKX +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3148946\n" +"help.text" +msgid "<link href=\"text/shared/main0212.xhp\" name=\"Sorting and Filtering Data\">Sorting and Filtering Data</link>" +msgstr "<link href=\"text/shared/main0212.xhp\" name=\"排序和筛选数据\">排序和筛选数据</link>" + +#. ERCGr +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3149655\n" +"help.text" +msgid "Allows you to sort and filter the data in a query table." +msgstr "允许对查询表格中的数据进行排序和筛选。" + +#. EUECa +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3153379\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design</link>" +msgstr "" + +#. 3JCfK +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3151211\n" +"help.text" +msgid "With the <emph>Query Design</emph>, you can create and edit a query or view." +msgstr "在「<emph>查询设计</emph>」中，您可以创建和编辑查询或视图。" + +#. 343AB +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3153968\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Through Several Tables\">Query Through Several Tables</link>" +msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"查询多个表格\">查询多个表格</link>" + +#. ASeVi +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3151043\n" +"help.text" +msgid "The query result can contain data from several tables if these are linked to each other by suitable data fields." +msgstr "如果多个表格通过合适的数据字段相互链接，查询结果可以包含这些表格的数据。" + +#. xGFWG +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3159149\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Formulating Query Criteria\">Formulating Query Criteria</link>" +msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"公式化查询条件\">公式化查询条件</link>" + +#. JTXBF +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3154910\n" +"help.text" +msgid "You can find out which operators and commands can be used to formulate the filter conditions for a query." +msgstr "可以查看哪些运算符和命令可用于指定查询的筛选条件。" + +#. haGR4 +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"hd_id3156212\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Executing Functions\">Executing Functions</link>" +msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"执行函数\">执行函数</link>" + +#. FWCVa +#: 02000000.xhp +msgctxt "" +"02000000.xhp\n" +"par_id3144762\n" +"help.text" +msgid "You can perform calculations with the data of a table and store the results as a query result." +msgstr "您可以用一个表格的数据进行计算，并把结果保存为查询结果。" + +#. BncmA +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"tit\n" +"help.text" +msgid "Missing Element" +msgstr "缺少元素" + +#. noWgR +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"bm_id3150445\n" +"help.text" +msgid "<bookmark_value>queries; missing elements (Base)</bookmark_value>" +msgstr "<bookmark_value>查询; 缺少元素 (Base)</bookmark_value>" + +#. EoEQz +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3150445\n" +"help.text" +msgid "Missing Element" +msgstr "缺少元素" + +#. X2NF9 +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3150247\n" +"help.text" +msgid "If a query in which tables or fields no longer exist is opened, the<emph> Missing Element </emph>dialog appears. This dialog names the missing table or the field which cannot be interpreted and allows you to decide how to continue with the procedure." +msgstr "如果查询中使用的表格或字段已不存在，则在打开此查询时将显示「<emph>缺少元素</emph>」对话框。此对话框中列出了缺少的表格或无法解释的字段的名称，并允许您决定如何处理。" + +#. fBc3m +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3145072\n" +"help.text" +msgid "How to continue?" +msgstr "您要如何处理？" + +#. wV7Bh +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3149177\n" +"help.text" +msgid "There are three options available for answering this question:" +msgstr "对于此问题，有三个选项可供选择:" + +#. nwD7D +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3147576\n" +"help.text" +msgid "Do you really want to open the query in the graphic view?" +msgstr "是否仍在图形视图中打开查询？" + +#. hLDZm +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3166461\n" +"help.text" +msgid "<ahelp hid=\".\">Allows you to open the query in the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Design View\">Design View</link> in spite of missing elements.</ahelp> This option also allows you to specify if other errors need to be ignored." +msgstr "<ahelp hid=\".\">允许您在缺少元素的情况下在<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"设计视图\">设计视图</link>中打开查询。</ahelp>此选项还允许您指定是否需要忽略其他错误。" + +#. DX2vA +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3153031\n" +"help.text" +msgid "The query is opened in the Design View (the graphical interface). Missing tables appear blank and invalid fields appear with their (invalid) names in the list of fields. This lets you work with exactly those fields that caused the error." +msgstr "查询将在设计视图 (图形界面) 中打开。缺少的表格显示为空白，无效字段及其名称 (无效) 显示在列表字段中。这样，可以让您准确地处理导致错误的字段。" + +#. 477G3 +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3149578\n" +"help.text" +msgid "Open the query in the SQL View" +msgstr "在 SQL 视图中打开查询" + +#. FRNyg +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3159157\n" +"help.text" +msgid "<ahelp hid=\".\">Allows you to open the query design in the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"SQL Mode\">SQL Mode</link> and to interpret the query as a <link href=\"text/shared/02/14030000.xhp\" name=\"Native SQL\">Native SQL</link>.</ahelp> You can only quit the native SQL mode when the $[officename] statement is completely interpreted (only possible if the used tables or fields in the query really exist)." +msgstr "<ahelp hid=\".\">允许您在<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"SQL Mode\">SQL 模式</link>下打开查询设计，并将查询解释为<link href=\"text/shared/02/14030000.xhp\" name=\"Native SQL\">本机 SQL</link>。</ahelp>只有在完全解释了 $[officename] 语句之后 (前提是，查询中使用的表格或字段确实存在)，才能退出本机 SQL 模式。" + +#. 2N4uG +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3150984\n" +"help.text" +msgid "Do not open the query" +msgstr "不打开查询" + +#. 9hCbd +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3156329\n" +"help.text" +msgid "<ahelp hid=\".\">Allows you to cancel the procedure and specify that the query should not be opened.</ahelp> This option corresponds to the function of the <emph>Cancel</emph> dialog button." +msgstr "<ahelp hid=\".\">允许您取消此过程，并指定不打开查询。</ahelp>此选项与对话框按钮「<emph>取消</emph>」的功能相同。" + +#. 4QDUr +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"hd_id3148492\n" +"help.text" +msgid "Also ignore similar errors" +msgstr "忽略所有同类错误" + +#. tv3MZ +#: 02000002.xhp +msgctxt "" +"02000002.xhp\n" +"par_id3154285\n" +"help.text" +msgid "<ahelp hid=\".\">If you selected the first option, but you still want to open the query in the graphics view in spite of missing elements, you can specify whether other errors are ignored.</ahelp> Therefore, in the current opening process, no error message will be displayed if the query can not be correctly interpreted." +msgstr "<ahelp hid=\".\">如果选择了第一个选项，但仍希望在缺少元素的情况下在图片视图中打开查询，则可以指定是否忽略其他错误。</ahelp>这样，在当前的打开过程中，如果无法正确解释查询，将不再显示错误消息。" + +#. E3MVS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"tit\n" +"help.text" +msgid "Query Design" +msgstr "查询设计" + +#. Ys2sC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"bm_id3153323\n" +"help.text" +msgid "<bookmark_value>views; creating database views (Base)</bookmark_value> <bookmark_value>queries; creating in design view (Base)</bookmark_value> <bookmark_value>designing; queries (Base)</bookmark_value> <bookmark_value>design view; queries/views (Base)</bookmark_value> <bookmark_value>joining;tables (Base)</bookmark_value> <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value> <bookmark_value>queries; joining tables (Base)</bookmark_value> <bookmark_value>tables in databases; relations (Base)</bookmark_value> <bookmark_value>relations; joining tables (Base)</bookmark_value> <bookmark_value>queries; deleting table links (Base)</bookmark_value> <bookmark_value>criteria of query design (Base)</bookmark_value> <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value> <bookmark_value>filter conditions;in queries (Base)</bookmark_value> <bookmark_value>parameters; queries (Base)</bookmark_value> <bookmark_value>queries; parameter queries (Base)</bookmark_value> <bookmark_value>SQL; queries (Base)</bookmark_value> <bookmark_value>native SQL (Base)</bookmark_value>" +msgstr "<bookmark_value>视图; 创建数据库视图 (Base)</bookmark_value><bookmark_value>查询; 在设计视图中创建 (Base)</bookmark_value><bookmark_value>设计; 查询 (Base)</bookmark_value><bookmark_value>设计视图; 查询/视图 (Base)</bookmark_value><bookmark_value>连结; 表格 (Base)</bookmark_value><bookmark_value>数据库中的表格; 连结查询 (Base)</bookmark_value><bookmark_value>查询; 连结表格 (Base)</bookmark_value><bookmark_value>数据库中的表格; 关系 (Base)</bookmark_value><bookmark_value>关系; 连结表格 (Base)</bookmark_value><bookmark_value>查询; 删除表格链接 (Base)</bookmark_value><bookmark_value>查询设计的条件 (Base)</bookmark_value><bookmark_value>查询; 指定过滤条件 (Base)</bookmark_value><bookmark_value>过滤条件; 在查询中 (Base)</bookmark_value><bookmark_value>参数; 查询 (Base)</bookmark_value><bookmark_value>查询; 参数查询 (Base)</bookmark_value><bookmark_value>SQL; 查询 (Base)</bookmark_value><bookmark_value>原生 (native) SQL (Base)</bookmark_value>" + +#. T4W7n +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153394\n" +"help.text" +msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design</link>" +msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"查询设计\">查询设计</link>" + +#. GU8Jd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156411\n" +"help.text" +msgid "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" +msgstr "<ahelp hid=\".\">「<emph>查询设计视图</emph>」允许您创建和编辑数据库查询。</ahelp>" + +#. vGBE5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id7024140\n" +"help.text" +msgid "Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time." +msgstr "" + +#. WZcUE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159176\n" +"help.text" +msgid "Selecting the <emph>Create View</emph> command from the <emph>Tables</emph> tab page of a database document, you see the <emph>View Design</emph> window that resembles the <emph>Query Design</emph> window described here." +msgstr "从数据库文档的「<emph>表</emph>」选项卡页面中选择「<emph>创建视图</emph>」命令，您可以看到「<emph>视图设计</emph>」窗口，它与这里介绍的「<emph>查询设计</emph>」窗口相似。" + +#. JMyC7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8307138\n" +"help.text" +msgid "The Query Design window layout is stored with a created query, but cannot be stored with a created view." +msgstr "「查询设计」窗口布局可以用已创建的查询存储，不能用已创建的视图存储。" + +#. TEBj6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149233\n" +"help.text" +msgid "The Design View" +msgstr "设计视图" + +#. zkTQc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145673\n" +"help.text" +msgid "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>." +msgstr "为创建查询，请点击数据库文档中的「<emph>查询</emph>」图标，然后点击「<emph>在设计视图中创建查询</emph>」。" + +#. MAraF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150255\n" +"help.text" +msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key." +msgstr "「设计视图」下方区域中的窗格是用来<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">定义</link>查询的。要定义一个查询，请指定查询包括的数据库<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">字段名称</link>以及用于显示这些字段的<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">条件</link>。要重新排列「设计视图」下方窗格中的列，请将列标题拖到新的位置，或者选择相应的列并按「<switchinline select=\"sys\"><caseinline select=\"MAC\">命令</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+方向」键。" + +#. GMVkG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152474\n" +"help.text" +msgid "In the top of the query Design View window, the <link href=\"text/shared/main0214.xhp\" name=\"icons\">icons</link> of the <emph>Query Design</emph> Bar and the <emph>Design</emph> bar are displayed." +msgstr "在「查询设计」窗口中的上方，显示了「<emph>查询设计</emph>」栏和「<emph>设计</emph>」栏的<link href=\"text/shared/main0214.xhp\" name=\"icons\">图标</link>。" + +#. hYsxY +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147559\n" +"help.text" +msgid "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." +msgstr "如果希望测试查询，请在数据库文档中双击该查询名称。查询结果显示在类似于「数据源视图」的表格中。注: 显示的表格只是临时的。" + +#. B4HEH +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id8226264\n" +"help.text" +msgid "Keys in Query Design View" +msgstr "查询设计视图中的键" + +#. Cvd4o +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id2341074\n" +"help.text" +msgid "Key" +msgstr "键" + +#. mCy9S +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id4384289\n" +"help.text" +msgid "Function" +msgstr "功能" + +#. yybiC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id5839106\n" +"help.text" +msgid "F4" +msgstr "F4 键" + +#. FMTZD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8554338\n" +"help.text" +msgid "Preview" +msgstr "" + +#. YQhGF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id1254921\n" +"help.text" +msgid "F5" +msgstr "F5 键" + +#. C9yhE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id7636646\n" +"help.text" +msgid "Run Query" +msgstr "运行查询" + +#. jdEeJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8579363\n" +"help.text" +msgid "F7" +msgstr "F7 键" + +#. 6Y6Uw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3227942\n" +"help.text" +msgid "Add Table or Query" +msgstr "添加表格或查询" + +#. WN7wR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154939\n" +"help.text" +msgid "Browse" +msgstr "" + +#. 5y4VZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148799\n" +"help.text" +msgid "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." +msgstr "首次打开查询设计时，会出现对话框要求您先选择表格或查询，用作新查询的基础。" + +#. FBQA9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3144762\n" +"help.text" +msgid "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" +msgstr "<ahelp hid=\"HID_CTL_QRYDGNTAB\">双击字段可以将其加入到查询。拖放可以定义关系。</ahelp>" + +#. eG8FD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157894\n" +"help.text" +msgid "While designing a query, you cannot modify the selected tables." +msgstr "在设计查询期间，无法修改选中的表格。" + +#. NLywF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149562\n" +"help.text" +msgid "Remove tables" +msgstr "删除表格" + +#. TbQzA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150685\n" +"help.text" +msgid "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." +msgstr "要把一个表格从设计视图中移除，请点击表格窗口的上部边框，调出右键菜单。使用命令「<emph>删除</emph>」把表格从设计视图中移除。另外，您也可以使用删除键来移除。" + +#. VLTKB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150012\n" +"help.text" +msgid "Move table and modify table size" +msgstr "移动表格并修改表格大小" + +#. amBsQ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146922\n" +"help.text" +msgid "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." +msgstr "可以根据需要来排列表格并改变其大小。要移动一个表格，拖动其上边框到希望放置的位置。要放大或缩小一个表格的显示比例，则拖动其边框或一个角，直到得到想要的大小。" + +#. UoCRG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145365\n" +"help.text" +msgid "Table Relations" +msgstr "表格关系" + +#. BFCxB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154145\n" +"help.text" +msgid "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." +msgstr "如果一个表格中的一个数据字段与另一个表格中的一个数据字段之间存在数据关系，那么您可以把此关系用于您的查询。" + +#. jcLbE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152577\n" +"help.text" +msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." +msgstr "例如，有一个商品表格，其中的商品用商品编号标识；还有一个客户表格，用相应的商品编号记录了客户订购的全部商品。这两个表中的「商品编号」数据字段之间就存在关系。如果现在要建立查询，反馈某位客户订购的所有商品，就需要从这两个表格中检索数据。为此，必须在 $[officename] 中指定这两个表格所含数据之间的关系。" + +#. FspJi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155302\n" +"help.text" +msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." +msgstr "为此，点击一个表格中的一个字段名称 (例如客户表中的「Item-Number」字段)，并按住鼠标按钮把它拖到另一个表格的字段名称上 (「Item」表格的「Item-Number」)。当松开鼠标按钮，您会看到一根线条将两个窗口中的这两个字段连接起来。在由此产生的 SQL 查询中将登记相应的条件，即这两个数据字段的内容必须相同。" + +#. FmAaU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153876\n" +"help.text" +msgid "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." +msgstr "只有使用 $[officename] 作为关系数据库的界面，才能建立以多个关联工作表为基础的查询。" + +#. N2f8q +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145646\n" +"help.text" +msgid "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." +msgstr "不能通过同一个查询访问多个数据库中的表格。只能在一个数据库中建立涉及多个表格的查询。" + +#. nLSiq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153279\n" +"help.text" +msgid "Specifying the relation type" +msgstr "指定关系类型" + +#. kDhFD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154791\n" +"help.text" +msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog." +msgstr "如果双击两个链接字段之间的连线，或者调用菜单命令「<emph>插入 - 新建关系</emph>」，您可以在「<link href=\"text/shared/explorer/database/02010101.xhp\" name=\"关系\"><emph>关系</emph></link>」对话框中指定关系的类型。" + +#. rAkmw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150094\n" +"help.text" +msgid "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." +msgstr "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">编辑联接属性</ahelp>也可以按住 Tab 键直到选中线条，然后按 Shift+F10 组合键来显示右键菜单并选择指令「<emph>编辑</emph>」。某些数据库只支持可能联接类型的子集。" + +#. n3PMB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155851\n" +"help.text" +msgid "Deleting relations" +msgstr "删除关系" + +#. jCb4H +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156178\n" +"help.text" +msgid "To delete a relation between two tables, click the connection line and then press the Delete key." +msgstr "要删除两个表格间的关系，请用鼠标点击其连线并随后按删除键。" + +#. 3UCig +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150715\n" +"help.text" +msgid "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." +msgstr "另外，也可以在「<emph>关系</emph>对话框中删除「<emph>相关字段</emph>」包含的相应条目，或者按 Tab 键找到高亮显示的连结向量，然后按 Shift+F10 键打开右键菜单并选择<emph>删除</emph>」命令。" + +#. pBybB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3151208\n" +"help.text" +msgid "Defining the query" +msgstr "定义查询" + +#. yGfhU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3158416\n" +"help.text" +msgid "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." +msgstr "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">选择条件以定义查询。</ahelp>设计表格的每列都接受用于查询的数据字段。一行中的条件用布尔 AND 连接。" + +#. UB5nG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154161\n" +"help.text" +msgid "Specifying field names" +msgstr "指定字段名称" + +#. jyKMG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146791\n" +"help.text" +msgid "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." +msgstr "首先，从表格中选择所有要加入到查询的字段名称。这可以通过拖放或者直接双击表格窗口中的字段名称来实现。这里的拖放是指使用鼠标将字段名称从表格窗口拖到「查询设计」的下方区域中。拖放时，可以决定将选中字段加入「查询设计」窗口的哪一列中。可通过双击来选择字段名称。相应的字段将被加入「查询设计」窗口的下一个空白列。" + +#. 66Dcr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150750\n" +"help.text" +msgid "Deleting field names" +msgstr "删除字段名称" + +#. AbhrW +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154479\n" +"help.text" +msgid "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." +msgstr "要将一个字段名称从查询中删除，请用鼠标点击该字段的标题，然后在该列的右键菜单中启动命令「<emph>删除</emph>」。" + +#. V92gB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155764\n" +"help.text" +msgid "Saving the query" +msgstr "保存查询" + +#. 2kWoA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148481\n" +"help.text" +msgid "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." +msgstr "使用「标准」工具栏上的「<emph>保存</emph>」图标来保存查询。将会看到一个要求您输入查询名称的对话框。如果数据库支持略图，您也可以输入略图名称。" + +#. M9UQL +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154362\n" +"help.text" +msgid "Schema" +msgstr "略图" + +#. 4Jwm3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154754\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" +msgstr "<ahelp hid=\"dbaccess/ui/savedialog/schema\">请输入为查询/表格视图指定的架构名称。</ahelp>" + +#. 6Q72c +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3156717\n" +"help.text" +msgid "Query name or table view name" +msgstr "查询/表格视图名称" + +#. Cw73K +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154253\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" +msgstr "<ahelp hid=\"dbaccess/ui/savedialog/title\">输入查询/表视图的名称。</ahelp>" + +#. qgbNu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3163805\n" +"help.text" +msgid "Filtering data" +msgstr "筛选数据" + +#. Q9pG5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154964\n" +"help.text" +msgid "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" +msgstr "要筛选查询的数据，请在「视图设计」的下方区域中设置所需条件。可以使用以下选项:" + +#. xxoMA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3146916\n" +"help.text" +msgid "Field" +msgstr "" + +#. 4KDzZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156372\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">输入查询中所引用的数据字段的名称。筛选选项各行中的所有设置都是针对此字段。</ahelp>通过点击鼠标激活某个单元格，将显示一个箭头按钮，以供选择字段。「Table name.*」选项可选择所有的数据字段，指定条件对于所有表格字段均有效。" + +#. Z3pwF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145150\n" +"help.text" +msgid "Alias" +msgstr "" + +#. EDa3A +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146315\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">指定别名。此别名将替代字段名称显示在查询中。这样就可使用用户定义的列标签。</ahelp>例如，数据字段的名称为「PtNo」，而您却希望在查询中显示名「PartNum」，此时就可输入「PartNum」作为别名。" + +#. vvWbt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155959\n" +"help.text" +msgid "In a SQL statement, aliases are defined as follows:" +msgstr "在 SQL 语句中，定义别名的方法如下:" + +#. CGsBz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149922\n" +"help.text" +msgid "SELECT column AS alias FROM table." +msgstr "SELECT column AS alias FROM table。" + +#. TWexq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159335\n" +"help.text" +msgid "For example:" +msgstr "例如:" + +#. ynSGq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148478\n" +"help.text" +msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" +msgstr "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" + +#. roTzi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148485\n" +"help.text" +msgid "Table" +msgstr "" + +#. GM9Sp +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3163665\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">在此列出所选数据字段对应的数据库表格。</ahelp>如果通过点击鼠标来激活某个单元格，将显示一个箭头按钮，以便为当前查询选择其他表格。" + +#. JGcfa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154207\n" +"help.text" +msgid "Sort" +msgstr "" + +#. uXuDt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150979\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">如果您点击此单元格，可以选择排序选项: 升序、降序和不排序。</ahelp>文本字段按字母顺序排序，数字字段按数字顺序排序。对于大部分数据库，管理员可以在数据库级别设置排序选项。" + +#. XsqW8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150384\n" +"help.text" +msgid "Visible" +msgstr "可见" + +#. AAZfA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146133\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">如果为某个数据字段选中「<emph>可见</emph>」属性，在查询结果中将显示该字段。</ahelp>如果数据字段只用于构成条件或计算，则不必显示该字段。" + +#. eQFRR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154714\n" +"help.text" +msgid "Criteria" +msgstr "条件" + +#. JdqLq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145134\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">指定筛选数据字段内容的首要<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">条件</link>。</ahelp>" + +#. qpADC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3152477\n" +"help.text" +msgid "or" +msgstr "或者" + +#. KFVy8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154585\n" +"help.text" +msgid "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." +msgstr "您可以在每一行输入一个附加筛选条件。单列中的多个条件将解析为布尔「或」。" + +#. eXvp7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148800\n" +"help.text" +msgid "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" +msgstr "此外，还可以通过行标题的右键菜单在「查询设计」窗口的下部区域插入基于函数的筛选:" + +#. 5x8LE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148419\n" +"help.text" +msgid "Functions" +msgstr "函数" + +#. Cxhjn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153233\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">选择要在此处的查询中运行的函数。</ahelp>此处可供选择的函数取决于数据库引擎提供的函数。" + +#. qFuqw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8760818\n" +"help.text" +msgid "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" +msgstr "如果使用的是嵌入式 HSQL 数据库，「<emph>函数</emph>」行的列表框提供以下选项:" + +#. 9tdDn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150307\n" +"help.text" +msgid "Option" +msgstr "选项" + +#. kBvXF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152993\n" +"help.text" +msgid "Effect" +msgstr "效果" + +#. zCunm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155377\n" +"help.text" +msgid "No function" +msgstr "无函数" + +#. kZMTN +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155533\n" +"help.text" +msgid "No function will be executed." +msgstr "无函数可执行。" + +#. 6dWZZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3166420\n" +"help.text" +msgid "Average" +msgstr "平均值" + +#. NfRNs +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154486\n" +"help.text" +msgid "Calculates the arithmetic mean of a field." +msgstr "计算一个字段的算术平均值。" + +#. 6z2Kj +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149979\n" +"help.text" +msgid "Count" +msgstr "记数" + +#. rvWA5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155810\n" +"help.text" +msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." +msgstr "确定表格中记录的数目。空字段可以计算在内 (a)，也可以排除在外 (b)。" + +#. UyAx2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151333\n" +"help.text" +msgid "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." +msgstr "a) COUNT(*):如果使用一个小星号作为参数，那么该表的全部记录都将计算在内。" + +#. FNCC8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152889\n" +"help.text" +msgid "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." +msgstr "b) COUNT(列): 将字段名称作为参数传递，仅统计指定字段中包含值的记录。不会统计字段值为 Null (即不包含文本或数值) 的记录。" + +#. 2ubvb +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153067\n" +"help.text" +msgid "Maximum" +msgstr "最大值" + +#. ds4ey +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159221\n" +"help.text" +msgid "Determines the highest value of a record for that field." +msgstr "确定一个字段最大的记录值。" + +#. EhSWy +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146866\n" +"help.text" +msgid "Minimum" +msgstr "最小值" + +#. VxmeB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157982\n" +"help.text" +msgid "Determines the lowest value of a record for that field." +msgstr "确定一个字段最小的记录值。" + +#. CvkuF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154828\n" +"help.text" +msgid "Sum" +msgstr "总计" + +#. 82gAC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154536\n" +"help.text" +msgid "Calculates the sum of the values of records for the associated fields." +msgstr "计算各个相关字段的记录值的总和。" + +#. zCzVC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148820\n" +"help.text" +msgid "Group" +msgstr "组合" + +#. tSPNG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149438\n" +"help.text" +msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." +msgstr "按照选中的字段名称对查询数据进行组合。根据指定的组合，执行相应的函数。在 SQL 中，此选项对应于「GROUP BY」子句。如果添加某个条件，则对应的条目将显示在 SQL「HAVING」子句中。" + +#. qHfpD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156038\n" +"help.text" +msgid "You can also enter function calls directly into the SQL statement. The syntax is:" +msgstr "也可以直接在 SQL 语句中输入函数，其语法是:" + +#. Qg6Ue +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156340\n" +"help.text" +msgid "SELECT FUNCTION(column) FROM table." +msgstr "SELECT FUNCTION(column) FROM table。" + +#. qAAoF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155075\n" +"help.text" +msgid "For example, the function call in SQL for calculating a sum is:" +msgstr "例如在 SQL 中调用计算总和的函数:" + +#. VrHLf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154591\n" +"help.text" +msgid "SELECT SUM(\"Price\") FROM \"Article\"." +msgstr "SELECT SUM(\"price\") FROM \"article\"。" + +#. dABCo +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159205\n" +"help.text" +msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." +msgstr "以上函数除「<emph>分组</emph>」函数外，就是所谓的「聚合函数」。这些就是用于从结果中计算数据以创建汇总的函数。列表框中没有列出的其他函数也是可能的。这与指定使用何种数据库引擎以及 Base 用于连接该数据库引擎的驱动程序当前能提供的功能有关。" + +#. BVC6J +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148651\n" +"help.text" +msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." +msgstr "要使用列表框中没有列出的其他函数，得在「<emph>字段</emph>」下手动输入。" + +#. WkboS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155098\n" +"help.text" +msgid "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." +msgstr "您也可以将别名指定给函数调用。如果不希望查询字符串显示在列标题中，请在「<emph>别名</emph>」下输入想要的替代名称。" + +#. 98GCC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155539\n" +"help.text" +msgid "The corresponding function in an SQL statement is:" +msgstr "SQL 语句中的相应函数是:" + +#. WACG9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149425\n" +"help.text" +msgid "SELECT FUNCTION() AS alias FROM table" +msgstr "SELECT FUNCTION() AS alias FROM table" + +#. EjzuD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3144431\n" +"help.text" +msgid "Example:" +msgstr "" + +#. G9URE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154614\n" +"help.text" +msgid "SELECT COUNT(*) AS count FROM \"Item\"" +msgstr "SELECT COUNT(*) AS amount FROM \"article\"" + +#. xiNnR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154610\n" +"help.text" +msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." +msgstr "如果运行此类函数，则除了将这些列作为「组合」函数的参数外，不能再插入其他用于查询的列。" + +#. EHACK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154644\n" +"help.text" +msgid "<emph>Examples</emph>" +msgstr "「<emph>示例</emph>」" + +#. N5CBE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151120\n" +"help.text" +msgid "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" +msgstr "在以下示例中，通过两个表格来进行查询: \"Item\" 表格带有字段 \"Item_No\"，\"Suppliers\" 表格带有字段 \"Supplier_Name\"。另外，这两个表格还有一个共同的数据字段 \"Supplier_No\"。" + +#. P5hJD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155144\n" +"help.text" +msgid "The following steps are required to create a query containing all suppliers who deliver more than three items." +msgstr "要建立一个包括所有提供多于 3 种货物的供货商的查询，必须执行下列步骤:。" + +#. ZhRQD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153240\n" +"help.text" +msgid "Insert the \"Item\" and \"Suppliers\" tables into the query design." +msgstr "把表 \"article\" 和 表\"supplier\" 插入查询设计。" + +#. LMRUV +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148807\n" +"help.text" +msgid "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." +msgstr "假如此类型没有关系，那么链接两个表格的 \"Supplier_No\" 字段。" + +#. qWhFA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3161652\n" +"help.text" +msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function." +msgstr "双击表格「Item」中的「Item_No」字段。使用右键菜单显示「<emph>函数</emph>」行，然后选择「Count」函数。" + +#. TgPA2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151009\n" +"help.text" +msgid "Enter >3 as a criterion and disable the Visible field." +msgstr "输入条件「>3」，然后禁用「可见」字段。" + +#. VwEhF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145601\n" +"help.text" +msgid "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and choose the Group function." +msgstr "在表格 \"Suppliers\" 中双击字段 \"Supplier_Name\"，然后选择组合函数。" + +#. zsjaa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147512\n" +"help.text" +msgid "Run the query." +msgstr "运行查询。" + +#. EzQsj +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148638\n" +"help.text" +msgid "If the \"price\" (for the individual price of an article) and \"Supplier_No\" (for the supplier of the article) fields exist in the \"Item\" table, you can obtain the average price of the item that a supplier provides with the following query:" +msgstr "如果在表格 \"Item\" 中有字段 \"preice\" (货物的单价) 和字段 \"Supplier_No\" (货物的供应商)，那么您就能用以下查询得到供应商提供的货物的平均价格:" + +#. qAByp +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153045\n" +"help.text" +msgid "Insert the \"Item\" table into the query design." +msgstr "将 \"Item\" 表格插入查询设计。" + +#. tjfuE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149802\n" +"help.text" +msgid "Double-click the \"Price\" and \"Supplier_No\" fields." +msgstr "双击 \"Preice\" 和 \"Supplier_No\" 字段。" + +#. 6dBkt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153554\n" +"help.text" +msgid "Enable the <emph>Function</emph> line and select the Average function from the \"Price\" field." +msgstr "打开「<emph>函数</emph>」行，然后在 \"price\" 字段中选择平均值函数。" + +#. x8JB3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155597\n" +"help.text" +msgid "You can also enter \"Average\" in the line for the alias name (without quotation marks)." +msgstr "你也可以在用于别名的行中输入「平均值」 (不带引号)。" + +#. D4A9u +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151191\n" +"help.text" +msgid "Choose Group for the \"Supplier_No\" field." +msgstr "在 \"Supplier_No\" 字段选择组合。" + +#. BUYS9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155547\n" +"help.text" +msgid "Run the query." +msgstr "运行查询。" + +#. EkHzB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147549\n" +"help.text" +msgid "The following context menu commands and symbols are available:" +msgstr "下面是现有的右键菜单命令和各式图标:" + +#. PesFs +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154172\n" +"help.text" +msgid "Functions" +msgstr "函数" + +#. BchuJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150414\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">显示或隐藏用于函数选择的行。</ahelp>" + +#. yx5XE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149872\n" +"help.text" +msgid "Table Name" +msgstr "表格名称" + +#. ELTGJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147246\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the table name.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">显示或隐藏用于表格名称的行。</ahelp>" + +#. DDFEA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145117\n" +"help.text" +msgid "Alias Name" +msgstr "别名" + +#. LDFZB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155754\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the alias name.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">显示或隐藏别名所在的行。</ahelp>" + +#. wnNhq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153298\n" +"help.text" +msgid "Distinct Values" +msgstr "非重复值" + +#. 23sAF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147500\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)." +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">查询时只检索非重复值。</ahelp>该功能适用于选中字段可能出现多次重复数据记录的情况。如果启用了「<emph>非重复值</emph>」命令，在查询结果中相同值仅显示一条记录 (DISTINCT)。否则，将显示所有符合查询条件的数据记录 (ALL)。" + +#. RZED7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150436\n" +"help.text" +msgid "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." +msgstr "例如，如果地址数据库中含有多个「Smith」，您可以选中「<emph>非重复值</emph>」命令来指定「Smith」这个名字在查询结果中仅出现一次。" + +#. 2GvRf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152352\n" +"help.text" +msgid "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." +msgstr "如果查询涉及多个字段，则所有字段值的组合必须唯一，该记录才会在结果中出现。例如，通讯簿中包括一条「芝加哥的 Smith」和两条「伦敦的 Smith」。使用「<emph>非重复值</emph>」命令查询「姓氏」和「城市」两个字段后，返回的查询结果中只会出现一条「芝加哥的 Smith」和一条「伦敦的 Smith」。" + +#. m5UcG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149825\n" +"help.text" +msgid "In SQL, this command corresponds to the DISTINCT predicate." +msgstr "在 SQL 中，此命令对应于 DISTINCT 谓词。" + +#. GHsJd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153290\n" +"help.text" +msgid "Limit" +msgstr "限度" + +#. MijJg +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147501\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">允许您限制查询返回的最大记录条数。</ahelp>" + +#. B6S5f +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152350\n" +"help.text" +msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria." +msgstr "如果添加了「<emph>Limit</emph>」语句, 您将会得到不超过该数字指定的记录数。否则，您将会看到满足查询条件的所有记录。" + +#. MGqK3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148926\n" +"help.text" +msgid "Formulating filter conditions" +msgstr "指定筛选条件" + +#. iFSpm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153162\n" +"help.text" +msgid "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 via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:" +msgstr "在指定筛选条件时，您可以使用各种运算符和命令，包括关系运算符，以及用于查询数据库字段内容的 SQL 特定命令。如果使用 $[officename] 语法来调用这些命令，则 $[officename] 会自动通过内部解析器将它们转换成对应的 SQL 语法。也可以绕过内部解析器，直接输入 SQL 命令。下表简要介绍了一些运算符和命令:" + +#. fXeDd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149044\n" +"help.text" +msgid "Operator" +msgstr "运算符" + +#. mfdEx +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152471\n" +"help.text" +msgid "Meaning" +msgstr "含义" + +#. mBZgC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147407\n" +"help.text" +msgid "Condition is satisfied if..." +msgstr "如果...，则条件满足" + +#. gqkRK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153026\n" +"help.text" +msgid "equal to" +msgstr "等于" + +#. hw7KZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148895\n" +"help.text" +msgid "... the content of the field is identical to the indicated expression." +msgstr "...该字段内容与指定的表达式一致。" + +#. A8XJU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153120\n" +"help.text" +msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed." +msgstr "运算符「=」不显示在查询字段中。如果输入一个不带运算符的数值，会自动假设采用「=」运算符。" + +#. mWwUE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145223\n" +"help.text" +msgid "not equal to" +msgstr "不等于" + +#. Db7BG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145635\n" +"help.text" +msgid "... the content of the field does not correspond to the specified expression." +msgstr "...该字段内容与指定的表达式不一致。" + +#. dtjkU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146815\n" +"help.text" +msgid "greater than" +msgstr "大于" + +#. gCWug +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149150\n" +"help.text" +msgid "... the content of the field is greater than the specified expression." +msgstr "...字段内容长于指定的表达式。" + +#. QkAKk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147379\n" +"help.text" +msgid "less than" +msgstr "小于" + +#. xxPdk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150375\n" +"help.text" +msgid "... the content of the field is less than the specified expression." +msgstr "...字段内容小于指定的表达式。" + +#. 4aJjX +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150636\n" +"help.text" +msgid "greater than or equal to" +msgstr "大于或等于" + +#. 2rwQm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154584\n" +"help.text" +msgid "... the content of the field is greater than or equal to the specified expression." +msgstr "...该字段内容大于或等于指定表达式。" + +#. ADRZk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154052\n" +"help.text" +msgid "less than or equal to" +msgstr "小于或等于" + +#. 9KtmZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157902\n" +"help.text" +msgid "... the content of the field is less than or equal to the specified expression." +msgstr "...该字段内容小于或等于指定的表达式。" + +#. DBXG9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154630\n" +"help.text" +msgid "$[officename] command" +msgstr "$[officename] 命令" + +#. Yo7MG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150484\n" +"help.text" +msgid "SQL command" +msgstr "SQL 命令" + +#. pJay6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154158\n" +"help.text" +msgid "Meaning" +msgstr "含义" + +#. qmaX5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149433\n" +"help.text" +msgid "Condition is satisfied if..." +msgstr "如果...，则条件满足" + +#. do6XQ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3143236\n" +"help.text" +msgid "is null" +msgstr "为空" + +#. NPqBL +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154744\n" +"help.text" +msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)." +msgstr "... 该字段不包含数据。对于带有三种可能状态的「是/否」字段，该命令自动查询不确定的状态 (既非「是」、也非「否」)。" + +#. 7Rfbd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151229\n" +"help.text" +msgid "is not empty" +msgstr "非空" + +#. w3Tva +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145304\n" +"help.text" +msgid "... the field is not empty, i.e it contains data." +msgstr "... 字段不为空，即包含数据。" + +#. GGKUH +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153891\n" +"help.text" +msgid "placeholder (*) for any number of characters" +msgstr "占位符 (*) 表示任意数量的字符" + +#. gbEWB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148887\n" +"help.text" +msgid "placeholder (?) for exactly one character" +msgstr "占位符 (?) 表示一个字符" + +#. tBQfA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"bm_id3157985\n" +"help.text" +msgid "<bookmark_value>placeholders; in SQL queries</bookmark_value>" +msgstr "<bookmark_value>占位符; 在 SQL 查询中</bookmark_value>" + +#. agxhB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157985\n" +"help.text" +msgid "placeholder (%) for any number of characters" +msgstr "占位符 (%) 表示任意数量的字符" + +#. EE9ii +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147422\n" +"help.text" +msgid "Placeholder (_) for exactly one character" +msgstr "占位符 (_) 表示一个字符" + +#. za5g2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154845\n" +"help.text" +msgid "is an element of" +msgstr "是一个元素，位于" + +#. 2Y3zW +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156130\n" +"help.text" +msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the %PRODUCTNAME interface." +msgstr "... 数据字段含有指定的表达式。占位符 (*) 确定表达式 x 是在起始位置 (x*)、结束位置 (*x) 或在字段内容的内部 (*x*) 出现。您可以在 SQL 查询中输入 SQL 字符 % 作为占位符，在 %PRODUCTNAME 界面中则输入文件系统常见的占位符 (*)。" + +#. CPJyr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150271\n" +"help.text" +msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character." +msgstr "占位符 (*) 或 (%) 表示任意数量的字符。在 $[officename] 界面中使用问号 (?)，在 SQL 查询中使用下划线 (_) 表示单个字符。" + +#. AAEXi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159141\n" +"help.text" +msgid "Is not an element of" +msgstr "不是一个元素，位于" + +#. 9vFBZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3161664\n" +"help.text" +msgid "... the field does not contain data having the specified expression." +msgstr "... 该字段不含符合指定表达式的数据。" + +#. CD2Ra +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159184\n" +"help.text" +msgid "falls within the interval [x,y]" +msgstr "位于区间 [x,y] 中" + +#. cDe2u +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154395\n" +"help.text" +msgid "... the field contains a data value that lies between the two values x and y." +msgstr "... 该字段包含位于 x 和 y 之间的数据值。" + +#. KYAXv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155498\n" +"help.text" +msgid "Does not fall within the interval [x,y]" +msgstr "不在区间 [x,y] 中" + +#. cVfAF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148992\n" +"help.text" +msgid "... the field contains a data value that does not lie between the two values x and y." +msgstr "... 该字段包含不在 x 和 y 之间的数据值。" + +#. DBBQE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159167\n" +"help.text" +msgid "Note that semicolons are used as separators in all value lists!" +msgstr "注意，所有数值列表采用分号作为分隔符!" + +#. evEuh +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154809\n" +"help.text" +msgid "contains a, b, c..." +msgstr "含有 a, b, c..." + +#. eeFC2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148399\n" +"help.text" +msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters" +msgstr "... 该数据字段含有指定表达式 a, b, c,... 中的一个。可以指定任意数量的表达式，它们将用布尔「或」连接来获取查询结果。表达 a, b, c... 既可以是数字，也可以是字符" + +#. JXq76 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150679\n" +"help.text" +msgid "does not contain a, b, c..." +msgstr "不包含 a, b, c..." + +#. U5doB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3158439\n" +"help.text" +msgid "... the field does not contain one of the specified expressions a, b, c,..." +msgstr "... 该字段不含指定的表达式 a, b, c,..." + +#. cECKt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149248\n" +"help.text" +msgid "has the value True" +msgstr "值为 True" + +#. fbgDt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148524\n" +"help.text" +msgid "... the field name has the value True." +msgstr "...该字段名称值为 True。" + +#. 39zcD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149955\n" +"help.text" +msgid "has the value false" +msgstr "有值 false" + +#. fGHY6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146850\n" +"help.text" +msgid "... the field data value is set to false." +msgstr "... 字段数据值已设为 false。" + +#. qQETa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155954\n" +"help.text" +msgid "Examples" +msgstr "示例" + +#. 8GaiA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150948\n" +"help.text" +msgid "returns field names with the field content \"Ms.\"" +msgstr "返回带有字段内容 \"Ms.\" 的字段。" + +#. C3BDE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id315094A\n" +"help.text" +msgid "returns dates that occurred before January 10, 2001" +msgstr "返回2001年1月10日之前的日期" + +#. T7ZhS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147332\n" +"help.text" +msgid "returns records with field content such as \"give\" and \"gave\"." +msgstr "返回字段内容含有「give」与「gave」的记录。" + +#. f6T3F +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155350\n" +"help.text" +msgid "returns records with field contents such as \"Sun\"." +msgstr "返回字段内容为「Sun」的记录。" + +#. AvbKu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159406\n" +"help.text" +msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)." +msgstr "返回字段内容在 10 到 20 之间的数值的记录。 (既可以是文本字段也可以是数字字段。)。" + +#. 3tymM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149712\n" +"help.text" +msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number." +msgstr "返回数值为 1、3、5、7 的记录。如果数据字段包含一个项目编号，则可以创建查询，找出带有指定编号的特定项目。" + +#. uusce +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147279\n" +"help.text" +msgid "returns records that do not contain \"Smith\"." +msgstr "返回不包含「Smith」的记录。" + +#. AJ8Xo +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146073\n" +"help.text" +msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}" +msgstr "「<emph>Like</emph>」转义序列: {escape '转义字符'}" + +#. Cy7Cc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150661\n" +"help.text" +msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}" +msgstr "示例: select * from Item where ItemName like 'The *%' {escape '*'}" + +#. newGb +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148541\n" +"help.text" +msgid "The example will give you all of the entries where the item name begins with 'The *'. This means that you can also search for characters that would otherwise be interpreted as placeholders, such as *, ?, _, % or the period." +msgstr "该示例得到所有 ItemName 以「The *」开头的条目。这意味着通常被解释为占位符的字符也可以用于搜索，如「*」「?」「_」「%」「.」等。" + +#. bAP3N +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150572\n" +"help.text" +msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" +msgstr "「<emph>Outer Join</emph>」转义序列: {oj 外部连接}" + +#. VnKGf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156052\n" +"help.text" +msgid "Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}" +msgstr "示例: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}" + +#. mWG9p +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153674\n" +"help.text" +msgid "Querying text fields" +msgstr "查询文字字段" + +#. sxYQF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149134\n" +"help.text" +msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly)." +msgstr "为了查询文本字段的内容，必须将表达式设置在单引号内。是否区分大小写取决于使用的数据库。按照定义，「LIKE」区分大小写 (尽管一些数据库并不严格区分。)。" + +#. BEp4G +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149302\n" +"help.text" +msgid "Querying date fields" +msgstr "查询日期字段" + +#. D5mjw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157998\n" +"help.text" +msgid "<emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax." +msgstr "「<emph>日期字段</emph>」以「#Date#」的形式表示，明确声明自己是日期。条件中使用的日期、时间以及日期/时间常量 (字面值) 可以使用「SQL 转义语法」类型，也可以使用默认的 SQL2 语法。" + +#. Zzuo6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537341\n" +"help.text" +msgid "Date Type Element" +msgstr "数据类型元素" + +#. JKys2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537342\n" +"help.text" +msgid "SQL Escape syntax #1 - may be obsolete" +msgstr "SQL 转义语法 #1 - 可能已过时" + +#. AzkWz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537343\n" +"help.text" +msgid "SQL Escape syntax #2" +msgstr "SQL 转义语法 #2" + +#. UJ6VA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537344\n" +"help.text" +msgid "SQL2 syntax" +msgstr "SQL2 语法" + +#. 9V3Ky +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id315913111\n" +"help.text" +msgid "Date" +msgstr "日期" + +#. YNF3S +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31559471\n" +"help.text" +msgid "Time" +msgstr "时间" + +#. ssX5b +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31509641\n" +"help.text" +msgid "DateTime" +msgstr "日期时间" + +#. FqZXM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149539\n" +"help.text" +msgid "Example: select {d '1999-12-31'} from world.years" +msgstr "示例: select {d '1999-12-31'} from world.years" + +#. WJ4YB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149540\n" +"help.text" +msgid "Example: select * from mytable where years='1999-12-31'" +msgstr "示例: select * from mytable where years='1999-12-31'" + +#. CZdA4 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150510\n" +"help.text" +msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" +msgstr "所有日期表达式 (日期常量) 必须用单引号括起来。 (详情请参阅您使用的特定数据库及连接器的参考手册。)" + +#. HXdKT +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150427\n" +"help.text" +msgid "Querying Yes/No fields" +msgstr "查询「是/否」字段" + +#. xWzix +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149523\n" +"help.text" +msgid "To query Yes/No fields, use the following syntax for dBASE tables:" +msgstr "要查询「是/否」字段，请在 dBASE 表中使用下列语法:" + +#. A4Uh7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153180\n" +"help.text" +msgid "Status" +msgstr "" + +#. FnXiE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147481\n" +"help.text" +msgid "Query criterion" +msgstr "查询条件" + +#. e6DJr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155187\n" +"help.text" +msgid "Example" +msgstr "示例" + +#. Guy7d +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156092\n" +"help.text" +msgid "Yes" +msgstr "是" + +#. p9WTn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152414\n" +"help.text" +msgid "for dBASE tables: not equal to any given value" +msgstr "对于 dBASE 表格: 不等于任何给定的值" + +#. RFrvz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151265\n" +"help.text" +msgid "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," +msgstr "=1 返回所有「是/否」字段状态为「是」或「至」的记录 (黑色标记)。" + +#. 3P4ZB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152450\n" +"help.text" +msgid "No" +msgstr "否" + +#. BzBAa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150997\n" +"help.text" +msgid "." +msgstr "." + +#. TFsQG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155331\n" +"help.text" +msgid "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." +msgstr "=0 返回所有「是/否」字段状态为「否」或「关闭」的记录 (无选择)。" + +#. 9KXzK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154179\n" +"help.text" +msgid "Null" +msgstr "Null" + +#. CwGZv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147035\n" +"help.text" +msgid "IS NULL" +msgstr "IS NULL" + +#. dyXYc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159385\n" +"help.text" +msgid "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." +msgstr "IS NULL 返回所有是/否字段无「是」或「否」这两种状态的记录 (灰色标记)。" + +#. YWk5J +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157888\n" +"help.text" +msgid "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." +msgstr "所用的语法取决于使用的数据库系统。同时还需要注意，「是/否」字段的定义可能会有所不同 (仅有 2 种状态，而不是 3 种)。" + +#. mmVa8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145772\n" +"help.text" +msgid "Parameter queries" +msgstr "参数查询" + +#. ND7xd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905346795\n" +"help.text" +msgid "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run." +msgstr "参数查询允许用户在运行时输入值。这些值用在条件中，用于选择要显示的记录。此类的每个值都有参数名称与之关联，用于提示用户查询正在执行。" + +#. Be7XG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905439551\n" +"help.text" +msgid "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used." +msgstr "在「设计」视图以及「SQL」视图中，参数名称均有冒号前缀。名称用在值可以出现的地方。如果相同值在查询中出现多次，可使用相同的参数名称。" + +#. rSkkZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905518123\n" +"help.text" +msgid "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" +msgstr "最简单的情况，当用户输入用于比较的值时，参数名称及其冒号前缀可直接在「条件」行输入。在「<link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL 模式</link>」下，应这样输入:「<item type=\"input\">WHERE \"字段\" = :参数名称</item>」" + +#. DZCXm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905584287\n" +"help.text" +msgid "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases." +msgstr "参数名称不能包含这些字符「<item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>」。也不能与字段名称或 SQL 保留字相同。可以与别名相同。" + +#. AY8e3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151931441881\n" +"help.text" +msgid "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." +msgstr "用于根据文字字段内容的一部分构造选择条件时，可以这样「<item type=\"input\">\"LIKE '%' || :字段部分 || '%'\"</item>」将隐藏列作为条件添加。这将选择精确匹配的记录。如果需要大小写不敏感的测试，一种解决方案是用「<item type=\"input\">LOWER (字段名称)</item> 作为字段，用「<item type=\"input\">LIKE LOWER ( '%' || :字段部分 || '%' )</item>」作为条件。注意条件中的空格很重要; 如果省略，SQL 解析器将把整个条件作为待匹配的字符串来解析。「<link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL 模式</link>」下应这样输入: <item type=\"input\">LOWER ( \"字段名称\" ) LIKE LOWER ( '%' || :字段部分 || '%' )</item>」。" + +#. sSSB9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150585\n" +"help.text" +msgid "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\" name=\"subforms\">subforms</link>, to allow the user to restrict the displayed records." +msgstr "参数查询可用作「<link href=\"text/shared/02/01170203.xhp\" name=\"subforms\">子表单</link>」的数据源，以便用户限制显示的记录。" + +#. DRj78 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3151035\n" +"help.text" +msgid "Parameter Input" +msgstr "输入参数值" + +#. BisCF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153596\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">「<emph>参数输入</emph>」对话框会要求用户输入参数值。输入每个查询参数的值，然后点击「<emph>确定</emph>」或按「<emph>回车</emph>」键确认。</ahelp>" + +#. eGETM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151924165870\n" +"help.text" +msgid "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system." +msgstr "用户输入的值可由 SQL 相关条件允许的任意字符构成; 具体取决于底层数据库系统。" + +#. seFhG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151939594217\n" +"help.text" +msgid "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria." +msgstr "用户可以使用 SQL 通配符「%」 (任意字符串) 或「_」 (任意单个字符) 作为值的一部分，以便用更复杂的条件检索记录。" + +#. wRe6v +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145181\n" +"help.text" +msgid "SQL Mode" +msgstr "SQL 模式" + +#. 5avVu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147013\n" +"help.text" +msgid "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." +msgstr "SQL 意为 \"Structured Query Language\" (结构化查询语言)，描述用于查询、更新和管理关系数据库的指令。" + +#. wDAAY +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152570\n" +"help.text" +msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created." +msgstr "由于不用输入 SQL 代码，因此对 $[officename] 中的大多数查询而言您并不需要了解 SQL。当您在「查询设计」中创建查询后，$[officename] 会自动将指令转换成对应的 SQL 语法。如果使用「<emph>设计视图打开/关闭</emph>」按钮切换至 SQL 视图，则可看到已建立查询的 SQL 命令。" + +#. hBQFv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152412\n" +"help.text" +msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use." +msgstr "您可以直接用 SQL 代码构建查询语句。但要注意，特殊语法由您使用的数据库系统决定。" + +#. kkuBG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146842\n" +"help.text" +msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode." +msgstr "如果手动输入 SQL 代码，您可以创建 SQL 特有的查询语句。「<emph>查询设计</emph>」中的图形界面不支持该类查询。必须在原生 SQL 模式中执行此类查询。" + +#. cBY6B +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149632\n" +"help.text" +msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine." +msgstr "在 SQL 视图中点击「<link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>直接运行 SQL 指令</emph></link>」图标，可以建立不由 $[officename] 处理的查询，并直接发送给数据库引擎。" + +#. fKBDD +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"tit\n" +"help.text" +msgid "Join Properties" +msgstr "连接属性" + +#. TTCNB +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"bm_id3154015\n" +"help.text" +msgid "<bookmark_value>links;relational databases (Base)</bookmark_value> <bookmark_value>inner joins (Base)</bookmark_value> <bookmark_value>joins in databases (Base)</bookmark_value> <bookmark_value>left joins (Base)</bookmark_value> <bookmark_value>right joins (Base)</bookmark_value> <bookmark_value>full joins (Base)</bookmark_value>" +msgstr "<bookmark_value>链接; 关系数据库 (Base)</bookmark_value> <bookmark_value>内连接 (Base)</bookmark_value> <bookmark_value>数据库中的连接 (Base)</bookmark_value> <bookmark_value>左连接 (Base)</bookmark_value> <bookmark_value>右连接 (Base)</bookmark_value> <bookmark_value>完全连接 (Base)</bookmark_value>" + +#. DG7RD +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3154015\n" +"help.text" +msgid "Join Properties" +msgstr "连接属性" + +#. MzpBt +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3151205\n" +"help.text" +msgid "If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Join Properties</emph> dialog appears. These properties will be used in all queries created in the future." +msgstr "在查询设计中，如果双击两个链接字段之间的连接，或者选择「<emph>插入 - 新关系</emph>」，将弹出「<emph>连接属性</emph>」对话框。这些属性将会被应用在此后创建的所有查询中。" + +#. oszEF +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3155066\n" +"help.text" +msgid "Tables involved" +msgstr "涉及的表格" + +#. 2AkcB +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3153924\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/table2\">Specifies two different tables that you want to join.</ahelp>" +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/table2\">指定要连结的两个表格。</ahelp>" + +#. X6wkD +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3155766\n" +"help.text" +msgid "Fields involved" +msgstr "涉及的字段" + +#. 8bYEZ +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3148994\n" +"help.text" +msgid "<ahelp hid=\".\">Specifies two data fields that will be joined by a relation.</ahelp>" +msgstr "<ahelp hid=\".\">指定将通过关系连接的两个数据字段。</ahelp>" + +#. R8CbB +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3159267\n" +"help.text" +msgid "Options" +msgstr "" + +#. MRJCp +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3147340\n" +"help.text" +msgid "Type" +msgstr "" + +#. rxAGo +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3152482\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types." +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">指定选中连接的连接类型。</ahelp> 某些数据库只支持各可能类型的子集。" + +#. ngfse +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3155334\n" +"help.text" +msgid "Inner Join" +msgstr "内部连接" + +#. 356Dv +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3155936\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">对于内部连接，结果表格只含有其链接字段具有相同内容的记录。</ahelp>在 $[officename] SQL 中，这类链接通过相应的 WHERE 子句创建。" + +#. XYKGT +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3156372\n" +"help.text" +msgid "Left Join" +msgstr "左连接" + +#. dRFux +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3166450\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">对于左连接，结果表格包含左表格查询字段的所有记录，以及右表格查询字段中关联字段内容相同的记录。</ahelp>此类连接对应 $[officename] SQL 中的「LEFT OUTER JOIN」命令。" + +#. DxGWD +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3155607\n" +"help.text" +msgid "Right Join" +msgstr "右连接" + +#. 9eD8R +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3150647\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">对于右连接，结果表格包含右表格查询字段的所有记录，以及左表格查询字段中关联字段内容相同的记录。</ahelp>此类连接对应 $[officename] SQL 中的「RIGHT OUTER JOIN」命令。" + +#. wcFAd +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id3158215\n" +"help.text" +msgid "Full Join" +msgstr "完整连接" + +#. wAFid +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id3163665\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command." +msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">对于完整连接，结果表格含有左、右表格中的所有字段。</ahelp>此类连接对 应$[officename] SQL 中的「FULL OUTER JOIN」命令。" + +#. gYRyC +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"hd_id0305200912031976\n" +"help.text" +msgid "Natural" +msgstr "自然" + +#. 44FEn +#: 02010101.xhp +msgctxt "" +"02010101.xhp\n" +"par_id0305200912031977\n" +"help.text" +msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>" +msgstr "<ahelp hid=\".\">对于自然连接，把关键字 NATURAL 插入到定义关系的 SQL 语句中。该关系把两个表中所有具有相同列名称的列连接起来。生成的连接表对每对命名相同的列都只保留一列。</ahelp>" + #. pK6MV #: 04000000.xhp msgctxt "" @@ -3085,14 +5839,14 @@ msgctxt "" msgid "You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here." msgstr "您只能在此对话框中输入管理命令，如 Grant、Create Table 或 Drop Table，而不能输入筛选命令。可以输入哪些命令取决于数据源。例如，dBASE 只能执行此处列出的这部分 SQL 命令。" -#. JZmCZ +#. zMG8X #: 11080000.xhp msgctxt "" "11080000.xhp\n" "par_id3154860\n" "help.text" -msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design View</link>." -msgstr "" +msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design View</link>." +msgstr "要在数据库中执行筛选数据的 SQL 查询，请使用<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">查询设计视图</link>。" #. Ck9G4 #: 11080000.xhp @@ -7279,41 +10033,41 @@ msgctxt "" msgid "Opens a submenu." msgstr "" -#. EAusx +#. ffiWu #: menufile.xhp msgctxt "" "menufile.xhp\n" "par_idN105F8\n" "help.text" -msgid "Email Document" -msgstr "" +msgid "E-mail Document" +msgstr "通过电子邮件发送文档" -#. Qxg2W +#. XHCkB #: menufile.xhp msgctxt "" "menufile.xhp\n" "par_idN105FC\n" "help.text" -msgid "Opens the default email application to send a new email. The current database file is appended as an attachment. You can enter the subject, the recipients and a mail body." +msgid "Opens the default e-mail application to send a new e-mail. The current database file is appended as an attachment. You can enter the subject, the recipients and a mail body." msgstr "" -#. 9WihT +#. sbEoh #: menufile.xhp msgctxt "" "menufile.xhp\n" "par_idN105FF\n" "help.text" -msgid "Report as Email" -msgstr "" +msgid "Report as E-mail" +msgstr "报表作为电子邮件" -#. XWAoV +#. CrSUL #: menufile.xhp msgctxt "" "menufile.xhp\n" "par_idN10603\n" "help.text" -msgid "<ahelp hid=\".\">Opens the default email application to send a new email. The selected report is appended as an attachment. You can enter the subject, the recipients and a mail body. A dynamic report is exported as a copy of the database contents at the time of export.</ahelp>" -msgstr "" +msgid "<ahelp hid=\".\">Opens the default e-mail application to send a new e-mail. The selected report is appended as an attachment. You can enter the subject, the recipients and a mail body. A dynamic report is exported as a copy of the database contents at the time of export.</ahelp>" +msgstr "<ahelp hid=\".\">打开默认电子邮件应用程序发送新的电子邮件。选中报表被附加为附件。您可以输入主题、收件人和邮件正文。动态报表在导出时作为数据库内容副本导出。</ahelp>" #. 9cSVg #: menufile.xhp @@ -11562,3 +14316,354 @@ msgctxt "" "help.text" msgid "<link href=\"text/shared/explorer/database/tablewizard00.xhp\" name=\"Table Wizard\">Table Wizard</link>" msgstr "<link href=\"text/shared/explorer/database/tablewizard00.xhp\" name=\"表格向导\">表格向导</link>" + +#. PAxTq +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"tit\n" +"help.text" +msgid "Toolbars" +msgstr "工具栏" + +#. BJ5pd +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10541\n" +"help.text" +msgid "<variable id=\"toolbars\"><link href=\"text/shared/explorer/database/toolbars.xhp\">Toolbars</link></variable>" +msgstr "<variable id=\"toolbars\"><link href=\"text/shared/explorer/database/toolbars.xhp\">工具栏</link></variable>" + +#. B3mEW +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10545\n" +"help.text" +msgid "In a database file window, you can see the following toolbars." +msgstr "在数据库文件窗口中，可以看见下列工具栏。" + +#. ZNxCw +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10548\n" +"help.text" +msgid "Table" +msgstr "表格" + +#. JWHfj +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10554\n" +"help.text" +msgid "Open database object" +msgstr "打开数据库对象" + +#. 4fvFG +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10558\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected table so you can enter, edit, or delete records.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中表格，以输入、编辑或删除记录。</ahelp>" + +#. LFKBo +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1056F\n" +"help.text" +msgid "Edit" +msgstr "编辑" + +#. tLLAy +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10573\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected table so you can change the structure.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中表格，以修改结构。</ahelp>" + +#. FEBzp +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1058A\n" +"help.text" +msgid "Delete" +msgstr "删除" + +#. PDZsk +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1058E\n" +"help.text" +msgid "<ahelp hid=\".\">Deletes the selected table.</ahelp>" +msgstr "<ahelp hid=\".\">删除选中表格。</ahelp>" + +#. m7BX3 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105A5\n" +"help.text" +msgid "Rename" +msgstr "重命名" + +#. B596w +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105A9\n" +"help.text" +msgid "<ahelp hid=\".\">Renames the selected table.</ahelp>" +msgstr "<ahelp hid=\".\">重命名选中表格。</ahelp>" + +#. LEWCs +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105B8\n" +"help.text" +msgid "Query" +msgstr "查询" + +#. VT3EG +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105C4\n" +"help.text" +msgid "Open database object" +msgstr "打开数据库对象" + +#. 2cEFv +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105C8\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected query so you can enter, edit, or delete records.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中查询，以输入、编辑或删除记录。</ahelp>" + +#. yVNxZ +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105DF\n" +"help.text" +msgid "Edit" +msgstr "编辑" + +#. kGSTA +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105E3\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected query so you can change the structure.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中查询，以修改结构。</ahelp>" + +#. W75xu +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105FA\n" +"help.text" +msgid "Delete" +msgstr "删除" + +#. XJQBJ +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN105FE\n" +"help.text" +msgid "<ahelp hid=\".\">Deletes the selected query.</ahelp>" +msgstr "<ahelp hid=\".\">删除选中查询。</ahelp>" + +#. bC56u +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10615\n" +"help.text" +msgid "Rename" +msgstr "重命名" + +#. GDAZR +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10619\n" +"help.text" +msgid "<ahelp hid=\".\">Renames the selected query.</ahelp>" +msgstr "<ahelp hid=\".\">重命名选中查询。</ahelp>" + +#. mzY5g +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10628\n" +"help.text" +msgid "Form" +msgstr "表单" + +#. BXrRw +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10634\n" +"help.text" +msgid "Open database object" +msgstr "打开数据库对象" + +#. GJDxB +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10638\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected form so you can enter, edit, or delete records.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中表单，以输入、编辑或删除记录。</ahelp>" + +#. 7f3E9 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1064F\n" +"help.text" +msgid "Edit" +msgstr "编辑" + +#. ZmiNz +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10653\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected form so you can change the layout.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中表单，以修改版式。</ahelp>" + +#. xCBQ3 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1066A\n" +"help.text" +msgid "Delete" +msgstr "删除" + +#. p5bD4 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN1066E\n" +"help.text" +msgid "<ahelp hid=\".\">Deletes the selected form.</ahelp>" +msgstr "<ahelp hid=\".\">删除选中表单。</ahelp>" + +#. Jrqh7 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10685\n" +"help.text" +msgid "Rename" +msgstr "重命名" + +#. CLTV2 +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10689\n" +"help.text" +msgid "<ahelp hid=\".\">Renames the selected form.</ahelp>" +msgstr "<ahelp hid=\".\">重命名选中表单。</ahelp>" + +#. tkXGC +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN10698\n" +"help.text" +msgid "Report" +msgstr "报表" + +#. GMWLb +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106A4\n" +"help.text" +msgid "Open database object" +msgstr "打开数据库对象" + +#. BzwcK +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106A8\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected report so you can enter, edit, or delete records.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中的报表，以输入、编辑或删除记录。</ahelp>" + +#. sLPTD +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106BF\n" +"help.text" +msgid "Edit" +msgstr "编辑" + +#. DF32e +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106C3\n" +"help.text" +msgid "<ahelp hid=\".\">Opens the selected report so you can change the layout.</ahelp>" +msgstr "<ahelp hid=\".\">打开选中报表，以修改版式。</ahelp>" + +#. FGuUB +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106DA\n" +"help.text" +msgid "Delete" +msgstr "删除" + +#. xikUv +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106DE\n" +"help.text" +msgid "<ahelp hid=\".\">Deletes the selected report.</ahelp>" +msgstr "<ahelp hid=\".\">删除选中报表。</ahelp>" + +#. kmUBC +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106F5\n" +"help.text" +msgid "Rename" +msgstr "重命名" + +#. CgE7D +#: toolbars.xhp +msgctxt "" +"toolbars.xhp\n" +"par_idN106F9\n" +"help.text" +msgid "<ahelp hid=\".\">Renames the selected report.</ahelp>" +msgstr "<ahelp hid=\".\">重命名选中报表。</ahelp>" |