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

Translation

02000002.xhp par_id3154285 help.text
English tv3MZ
Context English Chinese (Simplified) Actions
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.
02010100.xhp
par_id3159176
help.text
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.
02010100.xhp
par_id8307138
help.text
The Query Design window layout is stored with a created query, but cannot be stored with a created view.
02010100.xhp
hd_id3149233
help.text
The Design View
02010100.xhp
par_id3145673
help.text
To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>.
02010100.xhp
par_id3150255
help.text
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.
02010100.xhp
par_id3152474
help.text
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.
02010100.xhp
par_id3147559
help.text
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.
02010100.xhp
hd_id8226264
help.text
Keys in Query Design View
02010100.xhp
par_id2341074
help.text
Key
02010100.xhp
par_id4384289
help.text
Function
User avatar hxlpdd

Suggestion added

Suggested change:

6 months ago

Loading…

User avatar hxlpdd

Suggestion added

LibreOffice Help - master / text/sdatabaseChinese (Simplified)

6 months ago
Browse all component changes

Things to check

Suggestions

There is 1 suggestion for this string.

View

Glossary

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

String information

Context
02000002.xhp
par_id3154285
help.text
Source string description
tv3MZ
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 39