The translation is temporarily closed for contributions due to maintenance, please come back later.

Translation

02000002.xhp hd_id3145072 help.text
English fBc3m
Context English Chinese (Simplified) Actions
02000000.xhp
par_id3153146
help.text
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. 您也可以打开「数据源」视图(快捷键 Ctrl+Shift+F4),在数据源视图中选择整个数据库表(点击表的左上角),然后将选中内容拖拽到文本文档或电子表格中。
02000000.xhp
hd_id3148946
help.text
<link href="text/shared/main0212.xhp" name="Sorting and Filtering Data">Sorting and Filtering Data</link> <link href="text/shared/main0212.xhp" name="对数据进行排序和筛选">对数据进行排序和筛选</link>
02000000.xhp
par_id3149655
help.text
Allows you to sort and filter the data in a query table. 可以让您对查询表中的数据进行排序和筛选。
02000000.xhp
hd_id3153379
help.text
<link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design</link> <link href="text/sdatabase/02010100.xhp" name="Query Design">查询设计</link>
02000000.xhp
par_id3151211
help.text
With the <emph>Query Design</emph>, you can create and edit a query or view. 您可以使用「<emph>设计查询</emph>」来创建和编辑查询或视图。
02000000.xhp
hd_id3153968
help.text
<link href="text/sdatabase/02010100.xhp" name="Query Through Several Tables">Query Through Several Tables</link> <link href="text/sdatabase/02010100.xhp" name="Query Through Several Tables">在多表之间查询</link>
02000000.xhp
par_id3151043
help.text
The query result can contain data from several tables if these are linked to each other by suitable data fields. 如果多个表之间通过适当的数据字段进行了链接,则查询结果可以包含来自多个表的数据。
02000000.xhp
hd_id3159149
help.text
<link href="text/sdatabase/02010100.xhp" name="Formulating Query Criteria">Formulating Query Criteria</link> <link href="text/sdatabase/02010100.xhp" name="Formulating Query Criteria">制定查询条件</link>
02000000.xhp
par_id3154910
help.text
You can find out which operators and commands can be used to formulate the filter conditions for a query. 您可以找出哪些运算符和命令可用于制定查询的筛选条件。
02000000.xhp
hd_id3156212
help.text
<link href="text/sdatabase/02010100.xhp" name="Executing Functions">Executing Functions</link> <link href="text/sdatabase/02010100.xhp" name="Executing Functions">执行函数</link>
02000000.xhp
par_id3144762
help.text
You can perform calculations with the data of a table and store the results as a query result. 您可以使用表的数据执行计算,并将结果存储为查询结果。
02000002.xhp
tit
help.text
Missing Element 缺少元素
02000002.xhp
bm_id3150445
help.text
<bookmark_value>queries; missing elements (Base)</bookmark_value> <bookmark_value>查询;缺少元素 (Base)</bookmark_value>
02000002.xhp
hd_id3150445
help.text
Missing Element 缺少元素
02000002.xhp
par_id3150247
help.text
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. 如果打开了其中不再存在表或字段的查询,则会出现<emph>缺少元素</emph>对话框。此对话框给出了缺失的表或无法解析的字段的名称,并允许您决定如何继续此过程。
02000002.xhp
hd_id3145072
help.text
How to continue? 如何继续?
02000002.xhp
par_id3149177
help.text
There are three options available for answering this question: 有三个选项可用于回答此问题:
02000002.xhp
hd_id3147576
help.text
Do you really want to open the query in the graphic view? 是否确实要在图形视图中打开查询?
02000002.xhp
par_id3166461
help.text
<ahelp hid=".">Allows you to open the query in the <link href="text/sdatabase/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. <ahelp hid=".">允许您在<link href="text/sdatabase/02010100.xhp" name="Design View">设计视图</link>中打开查询,尽管缺少元素。</ahelp>此选项还允许您指定是否需要忽略其他错误。
02000002.xhp
par_id3153031
help.text
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. 查询将在设计视图(图形界面)中打开。缺少的表显示为空,无效字段在字段列表中显示其(无效)名称。这使您可以准确地处理导致错误的字段。
02000002.xhp
hd_id3149578
help.text
Open the query in the SQL View 在SQL视图中打开查询
02000002.xhp
par_id3159157
help.text
<ahelp hid=".">Allows you to open the query design in the <link href="text/sdatabase/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). <ahelp hid=".">允许您在<link href="text/sdatabase/02010100.xhp" name="SQL Mode">SQL模式</link>中打开查询设计,并将查询解释为<link href="text/shared/02/14030000.xhp" name="Native SQL">原生 SQL</link>。</ahelp>只有当 $[officename] 语句被完全解释时(仅当查询中使用的表或字段确实存在时),才能退出“原生SQL”模式。
02000002.xhp
hd_id3150984
help.text
Do not open the query 不要打开查询
02000002.xhp
par_id3156329
help.text
<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. <ahelp hid=".">允许您取消该过程,并告诉程序不要打开查询。</ahelp>此选项对应的是对话框上<emph>取消</emph>按钮的功能。
02000002.xhp
hd_id3148492
help.text
Also ignore similar errors 同时忽略类似错误
02000002.xhp
par_id3154285
help.text
<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.
02010100.xhp
tit
help.text
Query Design
02010100.xhp
bm_id3153323
help.text
<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>
02010100.xhp
hd_id3153394
help.text
<link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design</link>
02010100.xhp
par_id3156411
help.text
<ahelp hid=".">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>
02010100.xhp
par_id7024140
help.text
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.

Loading…

User avatar suokunlong

Suggestion accepted

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

a month ago
User avatar hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

6 months ago
Browse all component changes

Glossary

English Chinese (Simplified)
No related strings found in the glossary.

String information

Context
02000002.xhp
hd_id3145072
help.text
Source string description
fBc3m
Source string location
02000002.xhp
String age
2 years ago
Source string age
2 years ago
Translation file
zh-CN/helpcontent2/source/text/sdatabase.po, string 29