diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2016-05-07 18:24:54 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2016-05-07 18:26:00 +0200 |
| commit | 4fd90ce7f236732dca67322d4d5a9e0c9f632ea5 (patch) | |
| tree | a80f2ccfe92e9807b8413991fa7529bed28dfb55 /source/zh-TW/helpcontent2/source/text/shared | |
| parent | 0732bbfc5365529452255fc0263416c0455b127b (diff) | |
update translations for master
and force-fix errors using pocheck
Change-Id: I4aa086b8281e7bdce41590d33caaeb79dfdee46d
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/shared')
3 files changed, 12 insertions, 301 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/shared/01.po b/source/zh-TW/helpcontent2/source/text/shared/01.po index 184173b0e1f..78adb27919b 100644 --- a/source/zh-TW/helpcontent2/source/text/shared/01.po +++ b/source/zh-TW/helpcontent2/source/text/shared/01.po @@ -4,17 +4,17 @@ 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: 2016-04-16 21:40+0200\n" -"PO-Revision-Date: 2016-01-12 13:19+0000\n" -"Last-Translator: system user <>\n" +"PO-Revision-Date: 2016-04-17 00:19+0000\n" +"Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: zh_TW\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-Generator: Pootle 2.7\n" "X-Accelerator-Marker: ~\n" -"X-POOTLE-MTIME: 1452604780.000000\n" +"X-Generator: Pootle 2.7\n" +"X-POOTLE-MTIME: 1460852349.000000\n" #: 01010000.xhp msgctxt "" @@ -13640,7 +13640,6 @@ msgid "Comments in spreadsheets" msgstr "試算表中的備註" #: 04050000.xhp -#, fuzzy msgctxt "" "04050000.xhp\n" "par_id3166460\n" @@ -13689,7 +13688,6 @@ msgid "You can also right-click a comment name in the Navigator window to choose msgstr "您也可以在 [助手] 視窗中，於備註名稱上按一下滑鼠右鍵以選擇一些編輯指令。" #: 04050000.xhp -#, fuzzy msgctxt "" "04050000.xhp\n" "par_id3153716\n" @@ -13836,7 +13834,6 @@ msgid "<variable id=\"sonder\"><ahelp hid=\".\">Allows a user to insert characte msgstr "" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "par_id3152372\n" @@ -13845,7 +13842,6 @@ msgid "When you click a character in the <emph>Special Characters </emph>dialog, msgstr "按一下<emph>[特殊字元]</emph>對話方塊中的某個字元時，螢幕上會顯示該字元的預覽以及對應的數字代碼。" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "hd_id3151315\n" @@ -13862,7 +13858,6 @@ msgid "<ahelp hid=\"cui/ui/specialcharacters/fontlb\">Select a font to display t msgstr "" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "hd_id3155555\n" @@ -13871,7 +13866,6 @@ msgid "Subset" msgstr "區域" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "par_id3145090\n" @@ -13880,7 +13874,6 @@ msgid "<ahelp hid=\"cui/ui/specialcharacters/subsetlb\">Select a Unicode categor msgstr "<ahelp hid=\"SVX_LISTBOX_RID_SVXDLG_CHARMAP_LB_SUBSET\">選取目前字型的 Unicode 分類。</ahelp> 所選 Unicode 分類中的特殊字元會顯示在字元表格中。" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "hd_id3145071\n" @@ -13889,7 +13882,6 @@ msgid "Character Table" msgstr "字元選取欄位" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "par_id3154288\n" @@ -13898,7 +13890,6 @@ msgid "<ahelp hid=\"HID_CHARMAP_CTL_SHOWSET\">Click the special character(s) tha msgstr "<ahelp hid=\"HID_CHARMAP_CTL_SHOWSET\">按一下要插入的特殊字元，然後按一下 <emph>[確定]</emph>。</ahelp>" #: 04100000.xhp -#, fuzzy msgctxt "" "04100000.xhp\n" "hd_id3154317\n" @@ -13949,7 +13940,6 @@ msgid "Frame Style" msgstr "建立樣式" #: 04140000.xhp -#, fuzzy msgctxt "" "04140000.xhp\n" "par_id3154398\n" @@ -13958,7 +13948,6 @@ msgid "<ahelp hid=\"HID_FILEOPEN_IMAGE_TEMPLATE\">Select the frame style for the msgstr "<ahelp hid=\"HID_FILEOPEN_IMAGE_TEMPLATE\">選取圖形的框架樣式。</ahelp>" #: 04140000.xhp -#, fuzzy msgctxt "" "04140000.xhp\n" "hd_id3150789\n" @@ -13967,7 +13956,6 @@ msgid "Link" msgstr "連結" #: 04140000.xhp -#, fuzzy msgctxt "" "04140000.xhp\n" "par_id3153750\n" @@ -13976,7 +13964,6 @@ msgid "<ahelp hid=\"HID_FILEDLG_LINK_CB\">Inserts the selected graphic file as a msgstr "<ahelp hid=\"HID_FILEDLG_LINK_CB\">將選取的圖形檔案作為連結插入。</ahelp>" #: 04140000.xhp -#, fuzzy msgctxt "" "04140000.xhp\n" "hd_id3155805\n" @@ -13985,7 +13972,6 @@ msgid "Preview" msgstr "預覽" #: 04140000.xhp -#, fuzzy msgctxt "" "04140000.xhp\n" "par_id3153311\n" @@ -14020,7 +14006,6 @@ msgid "<ahelp hid=\".\">Inserts an embedded object into your document, including msgstr "" #: 04150000.xhp -#, fuzzy msgctxt "" "04150000.xhp\n" "hd_id3153577\n" @@ -14061,7 +14046,6 @@ msgid "<ahelp hid=\".uno:Insert3DModel\">Inserts a 3D models in the glTF format. msgstr "" #: 04150000.xhp -#, fuzzy msgctxt "" "04150000.xhp\n" "hd_id3154894\n" diff --git a/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po b/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po index 396ff31a30a..313a487a2f1 100644 --- a/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po +++ b/source/zh-TW/helpcontent2/source/text/shared/explorer/database.po @@ -4,17 +4,17 @@ 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: 2016-03-09 20:49+0100\n" -"PO-Revision-Date: 2015-12-11 12:47+0000\n" -"Last-Translator: system user <>\n" +"PO-Revision-Date: 2016-04-17 00:19+0000\n" +"Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: zh_TW\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-Generator: Pootle 2.7\n" "X-Accelerator-Marker: ~\n" -"X-POOTLE-MTIME: 1449838033.000000\n" +"X-Generator: Pootle 2.7\n" +"X-POOTLE-MTIME: 1460852349.000000\n" #: 02000000.xhp msgctxt "" @@ -381,7 +381,6 @@ msgid "<bookmark_value>views; creating database views (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>原生 SQL (Base)</bookmark_value>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3153394\n" @@ -390,7 +389,6 @@ msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query De msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"查詢設計\">查詢設計</link>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156411\n" @@ -407,7 +405,6 @@ msgid "Most databases use queries to filter or to sort database tables to displa msgstr "大部分資料庫將使用查詢以篩選或排序資料庫表格來顯示電腦上的顯示記錄。檢視會提供與查詢相同的功能，但只在伺服器端。若您的資料庫位於支援檢視的伺服器上，則您可以使用檢視來篩選伺服器上的記錄以加速顯示時間。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159176\n" @@ -424,7 +421,6 @@ msgid "The Query Design window layout is stored with a created query, but cannot msgstr "[查詢設計] 視窗配置可連同建立的查詢一併起儲存，但無法連同建立的檢視一併儲存。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3149233\n" @@ -433,7 +429,6 @@ msgid "The Design View" msgstr "設計檢視" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145673\n" @@ -451,7 +446,6 @@ msgid "The lower pane of the Design View is where you <link href=\"text/shared/e msgstr "設計檢視的下方窗格是<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"定義\">定義</link>查詢的位置。若要定義查詢，請指定要包括的資料庫<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"欄位名稱\">欄位名稱</link>和用於顯示這些欄位的<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"條件\">條件</link>。若要重新安排設計檢視下方窗格中的欄，請將欄標頭拖曳至新的位置，或選取欄並按 <switchinline select=\"sys\"><caseinline select=\"MAC\">指令</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+方向鍵。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152474\n" @@ -460,7 +454,6 @@ msgid "In the top of the query Design View window, the <link href=\"text/shared/ msgstr "在 [查詢設計檢視] 視窗的上方，會顯示 <emph>[查詢設計]</emph> 列和 <emph>[設計]</emph> 列的<link href=\"text/shared/main0214.xhp\" name=\"圖示\">圖示</link>。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147559\n" @@ -541,7 +534,6 @@ msgid "Add Table or Query" msgstr "新增表格或查詢" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154939\n" @@ -550,7 +542,6 @@ msgid "Browse" msgstr "瀏覽" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148799\n" @@ -559,7 +550,6 @@ msgid "When you open the query design for the first time, in order to create a n msgstr "當您第一次開啟此查詢設計時，為了建立新的查詢，您可以按一下<link href=\"text/shared/02/14020100.xhp\" name=\"[新增表格]\"><emph>[新增表格]</emph></link>。您即可看見一個對話方塊。在此對話方塊中，您必須先選取將要作為此查詢基礎的表格。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3144762\n" @@ -568,7 +558,6 @@ msgid "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the q msgstr "<ahelp hid=\"HID_CTL_QRYDGNTAB\">按兩下欄位可以將其新增到查詢中。拖放以定義關係。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157894\n" @@ -577,7 +566,6 @@ msgid "While designing a query, you cannot modify the selected tables." msgstr "在設計查詢時，您無法修改選取的表格。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3149562\n" @@ -586,7 +574,6 @@ msgid "Remove tables" msgstr "移除表格" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150685\n" @@ -595,7 +582,6 @@ msgid "To remove the table from Design View, click the upper border of the table msgstr "若要從設計檢視移除一張表格，請按一下表格視窗的上邊框，然後呼叫右鍵功能表。利用<emph>「刪除」</emph>指令可將表格從設計檢視中刪除。此外，您也可以按下 (Delete) 鍵。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3150012\n" @@ -604,7 +590,6 @@ msgid "Move table and modify table size" msgstr "移動表格和變更表格大小" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146922\n" @@ -613,7 +598,6 @@ msgid "You can resize and arrange the tables according to your preferences. To m msgstr "您可以隨意排列表格並變更其大小。若要移動表格，則利用滑鼠抓住上邊框，然後拖曳表格到想要的位置。若要放大或縮小表格的顯示，則拖曳邊框或角。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3145365\n" @@ -622,7 +606,6 @@ msgid "Table Relations" msgstr "表格間的關係" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154145\n" @@ -631,7 +614,6 @@ msgid "If there are data relations between a field name in one table and a field msgstr "如果一張表格中的資料欄位與另一張表格中的資料欄位有資料上的關聯，那麼您可以將這些關係用於查詢。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152577\n" @@ -640,7 +622,6 @@ msgid "If, for example, you have a spreadsheet for articles identified by an art msgstr "例如，如果您具有透過商品號碼識別的商品的試算表，以及透過對應的商品號碼記錄了客戶訂購的全部商品的客戶試算表，則在這兩個「商品號碼」資料欄位之間就存在關係。現在，如果要建立返回客戶訂購的所有商品的查詢，您必須從兩個試算表文件中擷取資料。若要如此，您必須告知 $[officename] 這兩個試算表中的資料所存在的關係。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155302\n" @@ -649,7 +630,6 @@ msgid "To do this, click a field name in a table (for example, the field name \" msgstr "按一下表格的資料欄位 (例如，客戶表中的「商品編號」資料欄位) 然後按住滑鼠鍵拖曳到另一個表格的資料欄位上 (商品表的「商品編號」)。當您現在放開滑鼠鍵時，便會看到一條線，連接兩個視窗中的兩個欄位。在產生結果的 SQL 查詢中會輸入對應的條件，指定兩個資料欄位的內容必須相同。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153876\n" @@ -658,7 +638,6 @@ msgid "The creation of a query that is based on several related sheets is only p msgstr "只有在當您將 $[officename] 用作關係資料庫的介面時，才可能基於數個相關的試算表建立查詢。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145646\n" @@ -667,7 +646,6 @@ msgid "You cannot access tables from different databases in a query. Queries inv msgstr "在查詢中，您無法從不同的資料庫中存取多個表格。涉及多個表格的查詢僅能在一個資料庫中建立。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3153279\n" @@ -676,7 +654,6 @@ msgid "Specifying link type" msgstr "設定連結類型" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154791\n" @@ -685,7 +662,6 @@ msgid "If you double-click the line connecting two linked fields or call the men msgstr "如果您連按兩下連結兩個欄位的線條，或呼叫功能表指令<emph>[插入] - [新增關係]</emph>，您就可以在<link href=\"text/shared/explorer/database/02010101.xhp\" name=\"[關係]\"><emph>[關係]</emph></link>對話方塊中指定連結的類型。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150094\n" @@ -694,7 +670,6 @@ msgid "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit J msgstr "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">編輯連結特性。</ahelp>或者，按 Tab 鍵直到選取該行，然後按 Shift+F10 組合鍵顯示右鍵功能表，並在此處選擇 <emph>[編輯]</emph> 指令。某些資料庫只支援可能連結類型的子集。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3155851\n" @@ -703,7 +678,6 @@ msgid "Deleting relations" msgstr "刪除關聯" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156178\n" @@ -712,7 +686,6 @@ msgid "To delete a relation between two tables, click the connection line and th msgstr "如果您要刪除兩個表格之間的關聯，則按一下連結線，然後按下 (Delete) 鍵。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150715\n" @@ -721,7 +694,6 @@ msgid "Alternatively, delete the respective entries in <emph>Fields involved </e msgstr "或者，刪除<emph>[關係]</emph>對話方塊的<emph>[使用欄位]</emph>中相應的條目。或按住 TAB 鍵直到突出顯示此連結向量，然後按 SHIFT+F10 組合鍵開啟右鍵功能表，並選取<emph>[刪除]</emph>指令。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3151208\n" @@ -730,7 +702,6 @@ msgid "Define query" msgstr "定義查詢" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3158416\n" @@ -739,7 +710,6 @@ msgid "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.< msgstr "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">選取定義查詢的條件。</ahelp> 設計表格的每欄都接受用於查詢的資料欄位。同一列中的條件會以布林值 AND 連結。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154161\n" @@ -748,7 +718,6 @@ msgid "Specify field name" msgstr "設定資料欄位" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146791\n" @@ -757,7 +726,6 @@ msgid "First, select all field names from the tables that you want to add to the msgstr "首先，從表格中選取要加入此查詢的所有欄位的名稱。拖放表格視窗中的欄位名稱，或將其按兩下，都可達到這一目的。拖放方法，就是使用滑鼠將欄位名稱從表格視窗拖到此查詢設計的下方區域中。拖放時，您可以決定要將此欄位加入哪個欄中。透過按兩下來選取欄位名稱，即可將其加入下一個空白欄中。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3150750\n" @@ -766,7 +734,6 @@ msgid "Deleting field names" msgstr "刪除資料欄位" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154479\n" @@ -775,7 +742,6 @@ msgid "To remove a field name from the query, click the column header of the fie msgstr "如果您要刪除查詢中的某個資料欄位，則以滑鼠按一下欄位的欄標題，然後呼叫欄的右鍵功能表中的指令<emph>「刪除」</emph>。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3155764\n" @@ -784,7 +750,6 @@ msgid "Save query" msgstr "儲存查詢" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148481\n" @@ -793,7 +758,6 @@ msgid "Use the <emph>Save</emph> icon on the Standard Bar to save the query. You msgstr "使用 [標準] 列上的<emph>儲存</emph>圖示來儲存此查詢。您會看見一個對話方塊，要求您輸入查詢的名稱。如果資料庫支援概要，您也可以輸入概要。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154362\n" @@ -802,7 +766,6 @@ msgid "Schema" msgstr "略圖" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154754\n" @@ -811,7 +774,6 @@ msgid "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema msgstr "<ahelp hid=\"dbaccess/ui/savedialog/schema\">輸入已指定給查詢或表格檢視的模式名稱。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3156717\n" @@ -820,7 +782,6 @@ msgid "Query name or table view name" msgstr "查詢 / 表格檢視的名稱" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154253\n" @@ -829,7 +790,6 @@ msgid "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query o msgstr "<ahelp hid=\"dbaccess/ui/savedialog/title\">輸入查詢或表格檢視的名稱。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3163805\n" @@ -838,7 +798,6 @@ msgid "Filtering data" msgstr "資料的篩選" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154964\n" @@ -847,7 +806,6 @@ msgid "To filter data for the query, set the desired preferences in the lower ar msgstr "若要篩選此查詢的資料，請在設計檢視的下方區域中設定所需的偏好。下列行可用：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3146916\n" @@ -856,7 +814,6 @@ msgid "Field" msgstr "欄位" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156372\n" @@ -865,7 +822,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">輸入您在此查詢中所參照資料欄位的名稱。在下方的列中所做的所有設定都參照此欄位。</ahelp>如果您透過按一下滑鼠來啟動儲存格，您將看見一個箭頭按鈕，您可以使用該按鈕選取欄位。「Table name.*」選項選取所有的資料欄位，此條件對於所有的表格欄位都有效。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3145150\n" @@ -874,7 +830,6 @@ msgid "Alias" msgstr "別名" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146315\n" @@ -883,7 +838,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will b msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">指定別名。查詢中將列出此別名，而不是欄位名稱。如此將使其能夠使用使用者定義的欄標籤。</ahelp>例如，如果資料欄位已經擁有名稱 PtNo（而非該名稱），而您希望查詢中出現 PartNum，請將 PartNum 輸入為別名。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155959\n" @@ -892,7 +846,6 @@ msgid "In an SQL statement, aliases are defined as following:" msgstr "在 SQL 陳述式中，代用名設定如下：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149922\n" @@ -901,7 +854,6 @@ msgid "SELECT column AS alias FROM table." msgstr "SELECT column AS alias FROM table。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159335\n" @@ -910,7 +862,6 @@ msgid "For example:" msgstr "例如：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148478\n" @@ -919,7 +870,6 @@ msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" msgstr "SELECT \"商品 No.\" AS 商品編號 FROM \"商品\"" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3148485\n" @@ -928,7 +878,6 @@ msgid "Table" msgstr "表格" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3163665\n" @@ -937,7 +886,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of t msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">在此將列出與所選資料欄位對應的資料庫表格。</ahelp>如果您透過按一下滑鼠來啟動儲存格，則會出現一個箭頭，使用它您可以選取目前查詢中的另一個表格。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154207\n" @@ -946,7 +894,6 @@ msgid "Sort" msgstr "排序" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150979\n" @@ -955,7 +902,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click the cell, you can select msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">如果您按一下此儲存格，可以在排序選項中進行選取：向上、向下和不排序。</ahelp>文字欄位將依字母順序排序，而數字欄位將依數字順序排序。管理員可設定大部分資料庫的排序選項。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3150384\n" @@ -964,7 +910,6 @@ msgid "Visible" msgstr "顯示的" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146133\n" @@ -973,7 +918,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">如果您將資料欄位標示為 <emph>[可見的]</emph> 特性，該欄位在查詢中將會是可見狀態</ahelp>。如果您僅使用資料欄位來建立條件，您不一定需要顯示它。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154714\n" @@ -982,7 +926,6 @@ msgid "Criteria" msgstr "條件" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145134\n" @@ -991,7 +934,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies the <link href=\"text/shared msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">指定篩選資料欄位內容的<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"條件\">條件</link>。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3152477\n" @@ -1000,7 +942,6 @@ msgid "or" msgstr "或" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154585\n" @@ -1009,7 +950,6 @@ msgid "Here you can enter one additional criterion for filtering in each line. M msgstr "您可以在此於每一列中輸入用於篩選的另一個條件。欄中的許多條件會以 OR 連結。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148800\n" @@ -1018,7 +958,6 @@ msgid "You can also use the context menu of the line headers in the lower area o msgstr "此外，您可以透過列標題的右鍵功能表於查詢設計下方區域中，再插入用於功能的一列：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3148419\n" @@ -1027,7 +966,6 @@ msgid "Functions" msgstr "功能" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153233\n" @@ -1044,7 +982,6 @@ msgid "If you are working with the HSQL database, the list box in the <emph>Func msgstr "若正使用 HSQL 資料庫，則<emph>功能</emph>列中的清單方塊將提供您以下選項：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150307\n" @@ -1053,7 +990,6 @@ msgid "Option" msgstr "<emph>選項</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3166430\n" @@ -1062,7 +998,6 @@ msgid "SQL" msgstr "執行 SQL" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152993\n" @@ -1071,7 +1006,6 @@ msgid "Effect" msgstr "<emph>作用</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155377\n" @@ -1080,7 +1014,6 @@ msgid "No function" msgstr "無函數" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155533\n" @@ -1089,7 +1022,6 @@ msgid "No function will be executed." msgstr "將不會執行任何函數。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3166420\n" @@ -1098,7 +1030,6 @@ msgid "Average" msgstr "平均值" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145268\n" @@ -1107,7 +1038,6 @@ msgid "AVG" msgstr "AVG" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154486\n" @@ -1116,7 +1046,6 @@ msgid "Calculates the arithmetic mean of a field." msgstr "計算欄位的直線平均值。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149979\n" @@ -1125,7 +1054,6 @@ msgid "Count" msgstr "數目" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154260\n" @@ -1134,7 +1062,6 @@ msgid "COUNT" msgstr "COUNT" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155810\n" @@ -1143,7 +1070,6 @@ msgid "Determines the number of records in the table. Empty fields can either be msgstr "決定表格中的資料條目數。空欄位的數目可以計數 (a) 或不計數 (b)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151333\n" @@ -1152,7 +1078,6 @@ msgid "a) COUNT(*): Passing an asterisk as the argument counts all records in th msgstr "a) COUNT(*)：如果您代入星號作為自變數，則會計算表格的所有資料條目。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152889\n" @@ -1161,7 +1086,6 @@ msgid "b) COUNT(column): Passing a field name as an argument counts only fields msgstr "b) COUNT(column)：如果您代入資料欄位作為自變數，則只會計算其中每個資料欄位包含一個值的欄位。在此零值 (空欄位) 不會計入。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153067\n" @@ -1170,7 +1094,6 @@ msgid "Maximum" msgstr "最大值" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148840\n" @@ -1179,7 +1102,6 @@ msgid "MAX" msgstr "MAX" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159221\n" @@ -1188,7 +1110,6 @@ msgid "Determines the highest value of a field." msgstr "計算出某個欄位的最高值。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146866\n" @@ -1197,7 +1118,6 @@ msgid "Minimum" msgstr "最小值" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148604\n" @@ -1206,7 +1126,6 @@ msgid "MIN" msgstr "MIN" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157982\n" @@ -1215,7 +1134,6 @@ msgid "Determines the lowest value of a field." msgstr "計算出某個欄位的最低值。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154828\n" @@ -1224,7 +1142,6 @@ msgid "Sum" msgstr "總計" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147070\n" @@ -1233,7 +1150,6 @@ msgid "SUM" msgstr "SUM" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154536\n" @@ -1242,7 +1158,6 @@ msgid "Calculates the sum of values of associated fields." msgstr "計算所屬欄位值的總計。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148820\n" @@ -1251,7 +1166,6 @@ msgid "Group" msgstr "群組" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145375\n" @@ -1260,7 +1174,6 @@ msgid "GROUP BY" msgstr "GROUP BY" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149438\n" @@ -1269,7 +1182,6 @@ msgid "Groups query data according to the field name selected. Functions are exe msgstr "依據選取的欄位名稱，分組查詢資料。函數依據指定的群組執行。在 SQL 中，此選項對應於 GROUP BY 子句。如果加入規則，此條目會出現在 SQL HAVING 中。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156038\n" @@ -1278,7 +1190,6 @@ msgid "You can also enter function calls directly into the SQL statement. The sy msgstr "您也可以在 SQL 陳述式中直接輸入函數呼叫。其語法是：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156340\n" @@ -1287,7 +1198,6 @@ msgid "SELECT FUNCTION(column) FROM table." msgstr "SELECT FUNCTION(column) FROM table。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155075\n" @@ -1296,7 +1206,6 @@ msgid "For example, the function call in SQL for calculating a sum is:" msgstr "在 SQL 中，計算總計的功能呼叫範例為：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154591\n" @@ -1305,7 +1214,6 @@ msgid "SELECT SUM(\"Price\") FROM \"Article\"." msgstr "SELECT SUM(\"價格\") FROM \"商品\"。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159205\n" @@ -1314,7 +1222,6 @@ msgid "Except for the <emph>Group</emph> function, the above functions are so-ca msgstr "除了<emph>「群組」</emph>功能外，上述功能均關係到所謂的「集合」功能。這些功能即為透過計算資料從結果建立摘要的功能。其它未列於清單方塊中的功能亦可使用。這些功能視您所使用的特定資料庫系統以及 Base 驅動程式目前的狀態而定。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148651\n" @@ -1323,7 +1230,6 @@ msgid "To use other functions not listed in the list box, you must enter them un msgstr "若要使用清單方塊中未列出的其他功能，您必須在 <emph>[欄位]</emph> 下輸入這些功能。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155098\n" @@ -1332,7 +1238,6 @@ msgid "You can also assign aliases to function calls. If the query is not to be msgstr "您同樣可以為功能呼叫配上代用名。如果在欄標題中查詢不應顯示為功能名稱，則在<emph>「別名」</emph>下輸入所要的名稱。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155539\n" @@ -1341,7 +1246,6 @@ msgid "The corresponding function in an SQL statement is:" msgstr "在 SQL 陳述式中對應的功能呼叫為：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149425\n" @@ -1350,7 +1254,6 @@ msgid "SELECT FUNCTION() AS alias FROM table" msgstr "SELECT FUNCTION() AS alias FROM table" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3144431\n" @@ -1359,7 +1262,6 @@ msgid "Example:" msgstr "範例：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154614\n" @@ -1368,7 +1270,6 @@ msgid "SELECT COUNT(*) AS count FROM \"Item\"" msgstr "SELECT COUNT(*) AS 數目 FROM \"商品\"" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154610\n" @@ -1377,7 +1278,6 @@ msgid "If you run this function, you cannot insert any additional columns for th msgstr "當您執行一個功能時，您可以不必為查詢插入其他欄，除非這些欄位是當作「群組」功能取得。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154644\n" @@ -1386,7 +1286,6 @@ msgid "<emph>Examples</emph>" msgstr "<emph>範例</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151120\n" @@ -1395,7 +1294,6 @@ msgid "In the following example, a query is run through two tables: an \"Item\" msgstr "下列範例中，將執行關於兩個表格的查詢：一個內含「商品_No」欄位的「商品」表和一個內含「供應商_名稱」欄位的「供應商」表格。此外，這兩個表格擁有一個共同欄位「供應商_No」。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155144\n" @@ -1404,7 +1302,6 @@ msgid "The following steps are required to create a query containing all supplie msgstr "若要建立包括所有供應超過三種商品以上的供應商的查詢，則須執行下列步驟：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153240\n" @@ -1413,7 +1310,6 @@ msgid "Insert the \"Item\" and \"Suppliers\" tables into the query design." msgstr "將「商品」和「供應商」兩個表格插入查詢設計中。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148807\n" @@ -1422,7 +1318,6 @@ msgid "Link the \"Supplier_No\" fields of the two tables if there is not already msgstr "連結兩個表格的「供應商_No」，如果兩張表格之間尚未擁有適當的關聯。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3161652\n" @@ -1431,7 +1326,6 @@ msgid "Double-click the \"Item_No\" field from the \"Item\" table. Display the < msgstr "按兩下「商品」表中的「商品_No」欄位。透過右鍵功能表顯示<emph>「功能」</emph>列，並選取「數目」功能。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151009\n" @@ -1440,7 +1334,6 @@ msgid "Enter >3 as a criterion and disable the Visible field." msgstr "輸入「>3」作為條件，並關閉「顯示」欄位。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145601\n" @@ -1449,7 +1342,6 @@ msgid "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and c msgstr "按兩下「供應商」表格中的「供應商_名稱」欄位，然後選取「群組」功能。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147512\n" @@ -1458,7 +1350,6 @@ msgid "Run the query." msgstr "執行查詢。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148638\n" @@ -1467,7 +1358,6 @@ msgid "If the \"price\" (for the individual price of an article) and \"Supplier_ msgstr "當「商品」表中出現「價格」(商品的單價) 和「供應商_No」(商品的供應商) 這兩個欄位時，您可以利用下列查詢某個供應商所提供商品的平均價格：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153045\n" @@ -1476,7 +1366,6 @@ msgid "Insert the \"Item\" table into the query design." msgstr "將「商品」表插入查詢設計中。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149802\n" @@ -1485,7 +1374,6 @@ msgid "Double-click the \"Price\" and \"Supplier_No\" fields." msgstr "按兩下「價格」和「供應商_No」欄位。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153554\n" @@ -1494,7 +1382,6 @@ msgid "Enable the <emph>Function</emph> line and select the Average function fro msgstr "啟動<emph>「功能」</emph>列，並於「價格」欄位中選擇「平均值」功能。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155597\n" @@ -1503,7 +1390,6 @@ msgid "You can also enter \"Average\" in the line for the alias name (without qu msgstr "依喜好在列中填入代用名「平均值」(不含引號)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151191\n" @@ -1512,7 +1398,6 @@ msgid "Choose Group for the \"Supplier_No\" field." msgstr "在「供應商_No」欄位中選擇群組。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155547\n" @@ -1521,7 +1406,6 @@ msgid "Run the query." msgstr "執行查詢。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147549\n" @@ -1530,7 +1414,6 @@ msgid "The following context menu commands and symbols are available:" msgstr "下列右鍵功能表指令和圖示可供使用：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3154172\n" @@ -1539,7 +1422,6 @@ msgid "Functions" msgstr "功能" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150414\n" @@ -1548,7 +1430,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for selection msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">顯示或隱藏功能選取的列。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3149872\n" @@ -1557,7 +1438,6 @@ msgid "Table Name" msgstr "表格名稱" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147246\n" @@ -1566,7 +1446,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the tab msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">顯示或隱藏表格名稱的列。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3145117\n" @@ -1575,7 +1454,6 @@ msgid "Alias Name" msgstr "代用名" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155754\n" @@ -1584,7 +1462,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the ali msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">顯示或隱藏別名的列。</ahelp>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3153298\n" @@ -1593,7 +1470,6 @@ msgid "Distinct Values" msgstr "明確的數值" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147500\n" @@ -1602,7 +1478,6 @@ msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applies only distinct values to th msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">僅將明確的數值套用至查詢。</ahelp>這適用於其資料在所選欄位中數次出現的記錄。如果已啟動 <emph>[明確的數值]</emph> 指令，您僅能在查詢 (DISTINCT) 中看到一條記錄。否則，您將看到對應於查詢條件 (ALL) 的全部記錄。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150436\n" @@ -1611,7 +1486,6 @@ msgid "For example, if the name \"Smith\" occurs several times in your address d msgstr "例如，如果名稱「Smith」多次出現在地址資料庫中，您可以選擇<emph>[明確的數值]</emph>指令，在查詢中指定名稱「Smith」僅出現一次。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152352\n" @@ -1620,7 +1494,6 @@ msgid "For a query involving several fields, the combination of values from all msgstr "對於涉及數個欄位的查詢，所有欄位數值的組合必須是唯一的，以便可以從特定的資料條目中形成結果。例如，在通訊錄中出現一次「Smith in Chicago」，兩次「Smith in London」。透過<emph>[明確的數值]</emph>指令，此查詢將使用兩個欄位「last name」和「city」，並返回查詢結果「Smith in Chicago」一次和「Smith in London」一次。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149825\n" @@ -1653,7 +1526,6 @@ msgid "If there is added a <emph>Limit</emph>, you will get at most as many rows msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3148926\n" @@ -1662,7 +1534,6 @@ msgid "Formulating filter conditions" msgstr "建立篩選條件" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153162\n" @@ -1671,7 +1542,6 @@ msgid "When formulating filter conditions, various operators and commands are av msgstr "當建立篩選條件時，您可以使用各種運算子和指令。除可使用關係運算子外，還可使用查詢資料庫欄位內容的 SQL 特定指令。如果您按 $[officename] 語法使用這些指令，$[officename] 會自動將它們轉換為對應的 SQL 語法。您也可以直接輸入 SQL 指令。以下表格給出了這些運算子和指令的摘要：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149044\n" @@ -1680,7 +1550,6 @@ msgid "Operator" msgstr "運算子" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152471\n" @@ -1689,7 +1558,6 @@ msgid "Meaning" msgstr "<emph>涵義</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147407\n" @@ -1706,7 +1574,6 @@ msgid "=" msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153026\n" @@ -1715,7 +1582,6 @@ msgid "equal to" msgstr "相等" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148895\n" @@ -1724,7 +1590,6 @@ msgid "... the content of the field is identical to the indicated expression." msgstr "... 欄位內容與指定的表示式等同。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153120\n" @@ -1733,7 +1598,6 @@ msgid "The operator = will not be displayed in the query fields. If you enter a msgstr "運算子 <emph>=</emph> 不會在查詢欄位中顯示；如果您輸入一個不帶運算子的值，便會接受運算子 <emph>=</emph>。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150470\n" @@ -1742,7 +1606,6 @@ msgid "<>" msgstr "<>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145223\n" @@ -1751,7 +1614,6 @@ msgid "not equal to" msgstr "不等於" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145635\n" @@ -1769,7 +1631,6 @@ msgid ">" msgstr ">" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146815\n" @@ -1778,7 +1639,6 @@ msgid "greater than" msgstr "大於" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149150\n" @@ -1796,7 +1656,6 @@ msgid "<" msgstr "<" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147379\n" @@ -1805,7 +1664,6 @@ msgid "less than" msgstr "小於" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150375\n" @@ -1814,7 +1672,6 @@ msgid "... the content of the field is less than the specified expression." msgstr "... 欄位內容小於指定的表示式。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149787\n" @@ -1823,7 +1680,6 @@ msgid ">=" msgstr ">=" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150636\n" @@ -1832,7 +1688,6 @@ msgid "greater than or equal to" msgstr "大於或等於" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154584\n" @@ -1841,7 +1696,6 @@ msgid "... the content of the field is greater than or equal to the specified ex msgstr "... 欄位內容大於或等於指定的表示式。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157964\n" @@ -1850,7 +1704,6 @@ msgid "<=" msgstr "<=" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154052\n" @@ -1859,7 +1712,6 @@ msgid "less than or equal to" msgstr "小於或等於" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157902\n" @@ -1868,7 +1720,6 @@ msgid "... the content of the field is less than or equal to the specified expre msgstr "... 欄位內容小於或等於指定的表示式。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154630\n" @@ -1877,7 +1728,6 @@ msgid "$[officename] command" msgstr "<emph>$[officename] 指令</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150484\n" @@ -1886,7 +1736,6 @@ msgid "SQL command" msgstr "<emph>SQL 指令</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154158\n" @@ -1895,7 +1744,6 @@ msgid "Meaning" msgstr "<emph>涵義</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149433\n" @@ -1904,7 +1752,6 @@ msgid "Condition is satisfied if..." msgstr "<emph>條件滿足，如果...</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154275\n" @@ -1913,7 +1760,6 @@ msgid "IS EMPTY" msgstr "ISBLANK" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149893\n" @@ -1922,7 +1768,6 @@ msgid "IS NULL" msgstr "IS NULL" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3143236\n" @@ -1931,7 +1776,6 @@ msgid "is null" msgstr "是空缺" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154744\n" @@ -1940,7 +1784,6 @@ msgid "... The field name is empty. For Yes/No fields with three states, this co msgstr "... 資料欄位是空白的。在具有三種情況的「是/否」欄位中，這個指令會查詢不確定的情形 (非「是」亦非「否」)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146940\n" @@ -1949,7 +1792,6 @@ msgid "IS NOT EMPTY" msgstr "IS NOT NULL" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147471\n" @@ -1958,7 +1800,6 @@ msgid "IS NOT NULL" msgstr "IS NOT NULL" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151229\n" @@ -1967,7 +1808,6 @@ msgid "is not empty" msgstr "不是空缺" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145304\n" @@ -1976,7 +1816,6 @@ msgid "... the field name is not empty." msgstr "... 資料欄位不是空缺。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153578\n" @@ -1985,7 +1824,6 @@ msgid "LIKE" msgstr "LIKE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153891\n" @@ -1994,7 +1832,6 @@ msgid "(placeholder * for any number of characters" msgstr "(萬用字元 * 可用於任意數目的字元" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148887\n" @@ -2003,7 +1840,6 @@ msgid "placeholder ? for exactly one character)" msgstr "萬用字元 ? 僅用於一個字元)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148623\n" @@ -2020,7 +1856,6 @@ msgid "<bookmark_value>placeholders; in SQL queries</bookmark_value>" msgstr "<bookmark_value>SQL 查詢中的預留位置</bookmark_value>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157985\n" @@ -2029,7 +1864,6 @@ msgid "(% placeholder for any number of characters" msgstr "(% 萬用字元表示任意數目的字元" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147422\n" @@ -2038,7 +1872,6 @@ msgid "Placeholder _ for exactly one character)" msgstr "萬用字元 _ 僅用於一個字元)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154845\n" @@ -2047,7 +1880,6 @@ msgid "is an element of" msgstr "為組成部分" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156130\n" @@ -2056,7 +1888,6 @@ msgid "... the data field contains the indicated expression. The (*) placeholder msgstr "... 資料欄位含有指定的表示式。在此萬用字元 (*) 指定表示式 x 要出現在開頭 (x*)、在尾端 (*x) 或於欄位內容中 (*x*)。您可以在 SQL 查詢中輸入 SQL 字元 % 作為萬用字元，在 $[officename] 平面則輸入檔案系統所熟悉的萬用字元 (*)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150271\n" @@ -2065,7 +1896,6 @@ msgid "The * or % placeholder stands for any number of characters. The question msgstr "萬用字元 * 或 % 表示任意數目的字元。針對僅一個字元則可在 $[officename] 平面中使用問號 (?) 或於 SQL 查詢中使用底線 (_) 當作萬用字元。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152954\n" @@ -2074,7 +1904,6 @@ msgid "NOT LIKE" msgstr "NOT LIKE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3161669\n" @@ -2083,7 +1912,6 @@ msgid "NOT LIKE" msgstr "NOT LIKE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159141\n" @@ -2092,7 +1920,6 @@ msgid "Is not an element of" msgstr "不是組成部分" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3161664\n" @@ -2101,7 +1928,6 @@ msgid "... the field name does not contain the specified expression." msgstr "... 資料欄位不包含指定的表示式。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149185\n" @@ -2110,7 +1936,6 @@ msgid "BETWEEN x AND y" msgstr "BETWEEN x AND y" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151259\n" @@ -2119,7 +1944,6 @@ msgid "BETWEEN x AND y" msgstr "BETWEEN x AND y" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159184\n" @@ -2128,7 +1952,6 @@ msgid "falls within the interval [x,y]" msgstr "介於區間 [x,y]" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154395\n" @@ -2137,7 +1960,6 @@ msgid "... the field name contains a value that lies between the two values x an msgstr "... 資料欄位包含一個介於 x 和 y 兩者之間的數值。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154561\n" @@ -2146,7 +1968,6 @@ msgid "NOT BETWEEN x AND y" msgstr "NOT BETWEEN x AND y" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148753\n" @@ -2155,7 +1976,6 @@ msgid "NOT BETWEEN x AND y" msgstr "NOT BETWEEN x AND y" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155498\n" @@ -2164,7 +1984,6 @@ msgid "Does not fall within the interval [x,y]" msgstr "不在區間 [x,y]" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148992\n" @@ -2173,7 +1992,6 @@ msgid "... the field name contains a value that does not lie between the two val msgstr "... 資料欄位包含一個不在 x 和 y 兩者之間的數值。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149995\n" @@ -2182,7 +2000,6 @@ msgid "IN (a; b; c...)" msgstr "IN (a; b; c...)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159167\n" @@ -2191,7 +2008,6 @@ msgid "Note that the semicolons are used as separators in all value lists!" msgstr "請注意，分號於所有數值清單中代表分隔符！" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159085\n" @@ -2200,7 +2016,6 @@ msgid "IN (a, b, c...)" msgstr "IN (a, b, c...)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154809\n" @@ -2209,7 +2024,6 @@ msgid "contains a, b, c..." msgstr "含有 a、b、c..." #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148399\n" @@ -2218,7 +2032,6 @@ msgid "... the field name contains one of the specified expressions a, b, c,... msgstr "... 資料欄位包含指定的表示式 a、b、c、... 之一。您可指定任意數目的表示式，查詢結果會透過 OR 連結得出。表示式 a、b、c... 可以是數字，也可以是字元" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154112\n" @@ -2227,7 +2040,6 @@ msgid "NOT IN (a; b; c...)" msgstr "NOT IN (a; b; c...)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153544\n" @@ -2236,7 +2048,6 @@ msgid "NOT IN (a, b, c...)" msgstr "NOT IN (a, b, c...)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150679\n" @@ -2245,7 +2056,6 @@ msgid "does not contain a, b, c..." msgstr "不包含 a、b、c..." #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3158439\n" @@ -2254,7 +2064,6 @@ msgid "... the field name does not contain one of the specified expressions a, b msgstr "... 資料欄位不包含指定的表示式 a、b、c、... 的任何一個。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3145145\n" @@ -2263,7 +2072,6 @@ msgid "= TRUE" msgstr "= TRUE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146804\n" @@ -2272,7 +2080,6 @@ msgid "= TRUE" msgstr "= TRUE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149248\n" @@ -2281,7 +2088,6 @@ msgid "has the value True" msgstr "擁有數值 TRUE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148524\n" @@ -2290,7 +2096,6 @@ msgid "... the field name has the value True." msgstr "... 資料欄位擁有數值 TRUE。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159212\n" @@ -2299,7 +2104,6 @@ msgid "= FALSE" msgstr "= FALSE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3144751\n" @@ -2308,7 +2112,6 @@ msgid "= FALSE" msgstr "= FALSE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149955\n" @@ -2317,7 +2120,6 @@ msgid "has the value false" msgstr "擁有數值 FALSE" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146850\n" @@ -2326,7 +2128,6 @@ msgid "... the field name has the value false." msgstr "... 資料欄位擁有數值 FALSE。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3155954\n" @@ -2335,7 +2136,6 @@ msgid "Examples" msgstr "範例" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153792\n" @@ -2344,7 +2144,6 @@ msgid "='Ms.'" msgstr "='Frau'" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150948\n" @@ -2369,7 +2168,6 @@ msgid "returns dates that occurred before January 10, 2001" msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150333\n" @@ -2378,7 +2176,6 @@ msgid "LIKE 'g?ve'" msgstr "LIKE 'g?ve'" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147332\n" @@ -2387,7 +2184,6 @@ msgid "returns field names with field content such as \"give\" and \"gave\"." msgstr "返回具有如「give」和「gave」欄位內容的欄位名稱。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146062\n" @@ -2396,7 +2192,6 @@ msgid "LIKE 'S*'" msgstr "LIKE 'S*'" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155350\n" @@ -2405,7 +2200,6 @@ msgid "returns data fields with field contents such as \"Sun\"." msgstr "得出欄位內容為「Sun」的資料欄位。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152883\n" @@ -2414,7 +2208,6 @@ msgid "BETWEEN 10 AND 20" msgstr "BETWEEN 10 AND 20" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159406\n" @@ -2423,7 +2216,6 @@ msgid "returns field names with field content between the values 10 and 20. (The msgstr "得出欄位內容介於數值 10 和 20 之間的資料欄位。(亦可為文字欄位和數字欄位相關。)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148765\n" @@ -2432,7 +2224,6 @@ msgid "IN (1; 3; 5; 7)" msgstr "IN (1; 3; 5; 7)" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149712\n" @@ -2441,7 +2232,6 @@ msgid "returns field names with the values 1, 3, 5, 7. If the field name contain msgstr "得出含數值 1、3、5、7 的資料欄位。如果資料欄位包含一個商品編號，您可以建立得出包含指定編號的特定商品查詢。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152948\n" @@ -2450,7 +2240,6 @@ msgid "NOT IN ('Smith')" msgstr "NOT IN ('Mler')" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147279\n" @@ -2459,7 +2248,6 @@ msgid "returns field names that do not contain \"Smith\"." msgstr "得出不含「Mler」的資料欄位。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146073\n" @@ -2468,7 +2256,6 @@ msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}" msgstr "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150661\n" @@ -2477,7 +2264,6 @@ msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}" msgstr "範例：select * from 商品 where 商品名稱 like 'The *%' {escape '*'}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3148541\n" @@ -2486,7 +2272,6 @@ msgid "The example will give you all of the entries where the item name begins w msgstr "此範例得出所有以「The *」開頭的商品名稱條目。因此您同樣可以搜尋解譯為萬用字元的字元，如 *、?、_、% 或 .。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3150572\n" @@ -2495,7 +2280,6 @@ msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" msgstr "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156052\n" @@ -2504,7 +2288,6 @@ msgid "Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no msgstr "範例：select 商品.* from {oj 商品 LEFT OUTER JOIN 訂購 ON 商品.No=訂購.ANR}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3153674\n" @@ -2513,7 +2296,6 @@ msgid "Querying text fields" msgstr "文字欄位的查詢" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149134\n" @@ -2522,7 +2304,6 @@ msgid "To query the content of a text field, you must put the expression between msgstr "若要查詢文字欄位的內容，您必須以單引號括起表示式。大小寫則不予區分。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3149302\n" @@ -2571,7 +2352,6 @@ msgid "SQL2 syntax" msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id315913111\n" @@ -2580,7 +2360,6 @@ msgid "Date" msgstr "日期" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id315913112\n" @@ -2589,7 +2368,6 @@ msgid "{D'YYYY-MM-DD'}" msgstr "{D'YYYY-MM-DD'}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id314975313\n" @@ -2607,7 +2385,6 @@ msgid "'YYYY-MM-DD'" msgstr "{D'YYYY-MM-DD'}" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id31559471\n" @@ -2616,7 +2393,6 @@ msgid "Time" msgstr "時間" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id31559472\n" @@ -2641,7 +2417,6 @@ msgid "'HH:MI:SS[.SS]'" msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id31509641\n" @@ -2650,7 +2425,6 @@ msgid "DateTime" msgstr "日期時間" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id31509642\n" @@ -2675,7 +2449,6 @@ msgid "'YYYY-MM-DD HH:MI:SS[.SS]'" msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149539\n" @@ -2700,7 +2473,6 @@ msgid "All date expressions (literals) must be enclosed with single quotation ma msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3150427\n" @@ -2709,7 +2481,6 @@ msgid "Querying Yes/No fields" msgstr "「是/否」欄位的查詢" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149523\n" @@ -2718,7 +2489,6 @@ msgid "To query Yes/No fields, use the following syntax for dBASE tables:" msgstr "若要查詢 [是/否] 欄位，請在 dBASE 表格中使用下列語法：" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3153180\n" @@ -2727,7 +2497,6 @@ msgid "Status" msgstr "<emph>狀況</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147481\n" @@ -2736,7 +2505,6 @@ msgid "Query criterion" msgstr "<emph>查詢條件</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155187\n" @@ -2745,7 +2513,6 @@ msgid "Example" msgstr "<emph>範例</emph>" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3156092\n" @@ -2754,7 +2521,6 @@ msgid "Yes" msgstr "是" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152414\n" @@ -2763,7 +2529,6 @@ msgid "for dBASE tables: not equal to any given value" msgstr "在 dBASE 表格中：不等於任何指定的值" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3151265\n" @@ -2772,7 +2537,6 @@ msgid "=1 returns all records where the Yes/No field has the status \"Yes\" or \ msgstr "=1 得出所有資料條目，其中「是/否」欄位擁有「是」或「否」狀況 (黑色標記)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152450\n" @@ -2790,7 +2554,6 @@ msgid "." msgstr "." #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3155331\n" @@ -2799,7 +2562,6 @@ msgid "=0 returns all records for which the Yes/No field has the status \"No\" o msgstr "=0 得出所有資料條目，其中「是/否」欄位擁有「否」或「不使用」狀況 (無標記)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3154179\n" @@ -2808,7 +2570,6 @@ msgid "Null" msgstr "空缺" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147035\n" @@ -2817,7 +2578,6 @@ msgid "IS NULL" msgstr "IS NULL" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3159385\n" @@ -2826,7 +2586,6 @@ msgid "IS NULL returns all records for which the Yes/No field has neither of the msgstr "IS NULL 得出所有資料條目，其中「是/否」欄位不含「是」或「否」這兩個狀況 (灰色標記)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3157888\n" @@ -2835,7 +2594,6 @@ msgid "The syntax depends on the database system used. You should also note that msgstr "其語法取決於使用的資料庫系統。您還應該注意，[是/否]欄位可能有不同的定義 (僅 2 種狀態，而不是3 種)。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3145772\n" @@ -2892,7 +2650,6 @@ msgid "Parameter queries may be used as the data source for <link href=\"text/sh msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3151035\n" @@ -2925,7 +2682,6 @@ msgid "The user can use the SQL wild-card characters \"%\" (arbitrary string) or msgstr "" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "hd_id3145181\n" @@ -2934,7 +2690,6 @@ msgid "SQL Mode" msgstr "SQL 模式" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3147013\n" @@ -2943,7 +2698,6 @@ msgid "SQL stands for \"Structured Query Language\" and describes instructions f msgstr "SQL 代表「Structured Query Language」並描述指令，以查詢、更新和管理相關的資料庫。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152570\n" @@ -2952,7 +2706,6 @@ msgid "In $[officename] you do not need any knowledge of SQL for most queries, s msgstr "在 $[officename] 中，對於大多數查詢您無需任何 SQL 的知識，因為您不必輸入 SQL 程式碼。如果您在查詢設計中建立查詢，$[officename] 自動將您的指令轉換成對應的 SQL 語法。如果您變更至 SQL 檢視 (藉助 <emph>[啟動或關閉設計檢視]</emph> 按鈕)，您可以查看先前所建立查詢的 SQL 指令。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3152412\n" @@ -2961,7 +2714,6 @@ msgid "You can formulate your query directly in the SQL code. Note, however, tha msgstr "您可以直接在 SQL 程式碼中建立您的查詢。但是要注意的是，特殊語法需視您使用的資料庫系統而定。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3146842\n" @@ -2970,7 +2722,6 @@ msgid "If you enter the SQL code manually, you can create SQL-specific queries t msgstr "如果您手動輸入 SQL 程式碼，便可以建立特殊的 SQL 查詢，但是<emph>查詢設計</emph>中的圖形平面則不支援。這些查詢必須以「Native SQL」模式執行。" #: 02010100.xhp -#, fuzzy msgctxt "" "02010100.xhp\n" "par_id3149632\n" diff --git a/source/zh-TW/helpcontent2/source/text/shared/guide.po b/source/zh-TW/helpcontent2/source/text/shared/guide.po index 07760c4dec1..547966fb6f8 100644 --- a/source/zh-TW/helpcontent2/source/text/shared/guide.po +++ b/source/zh-TW/helpcontent2/source/text/shared/guide.po @@ -4,17 +4,17 @@ 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: 2016-04-16 21:40+0200\n" -"PO-Revision-Date: 2015-12-11 12:47+0000\n" -"Last-Translator: system user <>\n" +"PO-Revision-Date: 2016-04-17 00:19+0000\n" +"Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" "Language: zh_TW\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-Generator: Pootle 2.7\n" "X-Accelerator-Marker: ~\n" -"X-POOTLE-MTIME: 1449838045.000000\n" +"X-Generator: Pootle 2.7\n" +"X-POOTLE-MTIME: 1460852349.000000\n" #: aaa_start.xhp msgctxt "" @@ -6000,7 +6000,6 @@ msgid "<bookmark_value>opening; documents</bookmark_value> <bookmark_value>docu msgstr "<bookmark_value>開啟; 文件</bookmark_value><bookmark_value>文件; 開啟</bookmark_value><bookmark_value>檔案; 開啟</bookmark_value><bookmark_value>載入; 文件</bookmark_value><bookmark_value>試算表; 建立/開啟</bookmark_value><bookmark_value>簡報; 建立/開啟</bookmark_value><bookmark_value>FTP; 開啟文件</bookmark_value><bookmark_value>新文件</bookmark_value><bookmark_value>空白文件</bookmark_value><bookmark_value>文字文件; 建立/開啟</bookmark_value><bookmark_value>繪圖; 建立/開啟</bookmark_value><bookmark_value>HTML 文件; 新增</bookmark_value><bookmark_value>公式; 新增</bookmark_value>" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "hd_id3147834\n" @@ -6009,7 +6008,6 @@ msgid "<variable id=\"doc_open\"><link href=\"text/shared/guide/doc_open.xhp\" n msgstr "<variable id=\"doc_open\"><link href=\"text/shared/guide/doc_open.xhp\" name=\"開啟文件\">開啟文件</link></variable>" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "hd_id3147653\n" @@ -6018,7 +6016,6 @@ msgid "Opening an existing document" msgstr "開啟現存的文件" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3149398\n" @@ -6051,7 +6048,6 @@ msgid "Press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</ca msgstr "按 <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+O" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3150275\n" @@ -6060,7 +6056,6 @@ msgid "The <link href=\"text/shared/01/01020000.xhp\" name=\"Open\">Open</link> msgstr "您會看到<link href=\"text/shared/01/01020000.xhp\" name=\"「開啟舊檔」\">「開啟舊檔」</link>對話方塊。" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3149164\n" @@ -6069,7 +6064,6 @@ msgid "Select the file you want to open and click <emph>Open</emph>." msgstr "選取要開啟的檔案並按一下 <emph>[開啟]</emph>。" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "hd_id3149234\n" @@ -6119,7 +6113,6 @@ msgid "Press Shift+F5 to set the cursor to the last saved position." msgstr "按 Shift+F5 可將游標設定為上次儲存的位置。" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "hd_id3148453\n" @@ -6128,7 +6121,6 @@ msgid "Opening an Empty Document" msgstr "開啟空白文件" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3147287\n" @@ -6137,7 +6129,6 @@ msgid "Click the <emph>New</emph> icon on the Standard bar or choose <emph>File msgstr "按一下 [標準] 列上的 <emph>[開啟新檔]</emph> 圖示，或選擇 <emph>[檔案] - [開啟新檔]</emph>。此動作會以指定的文件類型開啟一個文件。" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3153092\n" @@ -6186,7 +6177,6 @@ msgid "Opening Files from a Web Server" msgstr "開啟 Web 伺服器的檔案" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3153126\n" @@ -6211,7 +6201,6 @@ msgid "When you open a file by a URL from the Windows file dialog, Windows will msgstr "當您在 Windows 檔案對話方塊中以 URL 開啟檔案時，Windows 會開啟該檔案位於 Internet Explorer 快取中的本機副本。%PRODUCTNAME 檔案對話方塊則會開啟該檔案在系統暫存資料夾中的本機副本。" #: doc_open.xhp -#, fuzzy msgctxt "" "doc_open.xhp\n" "par_id3148616\n" @@ -13019,7 +13008,6 @@ msgid "<bookmark_value>instructions; general</bookmark_value>" msgstr "<bookmark_value>說明; 一般</bookmark_value>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3151097\n" @@ -13028,7 +13016,6 @@ msgid "<variable id=\"main\"><link href=\"text/shared/guide/main.xhp\" name=\"Ge msgstr "<variable id=\"main\"><link href=\"text/shared/guide/main.xhp\" name=\"%PRODUCTNAME 的一般說明\"><item type=\"productname\">%PRODUCTNAME</item> 的一般說明</link></variable>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3153681\n" @@ -13037,7 +13024,6 @@ msgid "Opening and Saving Documents and Templates" msgstr "開啟以及儲存文件和範本" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3150669\n" @@ -13046,7 +13032,6 @@ msgid "Using Windows, Menus and Icons" msgstr "使用視窗、功能表和各式圖示" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3149295\n" @@ -13055,7 +13040,6 @@ msgid "Accessibility" msgstr "協助工具" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3159149\n" @@ -13064,7 +13048,6 @@ msgid "Copying Data by Drag and Drop or Menu Commands" msgstr "複製資料，透過「拖放」的方式和透過功能表" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3152576\n" @@ -13105,7 +13088,6 @@ msgid "<link href=\"text/shared/autopi/01090000.xhp\">Forms Wizard</link>" msgstr "<link href=\"text/shared/autopi/01090000.xhp\">表單精靈</link>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "par_id3154011\n" @@ -13114,7 +13096,6 @@ msgid "<link href=\"text/shared/autopi/01100000.xhp\">Report Wizard</link>" msgstr "<link href=\"text/shared/autopi/01100000.xhp\">報表精靈</link>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3147216\n" @@ -13123,7 +13104,6 @@ msgid "Recording Changes (Revision Marking)" msgstr "記錄變更 (增訂功能)" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3145261\n" @@ -13132,7 +13112,6 @@ msgid "Configuring and Modifying <item type=\"productname\">%PRODUCTNAME</item>" msgstr "調整和變更 <item type=\"productname\">%PRODUCTNAME</item>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3145252\n" @@ -13141,7 +13120,6 @@ msgid "Charts" msgstr "圖表 (Chart)" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "hd_id3157846\n" @@ -13150,7 +13128,6 @@ msgid "Miscellaneous" msgstr "其他" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "par_id3147173\n" @@ -13159,7 +13136,6 @@ msgid "<link href=\"text/shared/00/00000005.xhp\" name=\"General Terminology\">G msgstr "<link href=\"text/shared/00/00000005.xhp\" name=\"一般術語\">一般術語</link>" #: main.xhp -#, fuzzy msgctxt "" "main.xhp\n" "par_id3156332\n" |