diff options
Diffstat (limited to 'source/zh-CN/helpcontent2/source/text/sdatabase.po')
| -rw-r--r-- | source/zh-CN/helpcontent2/source/text/sdatabase.po | 246 |
1 files changed, 123 insertions, 123 deletions
diff --git a/source/zh-CN/helpcontent2/source/text/sdatabase.po b/source/zh-CN/helpcontent2/source/text/sdatabase.po index 487221a114f..d1f3a6fb357 100644 --- a/source/zh-CN/helpcontent2/source/text/sdatabase.po +++ b/source/zh-CN/helpcontent2/source/text/sdatabase.po @@ -4,16 +4,16 @@ 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: 2022-12-07 19:22+0100\n" -"PO-Revision-Date: 2022-10-22 12:15+0000\n" +"PO-Revision-Date: 2023-11-28 10:51+0000\n" "Last-Translator: 锁琨珑 <suokunlong@126.com>\n" -"Language-Team: Chinese (Simplified) <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/zh_Hans/>\n" +"Language-Team: Chinese (Simplified) <https://translations.documentfoundation.org/projects/libo_help-7-5/textsdatabase/zh_Hans/>\n" "Language: zh-CN\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=1; plural=0;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: LibreOffice\n" +"X-Generator: Weblate 5.1.1\n" #. ugSgG #: 02000000.xhp @@ -364,7 +364,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\".\">如果选择了第一个选项，但在缺少元素的情况下仍然希望在图形视图中打开查询，则可以指定是否忽略其他错误。</ahelp>因此，在当前的打开过程中，如果无法正确解释查询，则不会显示错误消息。" #. E3MVS #: 02010100.xhp @@ -373,7 +373,7 @@ msgctxt "" "tit\n" "help.text" msgid "Query Design" -msgstr "" +msgstr "查询设计" #. Ys2sC #: 02010100.xhp @@ -382,7 +382,7 @@ msgctxt "" "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 "" +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>原生 SQL (Base)</bookmark_value>" #. kJs5m #: 02010100.xhp @@ -400,7 +400,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\".\"><emph>查询设计视图</emph>允许您创建和编辑数据库查询。</ahelp>" #. vGBE5 #: 02010100.xhp @@ -409,7 +409,7 @@ msgctxt "" "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 "" +msgstr "大多数数据库使用查询对数据库表进行筛选或排序，以在计算机上显示记录。视图提供与查询相同的功能，但在服务器端。如果数据库位于支持视图的服务器上，则可以使用视图过滤服务器上的记录，以加快显示时间。" #. WZcUE #: 02010100.xhp @@ -418,7 +418,7 @@ msgctxt "" "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 "" +msgstr "从数据库文档的<emph>表</emph>选项卡页中选择<emph>创建视图</emph>命令，可以看到类似于此处描述的<emph>查询设计</emph>窗口的<emph>视图设计</emph>窗口。" #. JMyC7 #: 02010100.xhp @@ -427,7 +427,7 @@ msgctxt "" "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 "" +msgstr "“查询设计”窗口布局可以储存已创建的查询，但是不能储存已创建的视图。" #. TEBj6 #: 02010100.xhp @@ -436,7 +436,7 @@ msgctxt "" "hd_id3149233\n" "help.text" msgid "The Design View" -msgstr "" +msgstr "设计视图" #. zkTQc #: 02010100.xhp @@ -445,7 +445,7 @@ msgctxt "" "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 "" +msgstr "要创建查询，请在数据库文档中单击<emph>查询</emph>图标，然后在单击<emph>在设计视图中创建查询</emph>。" #. AtAHv #: 02010100.xhp @@ -454,7 +454,7 @@ msgctxt "" "par_id3150255\n" "help.text" msgid "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the criteria 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 "" +msgstr "设计视图的下部窗格是定义查询的位置。要定义查询，请指定要包含的数据库字段名称以及显示字段的条件。要重新排列设计视图下窗格中的列，请将列标题拖动到新位置，或选择该列，然后下<switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+方向键。" #. 74LSC #: 02010100.xhp @@ -472,7 +472,7 @@ msgctxt "" "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 "" +msgstr "如果要测试查询，请双击数据库文档中的查询名称。查询结果显示在与数据源视图类似的表中。注意：显示的表格只是临时的。" #. B4HEH #: 02010100.xhp @@ -481,7 +481,7 @@ msgctxt "" "hd_id8226264\n" "help.text" msgid "Keys in Query Design View" -msgstr "" +msgstr "“查询设计视图”中的键" #. Cvd4o #: 02010100.xhp @@ -490,7 +490,7 @@ msgctxt "" "par_id2341074\n" "help.text" msgid "Key" -msgstr "" +msgstr "键" #. mCy9S #: 02010100.xhp @@ -499,7 +499,7 @@ msgctxt "" "par_id4384289\n" "help.text" msgid "Function" -msgstr "" +msgstr "函数" #. yybiC #: 02010100.xhp @@ -508,7 +508,7 @@ msgctxt "" "par_id5839106\n" "help.text" msgid "F4" -msgstr "" +msgstr "F4" #. FMTZD #: 02010100.xhp @@ -517,7 +517,7 @@ msgctxt "" "par_id8554338\n" "help.text" msgid "Preview" -msgstr "" +msgstr "预览" #. YQhGF #: 02010100.xhp @@ -526,7 +526,7 @@ msgctxt "" "par_id1254921\n" "help.text" msgid "F5" -msgstr "" +msgstr "F5" #. C9yhE #: 02010100.xhp @@ -535,7 +535,7 @@ msgctxt "" "par_id7636646\n" "help.text" msgid "Run Query" -msgstr "" +msgstr "执行查询" #. jdEeJ #: 02010100.xhp @@ -544,7 +544,7 @@ msgctxt "" "par_id8579363\n" "help.text" msgid "F7" -msgstr "" +msgstr "F7" #. 6Y6Uw #: 02010100.xhp @@ -553,7 +553,7 @@ msgctxt "" "par_id3227942\n" "help.text" msgid "Add Table or Query" -msgstr "" +msgstr "添加表或查询" #. WN7wR #: 02010100.xhp @@ -562,7 +562,7 @@ msgctxt "" "hd_id3154939\n" "help.text" msgid "Browse" -msgstr "" +msgstr "浏览" #. 5y4VZ #: 02010100.xhp @@ -571,7 +571,7 @@ msgctxt "" "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 "" +msgstr "第一次打开查询设计时，您会看到一个对话框，其中必须首先选择将作为新查询基础的表或查询。" #. FBQA9 #: 02010100.xhp @@ -580,7 +580,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_CTL_QRYDGNTAB\">双击字段将其添加到查询中。拖放以定义关系。</ahelp>" #. eG8FD #: 02010100.xhp @@ -589,7 +589,7 @@ msgctxt "" "par_id3157894\n" "help.text" msgid "While designing a query, you cannot modify the selected tables." -msgstr "" +msgstr "在设计查询的过程中，您无法修改选定的表。" #. NLywF #: 02010100.xhp @@ -598,7 +598,7 @@ msgctxt "" "hd_id3149562\n" "help.text" msgid "Remove tables" -msgstr "" +msgstr "移除表" #. TbQzA #: 02010100.xhp @@ -607,7 +607,7 @@ msgctxt "" "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 "" +msgstr "要从设计视图中移除表格，请单击表格窗口的上边框并显示关联菜单。可以使用</emph>删除</emph>命令从设计视图中移除表格。另一个选项是按Delete键。" #. VLTKB #: 02010100.xhp @@ -616,7 +616,7 @@ msgctxt "" "hd_id3150012\n" "help.text" msgid "Move table and modify table size" -msgstr "" +msgstr "移动表格并修改表格大小" #. amBsQ #: 02010100.xhp @@ -625,7 +625,7 @@ msgctxt "" "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 "" +msgstr "您可以根据自己的喜好调整表格的大小和排列方式。要移动表格，请将上边框拖动到所需位置。通过将鼠标光标定位在边框或角上并拖动表格直到达到所需大小，放大或缩小表格的显示大小。" #. UoCRG #: 02010100.xhp @@ -634,7 +634,7 @@ msgctxt "" "hd_id3145365\n" "help.text" msgid "Table Relations" -msgstr "" +msgstr "表关系" #. BFCxB #: 02010100.xhp @@ -643,7 +643,7 @@ msgctxt "" "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 "" +msgstr "如果一个表中的字段名与另一个表中的字段名之间存在数据关系，则可以将这些关系用于查询。" #. jcLbE #: 02010100.xhp @@ -652,7 +652,7 @@ msgctxt "" "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 "" +msgstr "例如，如果您有一个由商品编号标识的商品电子表格，以及一个客户电子表格，其中记录了客户使用相应商品编号订购的所有商品，那么这两个“商品编号”数据字段之间存在关系。如果现在要创建一个查询，返回客户订购的所有商品，则必须从两个电子表格中检索数据。为此，您必须将两个电子表格中的数据之间存在的关系通知$[officename]。" #. FspJi #: 02010100.xhp @@ -661,7 +661,7 @@ msgctxt "" "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 "" +msgstr "要执行此操作，请单击表中的字段名称（例如，Customer表中的字段名称“Item Number”），按住鼠标按钮，然后将字段名称拖动到另一个表的字段名称（“Item table中的Item Number”）。松开鼠标按钮时，会出现一条连接两个表窗口之间的两个字段的线。在生成的SQL查询中输入相应的条件，即两个字段名称的内容必须相同。" #. FmAaU #: 02010100.xhp @@ -670,7 +670,7 @@ msgctxt "" "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 "" +msgstr "只有在使用$[officename]作为关系数据库的接口时，才能创建基于多个相关工作表的查询。" #. N2f8q #: 02010100.xhp @@ -679,7 +679,7 @@ msgctxt "" "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 "" +msgstr "不能在查询中访问来自不同数据库的表。涉及多个表的查询只能在一个数据库中创建。" #. nLSiq #: 02010100.xhp @@ -688,7 +688,7 @@ msgctxt "" "hd_id3153279\n" "help.text" msgid "Specifying the relation type" -msgstr "" +msgstr "指定关系类型" #. Js8Ga #: 02010100.xhp @@ -706,7 +706,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">编辑连接属性。</ahelp>或者，按Tab键直到选中该行，然后按Shift+F10显示关联菜单，并在其中选择命令<emph>编辑</emph>。有些数据库只支持可能的联接类型的子集。" #. n3PMB #: 02010100.xhp @@ -715,7 +715,7 @@ msgctxt "" "hd_id3155851\n" "help.text" msgid "Deleting relations" -msgstr "" +msgstr "删除关系" #. jCb4H #: 02010100.xhp @@ -724,7 +724,7 @@ msgctxt "" "par_id3156178\n" "help.text" msgid "To delete a relation between two tables, click the connection line and then press the Delete key." -msgstr "" +msgstr "要删除两个表之间的关系，请单击连接线，然后按delete键。" #. 3UCig #: 02010100.xhp @@ -733,7 +733,7 @@ msgctxt "" "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 "" +msgstr "或者，删除<emph>关系</emph>对话框中<emph>涉及的字段</emph>中的相应条目。或按Tab键，直到连接向量高亮显示，然后按Shift+F10打开关联菜单并选择<emph>删除</emph>命令。" #. pBybB #: 02010100.xhp @@ -742,7 +742,7 @@ msgctxt "" "hd_id3151208\n" "help.text" msgid "Defining the query" -msgstr "" +msgstr "定义查询" #. yGfhU #: 02010100.xhp @@ -751,7 +751,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">选择条件来定义查询。</ahelp>设计表的每一列都接受一个用于查询的数据字段。一行中的条件用布尔AND链接。" #. UB5nG #: 02010100.xhp @@ -760,7 +760,7 @@ msgctxt "" "hd_id3154161\n" "help.text" msgid "Specifying field names" -msgstr "" +msgstr "指定字段名称" #. jyKMG #: 02010100.xhp @@ -769,7 +769,7 @@ msgctxt "" "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 "" +msgstr "首先，从要添加到查询的表中选择所有字段名。可以通过拖放或双击表窗口中的字段名来完成此操作。使用拖放方法，使用鼠标将字段名称从表窗口拖动到查询设计窗口的下部区域。执行此操作时，可以决定查询设计窗口中的哪一列将接收所选字段。也可以通过双击选择字段名称。然后，它将被添加到查询设计窗口中的下一个空闲列中。" #. 66Dcr #: 02010100.xhp @@ -778,7 +778,7 @@ msgctxt "" "hd_id3150750\n" "help.text" msgid "Deleting field names" -msgstr "" +msgstr "删除字段名称" #. AbhrW #: 02010100.xhp @@ -787,7 +787,7 @@ msgctxt "" "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 "" +msgstr "要从查询中删除字段名称，请单击字段的列标题，然后在关联菜单上为该列选择<emph>删除</emph>命令。" #. V92gB #: 02010100.xhp @@ -796,7 +796,7 @@ msgctxt "" "hd_id3155764\n" "help.text" msgid "Saving the query" -msgstr "" +msgstr "保存查询" #. 2kWoA #: 02010100.xhp @@ -805,7 +805,7 @@ msgctxt "" "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 "" +msgstr "使用标准工具栏上的<emph>保存</emph>图标保存查询。您将看到一个对话框，要求您输入查询的名称。如果数据库支持架构，还可以输入架构名称。" #. M9UQL #: 02010100.xhp @@ -814,7 +814,7 @@ msgctxt "" "hd_id3154362\n" "help.text" msgid "Schema" -msgstr "" +msgstr "架构" #. 4Jwm3 #: 02010100.xhp @@ -823,7 +823,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"dbaccess/ui/savedialog/schema\">输入分配给查询或表视图的模式名称。</ahelp>" #. 6Q72c #: 02010100.xhp @@ -832,7 +832,7 @@ msgctxt "" "hd_id3156717\n" "help.text" msgid "Query name or table view name" -msgstr "" +msgstr "查询名称或表视图名称" #. Cw73K #: 02010100.xhp @@ -841,7 +841,7 @@ msgctxt "" "par_id3154253\n" "help.text" msgid "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"dbaccess/ui/savedialog/title\">输入查询或表视图的名称。</ahelp>" #. qgbNu #: 02010100.xhp @@ -850,7 +850,7 @@ msgctxt "" "hd_id3163805\n" "help.text" msgid "Filtering data" -msgstr "" +msgstr "筛选数据" #. Q9pG5 #: 02010100.xhp @@ -859,7 +859,7 @@ msgctxt "" "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 "" +msgstr "要筛选查询数据，请在查询设计窗口的下部区域中设置所需的条件。以下选项可用：" #. xxoMA #: 02010100.xhp @@ -868,7 +868,7 @@ msgctxt "" "hd_id3146916\n" "help.text" msgid "Field" -msgstr "" +msgstr "字段" #. 4KDzZ #: 02010100.xhp @@ -877,7 +877,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">输入查询中引用的数据字段的名称。过滤器选项行中的所有设置都引用此字段。</ahelp>如果您在此处用鼠标单击激活单元格，您将看到一个箭头按钮，可用于选择字段。“Table name.*”选项选择所有数据字段，其效果是指定的条件将应用于所有表字段。" #. Z3pwF #: 02010100.xhp @@ -886,7 +886,7 @@ msgctxt "" "hd_id3145150\n" "help.text" msgid "Alias" -msgstr "" +msgstr "别名" #. EDa3A #: 02010100.xhp @@ -895,7 +895,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">指定别名。查询中将列出此别名，而不是字段名。这样就可以使用用户定义的列标签。</ahelp>例如，如果数据字段名为PtNo，而不是该名称，您希望在查询中显示PartNum，请输入PartNum作为别名。" #. vvWbt #: 02010100.xhp @@ -904,7 +904,7 @@ msgctxt "" "par_id3155959\n" "help.text" msgid "In a SQL statement, aliases are defined as follows:" -msgstr "" +msgstr "在SQL语句中，别名定义如下：" #. CGsBz #: 02010100.xhp @@ -913,7 +913,7 @@ msgctxt "" "par_id3149922\n" "help.text" msgid "SELECT column AS alias FROM table." -msgstr "" +msgstr "从表中选择列作为别名。" #. TWexq #: 02010100.xhp @@ -922,7 +922,7 @@ msgctxt "" "par_id3159335\n" "help.text" msgid "For example:" -msgstr "" +msgstr "示例：" #. roTzi #: 02010100.xhp @@ -931,7 +931,7 @@ msgctxt "" "hd_id3148485\n" "help.text" msgid "Table" -msgstr "" +msgstr "表格" #. GM9Sp #: 02010100.xhp @@ -940,7 +940,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">此处列出了所选数据字段的相应数据库表。</ahelp>如果用鼠标单击激活此单元格，将显示一个箭头，允许您为当前查询选择其他表。" #. JGcfa #: 02010100.xhp @@ -949,7 +949,7 @@ msgctxt "" "hd_id3154207\n" "help.text" msgid "Sort" -msgstr "" +msgstr "排序" #. uXuDt #: 02010100.xhp @@ -958,7 +958,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">如果单击此单元格，可以选择排序选项：升序、降序和未排序。</ahelp>文本字段将按字母顺序和数字字段进行排序。对于大多数数据库，管理员可以在数据库级别设置排序选项。" #. XsqW8 #: 02010100.xhp @@ -967,7 +967,7 @@ msgctxt "" "hd_id3150384\n" "help.text" msgid "Visible" -msgstr "" +msgstr "可见的" #. AAZfA #: 02010100.xhp @@ -976,7 +976,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">如果为数据字段标记<emph>可见</emph>属性，则该字段将在结果查询中可见显示</ahelp>。如果仅使用数据字段来表示条件或进行计算，则不一定需要显示它。" #. eQFRR #: 02010100.xhp @@ -985,7 +985,7 @@ msgctxt "" "hd_id3154714\n" "help.text" msgid "Criteria" -msgstr "" +msgstr "条件" #. fWRgB #: 02010100.xhp @@ -994,7 +994,7 @@ msgctxt "" "par_id3145134\n" "help.text" msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" -msgstr "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">指定筛选数据字段内容的第一个条件。</ahelp>" #. qpADC #: 02010100.xhp @@ -1003,7 +1003,7 @@ msgctxt "" "hd_id3152477\n" "help.text" msgid "or" -msgstr "" +msgstr "或者" #. KFVy8 #: 02010100.xhp @@ -1012,7 +1012,7 @@ msgctxt "" "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 "" +msgstr "在这里，您可以为每一行输入一个额外的过滤条件。单个列中的多个条件将被解释为布尔或。" #. eXvp7 #: 02010100.xhp @@ -1021,7 +1021,7 @@ msgctxt "" "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 "" +msgstr "您还可以使用“查询设计”窗口下部区域中行标题的关联菜单，根据以下函数插入过滤器：" #. 5x8LE #: 02010100.xhp @@ -1030,7 +1030,7 @@ msgctxt "" "hd_id3148419\n" "help.text" msgid "Functions" -msgstr "" +msgstr "函数" #. Cxhjn #: 02010100.xhp @@ -1039,7 +1039,7 @@ msgctxt "" "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 "" +msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">选择要在查询中运行的函数。</ahelp>此处可用的功能取决于数据库引擎提供的功能。" #. qFuqw #: 02010100.xhp @@ -1048,7 +1048,7 @@ msgctxt "" "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 "" +msgstr "如果使用嵌入式HSQL数据库，则<emph>函数</emph>行中的列表框提供以下选项：" #. 9tdDn #: 02010100.xhp @@ -1057,7 +1057,7 @@ msgctxt "" "par_id3150307\n" "help.text" msgid "Option" -msgstr "" +msgstr "选项" #. kBvXF #: 02010100.xhp @@ -1066,7 +1066,7 @@ msgctxt "" "par_id3152993\n" "help.text" msgid "Effect" -msgstr "" +msgstr "影响" #. zCunm #: 02010100.xhp @@ -1075,7 +1075,7 @@ msgctxt "" "par_id3155377\n" "help.text" msgid "No function" -msgstr "" +msgstr "无功能" #. kZMTN #: 02010100.xhp @@ -1084,7 +1084,7 @@ msgctxt "" "par_id3155533\n" "help.text" msgid "No function will be executed." -msgstr "" +msgstr "不会执行任何功能。" #. 6dWZZ #: 02010100.xhp @@ -1093,7 +1093,7 @@ msgctxt "" "par_id3166420\n" "help.text" msgid "Average" -msgstr "" +msgstr "平均值" #. NfRNs #: 02010100.xhp @@ -1102,7 +1102,7 @@ msgctxt "" "par_id3154486\n" "help.text" msgid "Calculates the arithmetic mean of a field." -msgstr "" +msgstr "计算字段的算术平均值。" #. 6z2Kj #: 02010100.xhp @@ -1111,7 +1111,7 @@ msgctxt "" "par_id3149979\n" "help.text" msgid "Count" -msgstr "" +msgstr "计数" #. rvWA5 #: 02010100.xhp @@ -1120,7 +1120,7 @@ msgctxt "" "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 "" +msgstr "确定表中的记录数。空字段可以参与计数（a）或被排除（b）。" #. UyAx2 #: 02010100.xhp @@ -1129,7 +1129,7 @@ msgctxt "" "par_id3151333\n" "help.text" msgid "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." -msgstr "" +msgstr "a) COUNT(*): 传递星号作为参数对表中的所有记录进行计数。" #. FNCC8 #: 02010100.xhp @@ -1138,7 +1138,7 @@ msgctxt "" "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 "" +msgstr "b) COUNT (column)：将字段名作为参数传递仅统计指定字段中包含值的记录。字段值为空（即不包含文本或数字值）的记录将不被统计。" #. 2ubvb #: 02010100.xhp @@ -1147,7 +1147,7 @@ msgctxt "" "par_id3153067\n" "help.text" msgid "Maximum" -msgstr "" +msgstr "最大值" #. ds4ey #: 02010100.xhp @@ -1156,7 +1156,7 @@ msgctxt "" "par_id3159221\n" "help.text" msgid "Determines the highest value of a record for that field." -msgstr "" +msgstr "确定该字段记录的最大值。" #. EhSWy #: 02010100.xhp @@ -1165,7 +1165,7 @@ msgctxt "" "par_id3146866\n" "help.text" msgid "Minimum" -msgstr "" +msgstr "最小值" #. VxmeB #: 02010100.xhp @@ -1174,7 +1174,7 @@ msgctxt "" "par_id3157982\n" "help.text" msgid "Determines the lowest value of a record for that field." -msgstr "" +msgstr "确定该字段记录的最小值。" #. CvkuF #: 02010100.xhp @@ -1183,7 +1183,7 @@ msgctxt "" "par_id3154828\n" "help.text" msgid "Sum" -msgstr "" +msgstr "求和" #. 82gAC #: 02010100.xhp @@ -1192,7 +1192,7 @@ msgctxt "" "par_id3154536\n" "help.text" msgid "Calculates the sum of the values of records for the associated fields." -msgstr "" +msgstr "计算关联字段的记录值之和。" #. zCzVC #: 02010100.xhp @@ -1201,7 +1201,7 @@ msgctxt "" "par_id3148820\n" "help.text" msgid "Group" -msgstr "" +msgstr "分组" #. tSPNG #: 02010100.xhp @@ -1210,7 +1210,7 @@ msgctxt "" "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 "" +msgstr "根据所选字段名称对查询数据分组。根据指定的组执行函数。在SQL中，此选项对应于GROUP BY子句。如果添加了条件，则此条目将出现在SQL HAVING子子句中。" #. qHfpD #: 02010100.xhp @@ -1219,7 +1219,7 @@ msgctxt "" "par_id3156038\n" "help.text" msgid "You can also enter function calls directly into the SQL statement. The syntax is:" -msgstr "" +msgstr "您还可以直接在SQL语句中输入函数调用。语法为：" #. Qg6Ue #: 02010100.xhp @@ -1228,7 +1228,7 @@ msgctxt "" "par_id3156340\n" "help.text" msgid "SELECT FUNCTION(column) FROM table." -msgstr "" +msgstr "SELECT FUNCTION(column) FROM table." #. qAAoF #: 02010100.xhp @@ -1237,7 +1237,7 @@ msgctxt "" "par_id3155075\n" "help.text" msgid "For example, the function call in SQL for calculating a sum is:" -msgstr "" +msgstr "例如，SQL中用于求和的函数调用为：" #. VrHLf #: 02010100.xhp @@ -1246,7 +1246,7 @@ msgctxt "" "par_id3154591\n" "help.text" msgid "SELECT SUM(\"Price\") FROM \"Article\"." -msgstr "" +msgstr "SELECT SUM(\"Price\") FROM \"Article\"." #. dABCo #: 02010100.xhp @@ -1255,7 +1255,7 @@ msgctxt "" "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 "" +msgstr "除了<emph>组合</emph>函数外，上述函数称为聚合函数。这些函数用于计算数据以根据结果创建汇总数。也可以使用列表框中未列出的其他函数。这取决于使用中的特定数据库引擎以及用于连接到该数据库引擎的基本驱动程序提供的当前功能。" #. BVC6J #: 02010100.xhp @@ -1264,7 +1264,7 @@ msgctxt "" "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 "" +msgstr "要使用列表框中未列出的其他功能，必须在<emph>字段</emph>下手动输入。" #. WkboS #: 02010100.xhp @@ -1273,7 +1273,7 @@ msgctxt "" "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 "" +msgstr "还可以为函数调用指定别名。如果不想在列标题中显示查询字符串，请在<emph>别名</emph>下输入所需的替换名称。" #. 98GCC #: 02010100.xhp @@ -1282,7 +1282,7 @@ msgctxt "" "par_id3155539\n" "help.text" msgid "The corresponding function in an SQL statement is:" -msgstr "" +msgstr "SQL语句中对应的函数是：" #. WACG9 #: 02010100.xhp @@ -1291,7 +1291,7 @@ msgctxt "" "par_id3149425\n" "help.text" msgid "SELECT FUNCTION() AS alias FROM table" -msgstr "" +msgstr "SELECT FUNCTION() AS alias FROM table" #. EjzuD #: 02010100.xhp @@ -1300,7 +1300,7 @@ msgctxt "" "par_id3144431\n" "help.text" msgid "Example:" -msgstr "" +msgstr "示例：" #. G9URE #: 02010100.xhp @@ -1309,7 +1309,7 @@ msgctxt "" "par_id3154614\n" "help.text" msgid "SELECT COUNT(*) AS count FROM \"Item\"" -msgstr "" +msgstr "SELECT COUNT(*) AS count FROM \"Item\"" #. xiNnR #: 02010100.xhp @@ -1318,7 +1318,7 @@ msgctxt "" "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 "" +msgstr "如果运行这样的函数，则除了作为“Group”函数中的参数外，不能为查询插入任何其他列。" #. EHACK #: 02010100.xhp @@ -1327,7 +1327,7 @@ msgctxt "" "par_id3154644\n" "help.text" msgid "<emph>Examples</emph>" -msgstr "" +msgstr "<emph>示例</emph>" #. N5CBE #: 02010100.xhp @@ -1336,7 +1336,7 @@ msgctxt "" "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 "" +msgstr "在下列示例中，在两个表之间执行了一个查询：表 \"Item\" 及其 \"Item_No\" 字段，以及表 \"Suppliers\" 及其 \"Supplier_Name\" 字段。另外，两个表中都存在一个共同的字段名：\"Supplier_No\"。" #. P5hJD #: 02010100.xhp @@ -1345,7 +1345,7 @@ msgctxt "" "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 "" +msgstr "要创建包含交付三个以上项目的所有供应商的查询，需要执行以下步骤。" #. ZhRQD #: 02010100.xhp @@ -1354,7 +1354,7 @@ msgctxt "" "par_id3153240\n" "help.text" msgid "Insert the \"Item\" and \"Suppliers\" tables into the query design." -msgstr "" +msgstr "在查询设计中插入“Item”和“Suppliers”表。" #. LMRUV #: 02010100.xhp @@ -1363,7 +1363,7 @@ msgctxt "" "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 "" +msgstr "如果还没有此类关系，请链接两个表的“Supplier_No”字段。" #. qWhFA #: 02010100.xhp @@ -1372,7 +1372,7 @@ msgctxt "" "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 "" +msgstr "双击“Item”表中的“Item_No”字段。使用关联菜单显示<emph>函数</emph>行，然后选择“计数”函数。" #. TgPA2 #: 02010100.xhp @@ -1381,7 +1381,7 @@ msgctxt "" "par_id3151009\n" "help.text" msgid "Enter >3 as a criterion and disable the Visible field." -msgstr "" +msgstr "输入>3作为条件，并禁用“可见的”字段。" #. VwEhF #: 02010100.xhp @@ -1390,7 +1390,7 @@ msgctxt "" "par_id3145601\n" "help.text" msgid "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and choose the Group function." -msgstr "" +msgstr "双击“Suppliers”表中的“Supplier_Name”字段，选择“组合”函数。" #. zsjaa #: 02010100.xhp @@ -1399,7 +1399,7 @@ msgctxt "" "par_id3147512\n" "help.text" msgid "Run the query." -msgstr "" +msgstr "运行查询。" #. EzQsj #: 02010100.xhp @@ -1408,7 +1408,7 @@ msgctxt "" "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 "" +msgstr "如果“Item”表中存在“price”（针对物品的个别价格）和“Supplier_No”（针对物品的供应商）字段，则可以通过以下查询获得供应商提供的物品的平均价格：" #. qAByp #: 02010100.xhp @@ -1417,7 +1417,7 @@ msgctxt "" "par_id3153045\n" "help.text" msgid "Insert the \"Item\" table into the query design." -msgstr "" +msgstr "在查询设计中插入“Item”表。" #. tjfuE #: 02010100.xhp @@ -1426,7 +1426,7 @@ msgctxt "" "par_id3149802\n" "help.text" msgid "Double-click the \"Price\" and \"Supplier_No\" fields." -msgstr "" +msgstr "双击“价格”和“供应商编号”字段。" #. 6dBkt #: 02010100.xhp @@ -1435,7 +1435,7 @@ msgctxt "" "par_id3153554\n" "help.text" msgid "Enable the <emph>Function</emph> line and select the Average function from the \"Price\" field." -msgstr "" +msgstr "启用<emph>函数</emph>行，并从“价格”字段中选择平均值函数。" #. x8JB3 #: 02010100.xhp @@ -1444,7 +1444,7 @@ msgctxt "" "par_id3155597\n" "help.text" msgid "You can also enter \"Average\" in the line for the alias name (without quotation marks)." -msgstr "" +msgstr "您还可以在别名行中输入“Average”（平均值）（不带引号）。" #. D4A9u #: 02010100.xhp @@ -1453,7 +1453,7 @@ msgctxt "" "par_id3151191\n" "help.text" msgid "Choose Group for the \"Supplier_No\" field." -msgstr "" +msgstr "为“Supplier_No”字段选择“组合”。" #. BUYS9 #: 02010100.xhp @@ -1462,7 +1462,7 @@ msgctxt "" "par_id3155547\n" "help.text" msgid "Run the query." -msgstr "" +msgstr "运行查询。" #. EkHzB #: 02010100.xhp |