path: root/source/zh-TW/helpcontent2/source/text/sdatabase.po

#. extracted from helpcontent2/source/text/sdatabase
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-07-27 13:24+0200\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"X-Accelerator-Marker: ~\n"
"X-Generator: LibreOffice\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 ""

#. g7gAN
#: 02000000.xhp
msgctxt ""
"02000000.xhp\n"
"hd_id3150445\n"
"help.text"
msgid "<link href=\"text/sdatabase/02000000.xhp\" name=\"Queries\">Queries</link>"
msgstr ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. cLmBi
#: main.xhp
msgctxt ""
"main.xhp\n"
"tit\n"
"help.text"
msgid "%PRODUCTNAME Database"
msgstr ""

#. yxuCC
#: main.xhp
msgctxt ""
"main.xhp\n"
"bm_id8622089\n"
"help.text"
msgid "<bookmark_value>databases;main page (Base)</bookmark_value><bookmark_value>$[officename] Base data sources</bookmark_value><bookmark_value>data sources;$[officename] Base</bookmark_value>"
msgstr ""

#. yR4MP
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN10579\n"
"help.text"
msgid "<variable id=\"base\"><link href=\"text/sdatabase/main.xhp\">Using Databases in %PRODUCTNAME Base</link></variable>"
msgstr ""

#. FvcWc
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN107BD\n"
"help.text"
msgid "In %PRODUCTNAME Base, you can access data that is stored in a wide variety of database file formats. %PRODUCTNAME Base natively supports some flat file database formats, such as the dBASE format. You can also use %PRODUCTNAME Base to connect to external relational databases, such as databases from MySQL or Oracle."
msgstr ""

#. RRoXE
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_id5864131\n"
"help.text"
msgid "The following database types are read-only types in %PRODUCTNAME Base. From within %PRODUCTNAME Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:"
msgstr ""

#. uAqcW
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_id8865016\n"
"help.text"
msgid "Spreadsheet files"
msgstr ""

#. U7fFX
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_id3786736\n"
"help.text"
msgid "Text files"
msgstr ""

#. WPAC3
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_id6747337\n"
"help.text"
msgid "Address book data"
msgstr ""

#. TchjD
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN107C0\n"
"help.text"
msgid "Using a Database in %PRODUCTNAME"
msgstr ""

#. cBbKE
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN10838\n"
"help.text"
msgid "To create a new database file, choose <emph>File - New - Database</emph>."
msgstr ""

#. h4EpR
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN1083B\n"
"help.text"
msgid "The <link href=\"text/shared/explorer/database/dabawiz00.xhp\">Database Wizard</link> helps you to create a database file and to register a new database within %PRODUCTNAME."
msgstr ""

#. 2jPWg
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN107E7\n"
"help.text"
msgid "The database file contains queries, reports, and forms for the database as well as a link to the database where the records are stored. Formatting information is also stored in the database file."
msgstr ""

#. 4DEr3
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_idN1084A\n"
"help.text"
msgid "To open a database file, choose <emph>File - Open</emph>. In the <emph>File type</emph> list box, select to view only \"Database documents\". Select a database document and click <emph>Open</emph>."
msgstr ""

#. QFEDB
#: main.xhp
msgctxt ""
"main.xhp\n"
"par_id6474806\n"
"help.text"
msgid "<link href=\"https://wiki.documentfoundation.org/Database\" name=\"wiki.documentfoundation.org Database\">Wiki page about Base</link>"
msgstr ""

#. PAxTq
#: toolbars.xhp
msgctxt ""
"toolbars.xhp\n"
"tit\n"
"help.text"
msgid "Toolbars"
msgstr ""

#. Tzgdb
#: toolbars.xhp
msgctxt ""
"toolbars.xhp\n"
"par_idN10541\n"
"help.text"
msgid "<variable id=\"toolbars\"><link href=\"text/sdatabase/toolbars.xhp\">Toolbars</link></variable>"
msgstr ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""

#. 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 ""