diff options
| author | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-08-17 14:03:51 +0200 |
|---|---|---|
| committer | Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> | 2020-08-17 14:11:04 +0200 |
| commit | e8c9e70e057aec51c783b7230f1995020374d06f (patch) | |
| tree | ad1219358f0db141ec7b13254a41e0ebf9282858 /source/ko/helpcontent2 | |
| parent | 1c00f748202eb64ffa0be5ce38e57a47f6e5798a (diff) | |
update translations for master
and force-fix errors using pocheck
Change-Id: I9e806cc79950a35df80dc1ffeab84cd5f18dc861
Diffstat (limited to 'source/ko/helpcontent2')
| -rw-r--r-- | source/ko/helpcontent2/source/auxiliary.po | 10 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/sbasic/shared.po | 317 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/sdatabase.po | 2240 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/sdraw/01.po | 38 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/00.po | 20 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/01.po | 171 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/02.po | 71 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/explorer/database.po | 2222 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/guide.po | 30 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/shared/optionen.po | 230 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/simpress.po | 20 | ||||
| -rw-r--r-- | source/ko/helpcontent2/source/text/swriter/01.po | 8 |
12 files changed, 2774 insertions, 2603 deletions
diff --git a/source/ko/helpcontent2/source/auxiliary.po b/source/ko/helpcontent2/source/auxiliary.po index 378ebee01cc..69125db7d1c 100644 --- a/source/ko/helpcontent2/source/auxiliary.po +++ b/source/ko/helpcontent2/source/auxiliary.po @@ -4,7 +4,7 @@ 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-05-19 12:41+0200\n" -"PO-Revision-Date: 2019-12-17 11:21+0000\n" +"PO-Revision-Date: 2020-08-16 15:35+0000\n" "Last-Translator: DaeHyun Sung(성대현, 成大鉉) <sungdh86@gmail.com>\n" "Language-Team: Korean <https://weblate.documentfoundation.org/projects/libo_help-master/auxiliary/ko/>\n" "Language: ko\n" @@ -13,7 +13,7 @@ msgstr "" "Content-Transfer-Encoding: 8bit\n" "Plural-Forms: nplurals=1; plural=0;\n" "X-Accelerator-Marker: ~\n" -"X-Generator: LibreOffice\n" +"X-Generator: Weblate 4.1.1\n" "X-POOTLE-MTIME: 1552627944.000000\n" #. fEEXD @@ -23,7 +23,7 @@ msgctxt "" "07\n" "help_section.text" msgid "Macros and Scripting" -msgstr "매크로와 스크립팅" +msgstr "매크로와 스크립트" #. pDA36 #: sbasic.tree @@ -32,7 +32,7 @@ msgctxt "" "0701\n" "node.text" msgid "%PRODUCTNAME BASIC" -msgstr "%PRODUCTNAME 기본" +msgstr "%PRODUCTNAME BASIC" #. Ua99d #: sbasic.tree @@ -86,7 +86,7 @@ msgctxt "" "070103\n" "node.text" msgid "Guides" -msgstr "" +msgstr "안내" #. f7k4A #: sbasic.tree diff --git a/source/ko/helpcontent2/source/text/sbasic/shared.po b/source/ko/helpcontent2/source/text/sbasic/shared.po index 4af1d0f8999..571536f38c7 100644 --- a/source/ko/helpcontent2/source/text/sbasic/shared.po +++ b/source/ko/helpcontent2/source/text/sbasic/shared.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-03-14 15:12+0000\n" "Last-Translator: DaeHyun Sung(성대현, 成大鉉) <sungdh86@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -8161,13 +8161,13 @@ msgctxt "" msgid "sVar = MsgBox(\"Las Vegas\", MB_DEFBUTTON2 + MB_ICONSTOP + MB_ABORTRETRYCANCEL, \"Dialog title\")" msgstr "" -#. xrb4U +#. BaStC #: 03010103.xhp msgctxt "" "03010103.xhp\n" "tit\n" "help.text" -msgid "Print Statement" +msgid "Print# Statement" msgstr "" #. addUg @@ -8179,23 +8179,32 @@ msgctxt "" msgid "<bookmark_value>Print statement</bookmark_value> <bookmark_value>Print statement; Tab function</bookmark_value> <bookmark_value>Print statement; Spc function</bookmark_value> <bookmark_value>Spc function; in Print statement</bookmark_value> <bookmark_value>Tab function; in Print statement</bookmark_value>" msgstr "" -#. 5DJDW +#. ARzns #: 03010103.xhp msgctxt "" "03010103.xhp\n" "hd_id3147230\n" "help.text" -msgid "<variable id=\"Print_h1\"><link href=\"text/sbasic/shared/03010103.xhp\" name=\"Print Statement\">Print Statement</link></variable>" +msgid "<variable id=\"Print_h1\"><link href=\"text/sbasic/shared/03010103.xhp\" name=\"Print# Statement\">Print# Statement</link></variable>" msgstr "" -#. AGxsw +#. ZDGAu #: 03010103.xhp msgctxt "" "03010103.xhp\n" "par_id3156281\n" "help.text" -msgid "Outputs the specified strings or numeric expressions to a dialog or to a file." -msgstr "지정한 문자열 또는 수식을 대화 상자 또는 파일에 출력합니다." +msgid "Outputs the specified strings or numeric expressions to the screen or to a sequential file." +msgstr "" + +#. xCJRj +#: 03010103.xhp +msgctxt "" +"03010103.xhp\n" +"par_id461596463969009\n" +"help.text" +msgid "Use <link href=\"text/sbasic/shared/03020201.xhp\">Put#</link> statement to write data to a binary or a random file. Use <link href=\"text/sbasic/shared/03020205.xhp\">Write#</link> statement to write data to a sequential text file with delimiting characters." +msgstr "" #. AhB82 #: 03010103.xhp @@ -9745,13 +9754,13 @@ msgctxt "" msgid "<bookmark_value>Reset statement</bookmark_value>" msgstr "<bookmark_value>Reset 문</bookmark_value>" -#. drRvG +#. aCi6f #: 03020104.xhp msgctxt "" "03020104.xhp\n" "hd_id3154141\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03020104.xhp\">Reset Statement</link>" +msgid "<variable id=\"Reset_h1\"><link href=\"text/sbasic/shared/03020104.xhp\">Reset Statement</link></variable>" msgstr "" #. iLCKn @@ -9763,23 +9772,14 @@ msgctxt "" msgid "Closes all open files and writes the contents of all file buffers to the harddisk." msgstr "열려 있는 모든 파일을 닫고 모든 파일 버퍼의 내용을 하드 디스크에 기록합니다." -#. nTNj2 +#. jEQ3F #: 03020104.xhp msgctxt "" "03020104.xhp\n" -"hd_id3154124\n" -"help.text" -msgid "Syntax:" -msgstr "구문:" - -#. TufHR -#: 03020104.xhp -msgctxt "" -"03020104.xhp\n" -"hd_id3161831\n" +"par_id971587473488701\n" "help.text" -msgid "Example:" -msgstr "예:" +msgid "<image src=\"media/helpimg/sbasic/Reset_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Reset Statement diagram</alt></image>" +msgstr "" #. BXAjN #: 03020104.xhp @@ -10024,50 +10024,41 @@ msgctxt "" msgid "Reads data from an open sequential file." msgstr "열린 순차 파일에서 데이터를 읽습니다." -#. 7DMCx +#. mNkEN #: 03020202.xhp msgctxt "" "03020202.xhp\n" -"hd_id3125863\n" +"par_id971587473488701\n" "help.text" -msgid "Syntax:" -msgstr "구문:" +msgid "<image src=\"media/helpimg/sbasic/Input_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Input Statement diagram</alt></image>" +msgstr "" -#. eEsn3 +#. NqnvX #: 03020202.xhp msgctxt "" "03020202.xhp\n" "par_id3150440\n" "help.text" -msgid "Input #FileNumber As Integer; var1[, var2[, var3[,...]]]" -msgstr "Input #FileNumber As Integer; var1[, var2[, var3[,...]]]" - -#. 4bQRN -#: 03020202.xhp -msgctxt "" -"03020202.xhp\n" -"hd_id3146121\n" -"help.text" -msgid "Parameters:" -msgstr "매개 변수:" +msgid "Input #fileNum {,|;} var1 [, var2 [, ...]]" +msgstr "" -#. emXUX +#. EUrQA #: 03020202.xhp msgctxt "" "03020202.xhp\n" "par_id3145749\n" "help.text" -msgid "<emph>FileNumber:</emph> Number of the file that contains the data that you want to read. The file must be opened with the Open statement using the key word INPUT." -msgstr "<emph>FileNumber:</emph> 읽을 데이터가 포함된 파일의 번호입니다. 파일은 Open 문에서 INPUT 키워드를 사용하여 열어야 합니다." +msgid "<emph>fileNum</emph>: Number of the file that contains the data that you want to read. The file must be opened with the Open statement using the key word INPUT." +msgstr "" -#. 75Dav +#. kJyKM #: 03020202.xhp msgctxt "" "03020202.xhp\n" "par_id3150011\n" "help.text" -msgid "<emph>var:</emph> A numeric or string variable that you assign the values read from the opened file to." -msgstr "<emph>var:</emph> 열린 파일에서 읽은 값을 할당한 숫자 또는 문자열 변수입니다." +msgid "<emph>var</emph>: A numeric or string variable that you assign the values read from the opened file to." +msgstr "" #. 23Pzt #: 03020202.xhp @@ -10105,15 +10096,6 @@ msgctxt "" msgid "If the end of the file is reached while reading a data element, an error occurs and the process is aborted." msgstr "데이터 요소를 읽는 동안 파일 끝에 도달할 경우 오류가 발생하고 프로세스가 중단됩니다." -#. 3xUNX -#: 03020202.xhp -msgctxt "" -"03020202.xhp\n" -"hd_id3152578\n" -"help.text" -msgid "Example:" -msgstr "예:" - #. xqNBb #: 03020202.xhp msgctxt "" @@ -10132,13 +10114,13 @@ msgctxt "" msgid "' Read data file using Input" msgstr "" -#. JiWcR +#. ASL6h #: 03020203.xhp msgctxt "" "03020203.xhp\n" "tit\n" "help.text" -msgid "Line Input # Statement" +msgid "Line Input# Statement" msgstr "" #. CCEuD @@ -10150,68 +10132,50 @@ msgctxt "" msgid "<bookmark_value>Line Input statement</bookmark_value>" msgstr "<bookmark_value>Line 입력문</bookmark_value>" -#. rG2am +#. DBAiv #: 03020203.xhp msgctxt "" "03020203.xhp\n" "hd_id3153361\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03020203.xhp\" name=\"Line Input # Statement\">Line Input # Statement</link>" +msgid "<variable id=\"LineInput_h1\"><link href=\"text/sbasic/shared/03020203.xhp\" name=\"Line Input# Statement\">Line Input# Statement</link></variable>" msgstr "" -#. QbTVA +#. 5FZ8D #: 03020203.xhp msgctxt "" "03020203.xhp\n" "par_id3156280\n" "help.text" -msgid "Reads strings from a sequential file into a variable." -msgstr "순차 파일에서 변수로 문자열을 읽어옵니다." - -#. NSBkr -#: 03020203.xhp -msgctxt "" -"03020203.xhp\n" -"hd_id3150447\n" -"help.text" -msgid "Syntax:" -msgstr "구문:" - -#. jCyHM -#: 03020203.xhp -msgctxt "" -"03020203.xhp\n" -"par_id3147229\n" -"help.text" -msgid "Line Input #FileNumber As Integer, Var As String" -msgstr "Line Input #FileNumber As Integer, Var As String" +msgid "Reads a line from a sequential file into a variable." +msgstr "" -#. h3tyw +#. enCkE #: 03020203.xhp msgctxt "" "03020203.xhp\n" -"hd_id3145173\n" +"par_id971587473488701\n" "help.text" -msgid "Parameters:" -msgstr "매개 변수:" +msgid "<image src=\"media/helpimg/sbasic/Line-Input_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Line Input Statement diagram</alt></image>" +msgstr "" -#. ARTNC +#. wrpF7 #: 03020203.xhp msgctxt "" "03020203.xhp\n" "par_id3161832\n" "help.text" -msgid "<emph>FileNumber: </emph>Number of the file that contains the data that you want to read. The file must have been opened in advance with the Open statement using the key word INPUT." -msgstr "<emph>FileNumber: </emph>읽을 데이터가 포함된 파일의 번호입니다.먼저 Open 문에서 INPUT 키워드를 사용하여 파일을 열었어야 합니다." +msgid "<emph>fileNum</emph>: Number of the file that contains the data that you want to read. The file must have been opened in advance with the Open statement using the key word INPUT." +msgstr "" -#. KUGEc +#. qAR2M #: 03020203.xhp msgctxt "" "03020203.xhp\n" "par_id3151119\n" "help.text" -msgid "<emph>var:</emph> The name of the variable that stores the result." -msgstr "<emph>var:</emph> 결과를 저장하는 변수의 이름입니다." +msgid "<emph>variable</emph>: The name of the variable that stores the result." +msgstr "" #. foxtA #: 03020203.xhp @@ -10222,40 +10186,13 @@ msgctxt "" msgid "With the <emph>Line Input#</emph> statement, you can read strings from an open file into a variable. String variables are read line-by-line up to the first carriage return (Asc=13) or linefeed (Asc=10). Line end marks are not included in the resulting string." msgstr "<emph>Line Input#</emph> 문을 사용하면 열린 파일에서 변수로 문자열을 읽어올 수 있습니다. 문자열 변수는 첫 번째 캐리지 리턴(Asc=13) 또는 줄 바꿈(Asc=10)까지 줄 단위로 읽습니다. 줄 끝 표시는 결과 문자열에 포함되지 않습니다." -#. NjeFe -#: 03020203.xhp -msgctxt "" -"03020203.xhp\n" -"hd_id3163711\n" -"help.text" -msgid "Example:" -msgstr "예:" - -#. Uxyyc -#: 03020203.xhp -msgctxt "" -"03020203.xhp\n" -"par_id3147124\n" -"help.text" -msgid "Print #iNumber, \"This is a line of text\"" -msgstr "Print #iNumber, \"This is a line of text\"" - -#. iFP3f -#: 03020203.xhp -msgctxt "" -"03020203.xhp\n" -"par_id3153415\n" -"help.text" -msgid "Print #iNumber, \"This is another line of text\"" -msgstr "Print #iNumber, \"다른 줄 텍스트입니다.\"" - -#. NKDq4 +#. fhFEa #: 03020204.xhp msgctxt "" "03020204.xhp\n" "tit\n" "help.text" -msgid "Put Statement" +msgid "Put# Statement" msgstr "" #. psWQE @@ -10267,13 +10204,13 @@ msgctxt "" msgid "<bookmark_value>Put statement</bookmark_value>" msgstr "<bookmark_value>Put 문</bookmark_value>" -#. qMDia +#. bD34J #: 03020204.xhp msgctxt "" "03020204.xhp\n" "hd_id3150360\n" "help.text" -msgid "<variable id=\"Put_h1\"><link href=\"text/sbasic/shared/03020204.xhp\" name=\"Put Statement\">Put Statement</link></variable>" +msgid "<variable id=\"Put_h1\"><link href=\"text/sbasic/shared/03020204.xhp\" name=\"Put Statement\">Put# Statement</link></variable>" msgstr "" #. e8rUp @@ -10285,14 +10222,14 @@ msgctxt "" msgid "Writes a record to a relative file or a sequence of bytes to a binary file." msgstr "레코드를 상대 파일에 쓰거나 바이트 시퀀스를 이진 파일에 씁니다." -#. 7iAkD +#. EEnDK #: 03020204.xhp msgctxt "" "03020204.xhp\n" -"par_id3156281\n" +"par_id461596463969009\n" "help.text" -msgid "See also: <link href=\"text/sbasic/shared/03020201.xhp\" name=\"Get\"><item type=\"literal\">Get</item></link> statement" -msgstr "참고 항목: <link href=\"text/sbasic/shared/03020201.xhp\" name=\"Get\"><item type=\"literal\">Get</item></link> 문" +msgid "Use <link href=\"text/sbasic/shared/03010103.xhp\">Print#</link> statement to print data to a sequential text file. Use <link href=\"text/sbasic/shared/03020205.xhp\">Write#</link> statement to write data to a sequential text file with delimiting characters." +msgstr "" #. 9HgEG #: 03020204.xhp @@ -10312,22 +10249,22 @@ msgctxt "" msgid "Put [#]fileNum, [recordNum|filePos], variable" msgstr "" -#. FyRAf +#. bSFd2 #: 03020204.xhp msgctxt "" "03020204.xhp\n" "par_id3146120\n" "help.text" -msgid "<emph>fileNum:</emph> Any integer expression that defines the file that you want to write to." +msgid "<emph>fileNum</emph>: Any integer expression that defines the file that you want to write to." msgstr "" -#. hYQKG +#. AiZUD #: 03020204.xhp msgctxt "" "03020204.xhp\n" "par_id3155411\n" "help.text" -msgid "<emph>recordNum, filePos: </emph>For relative files (random access files), the number of the record that you want to write." +msgid "<emph>recordNum, filePos</emph>: For relative files (random access files), the number of the record that you want to write." msgstr "" #. dUyzK @@ -10339,13 +10276,13 @@ msgctxt "" msgid "For binary files (binary access), the position of the byte in the file where you want to start writing." msgstr "이진 파일(이진 액세스)의 경우, 쓰기를 시작할 파일의 바이트 위치입니다." -#. 59xWL +#. iGF9L #: 03020204.xhp msgctxt "" "03020204.xhp\n" "par_id3153729\n" "help.text" -msgid "<emph>variable:</emph> Name of the variable that you want to write to the file." +msgid "<emph>variable</emph>: Name of the variable that you want to write to the file." msgstr "" #. yyf95 @@ -10384,68 +10321,59 @@ msgctxt "" msgid "<bookmark_value>Write statement</bookmark_value>" msgstr "<bookmark_value>Write 문</bookmark_value>" -#. DBBvs +#. xn3Ji #: 03020205.xhp msgctxt "" "03020205.xhp\n" "hd_id3147229\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03020205.xhp\" name=\"Write Statement\">Write Statement</link>" +msgid "<variable id=\"Write_h1\"><link href=\"text/sbasic/shared/03020205.xhp\" name=\"Write# Statement\">Write# Statement</link></variable>" msgstr "" -#. CMSkU +#. G4X6k #: 03020205.xhp msgctxt "" "03020205.xhp\n" "par_id3154685\n" "help.text" -msgid "Writes data to a sequential file." -msgstr "데이터를 순차 파일에 기록합니다." - -#. eoeBE -#: 03020205.xhp -msgctxt "" -"03020205.xhp\n" -"hd_id3150449\n" -"help.text" -msgid "Syntax:" -msgstr "구문:" +msgid "Writes data to a sequential text file with delimiting characters." +msgstr "" -#. jxyZn +#. fB8hV #: 03020205.xhp msgctxt "" "03020205.xhp\n" -"par_id3145785\n" +"par_id461596463969009\n" "help.text" -msgid "Write [#FileName], [Expressionlist]" -msgstr "Write [#FileName], [Expressionlist]" +msgid "Use <link href=\"text/sbasic/shared/03010103.xhp\">Print#</link> statement to print data to a sequential text file. Use <link href=\"text/sbasic/shared/03020201.xhp\">Put#</link> statement to write data to a binary or a random file." +msgstr "" -#. ceFn6 +#. WxpRu #: 03020205.xhp msgctxt "" "03020205.xhp\n" -"hd_id3151116\n" +"par_id971587473488701\n" "help.text" -msgid "Parameters:" -msgstr "매개 변수:" +msgid "<image src=\"media/helpimg/sbasic/Write_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Write Statement diagram</alt></image>" +msgstr "" -#. RsZEE +#. xEMDC #: 03020205.xhp msgctxt "" "03020205.xhp\n" "par_id3153728\n" "help.text" -msgid "<emph>FileName:</emph> Any numeric expression that contains the file number that was set by the Open statement for the respective file." -msgstr "<emph>FileName:</emph> 각 파일에 대해 Open 문으로 설정된 파일 번호를 포함하는 임의의 숫자 식입니다." +msgid "<emph>fileNum</emph>: Any numeric expression that contains the file number that was set by the Open statement for the respective file." +msgstr "" -#. aCyvx +#. TwHF7 #: 03020205.xhp msgctxt "" "03020205.xhp\n" "par_id3146120\n" "help.text" -msgid "<emph>Expressionlist:</emph> Variables or expressions that you want to enter in a file, separated by commas." -msgstr "<emph>Expressionlist:</emph> 파일에 입력할 쉼표로 구분된 변수 또는 식입니다." +msgid "<emph>expression</emph> list: Variables or expressions that you want to enter in a file, separated by commas." +msgstr "" #. RERPn #: 03020205.xhp @@ -10492,15 +10420,6 @@ msgctxt "" msgid "Numbers with decimal delimiters are converted according to the locale settings." msgstr "소수점을 갖는 수는 국가별 설정에 따라 변환됩니다." -#. Xhb5c -#: 03020205.xhp -msgctxt "" -"03020205.xhp\n" -"hd_id3151073\n" -"help.text" -msgid "Example:" -msgstr "예:" - #. ejANh #: 03020301.xhp msgctxt "" @@ -11023,13 +10942,13 @@ msgctxt "" msgid "<emph>FileNumber:</emph> The data channel number used in the Open statement." msgstr "<emph>FileNumber:</emph> Open 문에 사용되는 데이터 채널 번호입니다." -#. ybPDP +#. MbdMB #: 03020305.xhp msgctxt "" "03020305.xhp\n" "tit\n" "help.text" -msgid "Seek Statement" +msgid "Seek# Statement" msgstr "" #. vLW2K @@ -11041,13 +10960,13 @@ msgctxt "" msgid "<bookmark_value>Seek statement</bookmark_value>" msgstr "<bookmark_value>Seek 문</bookmark_value>" -#. PpSRU +#. 9HcVZ #: 03020305.xhp msgctxt "" "03020305.xhp\n" "hd_id3159413\n" "help.text" -msgid "<link href=\"text/sbasic/shared/03020305.xhp\" name=\"Seek Statement\">Seek Statement</link>" +msgid "<link href=\"text/sbasic/shared/03020305.xhp\" name=\"Seek# Statement\">Seek Statement</link>" msgstr "" #. RBPKW @@ -11077,59 +10996,59 @@ msgctxt "" msgid "For all other files, the Seek statement sets the byte position at which the next operation is to occur." msgstr "다른 모든 파일의 경우 Seek 문은 다음 작업이 발생할 바이트 위치를 설정합니다." -#. wYVfB +#. sbuDC #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"par_id3156280\n" +"par_id971587473488701\n" "help.text" -msgid "See also: <link href=\"text/sbasic/shared/03020103.xhp\" name=\"Open\">Open</link>, <link href=\"text/sbasic/shared/03020304.xhp\" name=\"Seek\">Seek</link>." -msgstr "참고 항목: <link href=\"text/sbasic/shared/03020103.xhp\" name=\"Open\">Open</link>, <link href=\"text/sbasic/shared/03020304.xhp\" name=\"Seek\">Seek</link>" +msgid "<image src=\"media/helpimg/sbasic/Seek_statement.svg\" id=\"img_id4156296484514\"><alt id=\"alt_id15152796484514\">Seek Statement diagram</alt></image>" +msgstr "" -#. yVEYG +#. PjcAp #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"hd_id3145785\n" +"par_id3145273\n" "help.text" -msgid "Syntax:" -msgstr "구문:" +msgid "Seek [#]filePos, {filePos|recordNum}" +msgstr "" -#. 7M3ws +#. vwzuK #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"par_id3145273\n" +"hd_id3153379\n" "help.text" -msgid "Seek[#FileNumber], Position (As Long)" -msgstr "Seek[#FileNumber], Position (As Long)" +msgid "Parameters:" +msgstr "" -#. nRRME +#. x86KJ #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"hd_id3154321\n" +"par_id3153952\n" "help.text" -msgid "Parameters:" -msgstr "매개 변수:" +msgid "<emph>fileNum</emph>: The data channel number used in the Open statement." +msgstr "" -#. ySD8U +#. FrYvd #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"par_id3153952\n" +"par_id3145366\n" "help.text" -msgid "<emph>FileNumber: </emph>The data channel number used in the Open statement." -msgstr "<emph>FileNumber: </emph> Open 문에 사용되는 데이터 채널 번호입니다." +msgid "<emph>filePos, recordNum</emph>: Position for the next writing or reading. Position can be a number between 1 and 2,147,483,647. According to the file type, the position indicates the number of the record (files in the Random mode) or the byte position (files in the Binary, Output, Append or Input mode). The first byte in a file is position 1, the second byte is position 2, and so on." +msgstr "" -#. Jf97B +#. 5LDFE #: 03020305.xhp msgctxt "" "03020305.xhp\n" -"par_id3145366\n" +"par_id491596468328575\n" "help.text" -msgid "<emph>Position: </emph>Position for the next writing or reading. Position can be a number between 1 and 2,147,483,647. According to the file type, the position indicates the number of the record (files in the Random mode) or the byte position (files in the Binary, Output, Append or Input mode). The first byte in a file is position 1, the second byte is position 2, and so on." -msgstr "<emph>Position: </emph>다음 쓰기 또는 읽기의 위치입니다. 위치는 1에서 2,147,483,647 사이의 숫자가 될 수 있습니다. 파일 형식에 따라 위치는 Random 모드의 파일의 경우 레코드 번호를 나타내며, 또는 Binary, Output, Append, Input 모드의 파일의 경우 바이트 위치를 나타냅니다. 파일의 첫 번째 바이트는 위치 1이 되고 두 번째 바이트는 위치 2가 되는 식으로 위치가 지정됩니다." +msgid "<link href=\"text/sbasic/shared/03020304.xhp\" name=\"Seek\">Seek</link> function" +msgstr "" #. Nwouh #: 03020400.xhp @@ -39391,13 +39310,13 @@ msgctxt "" msgid "<emph>Description</emph>: A description of the problem leading to stop the running process, accompanied with the various reasons that may cause it. A detailed list of the possible course of actions that may help solve the problem is recommended." msgstr "" -#. 3XjnB +#. q9uAh #: ErrVBA.xhp msgctxt "" "ErrVBA.xhp\n" "N0041\n" "help.text" -msgid "Err.Raise 2020, Description:=\"This is an intented user-defined error …\"" +msgid "Err.Raise 2020, Description:=\"This is an intended user-defined error …\"" msgstr "" #. vuP6g @@ -41254,13 +41173,13 @@ msgctxt "" msgid "%PRODUCTNAME Basic statements use syntax diagrams and textual conventions that follow these typographical rules:" msgstr "" -#. FcuAQ +#. ZnMxE #: conventions.xhp msgctxt "" "conventions.xhp\n" "par_id158193699546735\n" "help.text" -msgid "LibreOffice Basic keywords or functions use propercasing: Call, DimArray, InputBox, Property." +msgid "%PRODUCTNAME Basic keywords or functions use proper casing: Call, DimArray, InputBox, Property." msgstr "" #. ny9xr diff --git a/source/ko/helpcontent2/source/text/sdatabase.po b/source/ko/helpcontent2/source/text/sdatabase.po index 2d4c3a3caf6..8790dd9b661 100644 --- a/source/ko/helpcontent2/source/text/sdatabase.po +++ b/source/ko/helpcontent2/source/text/sdatabase.po @@ -3,7 +3,7 @@ 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" +"POT-Creation-Date: 2020-08-17 12:39+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" @@ -157,13 +157,13 @@ msgctxt "" msgid "Allows you to sort and filter the data in a query table." msgstr "" -#. EUECa +#. XpUzN #: 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>" +msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Query Design</link>" msgstr "" #. 3JCfK @@ -175,13 +175,13 @@ msgctxt "" msgid "With the <emph>Query Design</emph>, you can create and edit a query or view." msgstr "" -#. 343AB +#. q79aD #: 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>" +msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Through Several Tables\">Query Through Several Tables</link>" msgstr "" #. ASeVi @@ -193,13 +193,13 @@ msgctxt "" msgid "The query result can contain data from several tables if these are linked to each other by suitable data fields." msgstr "" -#. xGFWG +#. uBo2H #: 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>" +msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Formulating Query Criteria\">Formulating Query Criteria</link>" msgstr "" #. JTXBF @@ -211,13 +211,13 @@ msgctxt "" msgid "You can find out which operators and commands can be used to formulate the filter conditions for a query." msgstr "" -#. haGR4 +#. uCGCF #: 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>" +msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Executing Functions\">Executing Functions</link>" msgstr "" #. FWCVa @@ -292,13 +292,13 @@ msgctxt "" msgid "Do you really want to open the query in the graphic view?" msgstr "" -#. hLDZm +#. 2DqMn #: 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." +msgid "<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." msgstr "" #. DX2vA @@ -319,13 +319,13 @@ msgctxt "" msgid "Open the query in the SQL View" msgstr "" -#. FRNyg +#. Axfxy #: 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)." +msgid "<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)." msgstr "" #. 2N4uG @@ -364,6 +364,2220 @@ msgctxt "" 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 "" +#. E3MVS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"tit\n" +"help.text" +msgid "Query Design" +msgstr "" + +#. Ys2sC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"bm_id3153323\n" +"help.text" +msgid "<bookmark_value>views; creating database views (Base)</bookmark_value> <bookmark_value>queries; creating in design view (Base)</bookmark_value> <bookmark_value>designing; queries (Base)</bookmark_value> <bookmark_value>design view; queries/views (Base)</bookmark_value> <bookmark_value>joining;tables (Base)</bookmark_value> <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value> <bookmark_value>queries; joining tables (Base)</bookmark_value> <bookmark_value>tables in databases; relations (Base)</bookmark_value> <bookmark_value>relations; joining tables (Base)</bookmark_value> <bookmark_value>queries; deleting table links (Base)</bookmark_value> <bookmark_value>criteria of query design (Base)</bookmark_value> <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value> <bookmark_value>filter conditions;in queries (Base)</bookmark_value> <bookmark_value>parameters; queries (Base)</bookmark_value> <bookmark_value>queries; parameter queries (Base)</bookmark_value> <bookmark_value>SQL; queries (Base)</bookmark_value> <bookmark_value>native SQL (Base)</bookmark_value>" +msgstr "" + +#. fmcBY +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153394\n" +"help.text" +msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Query Design</link>" +msgstr "" + +#. GU8Jd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156411\n" +"help.text" +msgid "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" +msgstr "" + +#. vGBE5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id7024140\n" +"help.text" +msgid "Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time." +msgstr "" + +#. WZcUE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159176\n" +"help.text" +msgid "Selecting the <emph>Create View</emph> command from the <emph>Tables</emph> tab page of a database document, you see the <emph>View Design</emph> window that resembles the <emph>Query Design</emph> window described here." +msgstr "" + +#. JMyC7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8307138\n" +"help.text" +msgid "The Query Design window layout is stored with a created query, but cannot be stored with a created view." +msgstr "" + +#. TEBj6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149233\n" +"help.text" +msgid "The Design View" +msgstr "" + +#. zkTQc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145673\n" +"help.text" +msgid "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>." +msgstr "" + +#. EN5uU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150255\n" +"help.text" +msgid "The lower pane of the Design View is where you <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key." +msgstr "" + +#. GMVkG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152474\n" +"help.text" +msgid "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." +msgstr "" + +#. hYsxY +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147559\n" +"help.text" +msgid "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." +msgstr "" + +#. B4HEH +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id8226264\n" +"help.text" +msgid "Keys in Query Design View" +msgstr "" + +#. Cvd4o +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id2341074\n" +"help.text" +msgid "Key" +msgstr "" + +#. mCy9S +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id4384289\n" +"help.text" +msgid "Function" +msgstr "" + +#. yybiC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id5839106\n" +"help.text" +msgid "F4" +msgstr "" + +#. FMTZD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8554338\n" +"help.text" +msgid "Preview" +msgstr "" + +#. YQhGF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id1254921\n" +"help.text" +msgid "F5" +msgstr "" + +#. C9yhE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id7636646\n" +"help.text" +msgid "Run Query" +msgstr "" + +#. jdEeJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8579363\n" +"help.text" +msgid "F7" +msgstr "" + +#. 6Y6Uw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3227942\n" +"help.text" +msgid "Add Table or Query" +msgstr "" + +#. WN7wR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154939\n" +"help.text" +msgid "Browse" +msgstr "" + +#. 5y4VZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148799\n" +"help.text" +msgid "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." +msgstr "" + +#. FBQA9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3144762\n" +"help.text" +msgid "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" +msgstr "" + +#. eG8FD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157894\n" +"help.text" +msgid "While designing a query, you cannot modify the selected tables." +msgstr "" + +#. NLywF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149562\n" +"help.text" +msgid "Remove tables" +msgstr "" + +#. TbQzA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150685\n" +"help.text" +msgid "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." +msgstr "" + +#. VLTKB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150012\n" +"help.text" +msgid "Move table and modify table size" +msgstr "" + +#. amBsQ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146922\n" +"help.text" +msgid "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." +msgstr "" + +#. UoCRG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145365\n" +"help.text" +msgid "Table Relations" +msgstr "" + +#. BFCxB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154145\n" +"help.text" +msgid "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." +msgstr "" + +#. jcLbE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152577\n" +"help.text" +msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." +msgstr "" + +#. FspJi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155302\n" +"help.text" +msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." +msgstr "" + +#. FmAaU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153876\n" +"help.text" +msgid "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." +msgstr "" + +#. N2f8q +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145646\n" +"help.text" +msgid "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." +msgstr "" + +#. nLSiq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153279\n" +"help.text" +msgid "Specifying the relation type" +msgstr "" + +#. kDhFD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154791\n" +"help.text" +msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog." +msgstr "" + +#. rAkmw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150094\n" +"help.text" +msgid "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." +msgstr "" + +#. n3PMB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155851\n" +"help.text" +msgid "Deleting relations" +msgstr "" + +#. jCb4H +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156178\n" +"help.text" +msgid "To delete a relation between two tables, click the connection line and then press the Delete key." +msgstr "" + +#. 3UCig +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150715\n" +"help.text" +msgid "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." +msgstr "" + +#. pBybB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3151208\n" +"help.text" +msgid "Defining the query" +msgstr "" + +#. yGfhU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3158416\n" +"help.text" +msgid "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." +msgstr "" + +#. UB5nG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154161\n" +"help.text" +msgid "Specifying field names" +msgstr "" + +#. jyKMG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146791\n" +"help.text" +msgid "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." +msgstr "" + +#. 66Dcr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150750\n" +"help.text" +msgid "Deleting field names" +msgstr "" + +#. AbhrW +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154479\n" +"help.text" +msgid "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." +msgstr "" + +#. V92gB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155764\n" +"help.text" +msgid "Saving the query" +msgstr "" + +#. 2kWoA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148481\n" +"help.text" +msgid "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." +msgstr "" + +#. M9UQL +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154362\n" +"help.text" +msgid "Schema" +msgstr "" + +#. 4Jwm3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154754\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" +msgstr "" + +#. 6Q72c +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3156717\n" +"help.text" +msgid "Query name or table view name" +msgstr "" + +#. Cw73K +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154253\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" +msgstr "" + +#. qgbNu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3163805\n" +"help.text" +msgid "Filtering data" +msgstr "" + +#. Q9pG5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154964\n" +"help.text" +msgid "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" +msgstr "" + +#. xxoMA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3146916\n" +"help.text" +msgid "Field" +msgstr "" + +#. 4KDzZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156372\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." +msgstr "" + +#. Z3pwF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145150\n" +"help.text" +msgid "Alias" +msgstr "" + +#. EDa3A +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146315\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." +msgstr "" + +#. vvWbt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155959\n" +"help.text" +msgid "In a SQL statement, aliases are defined as follows:" +msgstr "" + +#. CGsBz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149922\n" +"help.text" +msgid "SELECT column AS alias FROM table." +msgstr "" + +#. TWexq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159335\n" +"help.text" +msgid "For example:" +msgstr "" + +#. ynSGq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148478\n" +"help.text" +msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" +msgstr "" + +#. roTzi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148485\n" +"help.text" +msgid "Table" +msgstr "" + +#. GM9Sp +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3163665\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." +msgstr "" + +#. JGcfa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154207\n" +"help.text" +msgid "Sort" +msgstr "" + +#. uXuDt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150979\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." +msgstr "" + +#. XsqW8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150384\n" +"help.text" +msgid "Visible" +msgstr "" + +#. AAZfA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146133\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." +msgstr "" + +#. eQFRR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154714\n" +"help.text" +msgid "Criteria" +msgstr "" + +#. f3DvJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145134\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>" +msgstr "" + +#. qpADC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3152477\n" +"help.text" +msgid "or" +msgstr "" + +#. KFVy8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154585\n" +"help.text" +msgid "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." +msgstr "" + +#. eXvp7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148800\n" +"help.text" +msgid "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" +msgstr "" + +#. 5x8LE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148419\n" +"help.text" +msgid "Functions" +msgstr "" + +#. Cxhjn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153233\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." +msgstr "" + +#. qFuqw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id8760818\n" +"help.text" +msgid "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" +msgstr "" + +#. 9tdDn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150307\n" +"help.text" +msgid "Option" +msgstr "" + +#. kBvXF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152993\n" +"help.text" +msgid "Effect" +msgstr "" + +#. zCunm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155377\n" +"help.text" +msgid "No function" +msgstr "" + +#. kZMTN +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155533\n" +"help.text" +msgid "No function will be executed." +msgstr "" + +#. 6dWZZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3166420\n" +"help.text" +msgid "Average" +msgstr "" + +#. NfRNs +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154486\n" +"help.text" +msgid "Calculates the arithmetic mean of a field." +msgstr "" + +#. 6z2Kj +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149979\n" +"help.text" +msgid "Count" +msgstr "" + +#. rvWA5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155810\n" +"help.text" +msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." +msgstr "" + +#. UyAx2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151333\n" +"help.text" +msgid "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." +msgstr "" + +#. FNCC8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152889\n" +"help.text" +msgid "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." +msgstr "" + +#. 2ubvb +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153067\n" +"help.text" +msgid "Maximum" +msgstr "" + +#. ds4ey +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159221\n" +"help.text" +msgid "Determines the highest value of a record for that field." +msgstr "" + +#. EhSWy +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146866\n" +"help.text" +msgid "Minimum" +msgstr "" + +#. VxmeB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157982\n" +"help.text" +msgid "Determines the lowest value of a record for that field." +msgstr "" + +#. CvkuF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154828\n" +"help.text" +msgid "Sum" +msgstr "" + +#. 82gAC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154536\n" +"help.text" +msgid "Calculates the sum of the values of records for the associated fields." +msgstr "" + +#. zCzVC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148820\n" +"help.text" +msgid "Group" +msgstr "" + +#. tSPNG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149438\n" +"help.text" +msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." +msgstr "" + +#. qHfpD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156038\n" +"help.text" +msgid "You can also enter function calls directly into the SQL statement. The syntax is:" +msgstr "" + +#. Qg6Ue +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156340\n" +"help.text" +msgid "SELECT FUNCTION(column) FROM table." +msgstr "" + +#. qAAoF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155075\n" +"help.text" +msgid "For example, the function call in SQL for calculating a sum is:" +msgstr "" + +#. VrHLf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154591\n" +"help.text" +msgid "SELECT SUM(\"Price\") FROM \"Article\"." +msgstr "" + +#. dABCo +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159205\n" +"help.text" +msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." +msgstr "" + +#. BVC6J +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148651\n" +"help.text" +msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." +msgstr "" + +#. WkboS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155098\n" +"help.text" +msgid "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." +msgstr "" + +#. 98GCC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155539\n" +"help.text" +msgid "The corresponding function in an SQL statement is:" +msgstr "" + +#. WACG9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149425\n" +"help.text" +msgid "SELECT FUNCTION() AS alias FROM table" +msgstr "" + +#. EjzuD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3144431\n" +"help.text" +msgid "Example:" +msgstr "" + +#. G9URE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154614\n" +"help.text" +msgid "SELECT COUNT(*) AS count FROM \"Item\"" +msgstr "" + +#. xiNnR +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154610\n" +"help.text" +msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." +msgstr "" + +#. EHACK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154644\n" +"help.text" +msgid "<emph>Examples</emph>" +msgstr "" + +#. N5CBE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151120\n" +"help.text" +msgid "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" +msgstr "" + +#. P5hJD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155144\n" +"help.text" +msgid "The following steps are required to create a query containing all suppliers who deliver more than three items." +msgstr "" + +#. ZhRQD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153240\n" +"help.text" +msgid "Insert the \"Item\" and \"Suppliers\" tables into the query design." +msgstr "" + +#. LMRUV +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148807\n" +"help.text" +msgid "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." +msgstr "" + +#. qWhFA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3161652\n" +"help.text" +msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function." +msgstr "" + +#. TgPA2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151009\n" +"help.text" +msgid "Enter >3 as a criterion and disable the Visible field." +msgstr "" + +#. VwEhF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145601\n" +"help.text" +msgid "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and choose the Group function." +msgstr "" + +#. zsjaa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147512\n" +"help.text" +msgid "Run the query." +msgstr "" + +#. EzQsj +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148638\n" +"help.text" +msgid "If the \"price\" (for the individual price of an article) and \"Supplier_No\" (for the supplier of the article) fields exist in the \"Item\" table, you can obtain the average price of the item that a supplier provides with the following query:" +msgstr "" + +#. qAByp +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153045\n" +"help.text" +msgid "Insert the \"Item\" table into the query design." +msgstr "" + +#. tjfuE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149802\n" +"help.text" +msgid "Double-click the \"Price\" and \"Supplier_No\" fields." +msgstr "" + +#. 6dBkt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153554\n" +"help.text" +msgid "Enable the <emph>Function</emph> line and select the Average function from the \"Price\" field." +msgstr "" + +#. x8JB3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155597\n" +"help.text" +msgid "You can also enter \"Average\" in the line for the alias name (without quotation marks)." +msgstr "" + +#. D4A9u +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151191\n" +"help.text" +msgid "Choose Group for the \"Supplier_No\" field." +msgstr "" + +#. BUYS9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155547\n" +"help.text" +msgid "Run the query." +msgstr "" + +#. EkHzB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147549\n" +"help.text" +msgid "The following context menu commands and symbols are available:" +msgstr "" + +#. PesFs +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3154172\n" +"help.text" +msgid "Functions" +msgstr "" + +#. BchuJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150414\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>" +msgstr "" + +#. yx5XE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149872\n" +"help.text" +msgid "Table Name" +msgstr "" + +#. ELTGJ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147246\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the table name.</ahelp>" +msgstr "" + +#. DDFEA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145117\n" +"help.text" +msgid "Alias Name" +msgstr "" + +#. LDFZB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155754\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the alias name.</ahelp>" +msgstr "" + +#. wnNhq +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153298\n" +"help.text" +msgid "Distinct Values" +msgstr "" + +#. 23sAF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147500\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)." +msgstr "" + +#. RZED7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150436\n" +"help.text" +msgid "For example, if the name \"Smith\" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name \"Smith\" will occur only once." +msgstr "" + +#. 2GvRf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152352\n" +"help.text" +msgid "For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have \"Smith in Chicago\" once in your address book and \"Smith in London\" twice. With the<emph> Distinct Values</emph> command, the query will use the two fields \"last name\" and \"city\" and return the query result \"Smith in Chicago\" once and \"Smith in London\" once." +msgstr "" + +#. m5UcG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149825\n" +"help.text" +msgid "In SQL, this command corresponds to the DISTINCT predicate." +msgstr "" + +#. GHsJd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153290\n" +"help.text" +msgid "Limit" +msgstr "" + +#. MijJg +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147501\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>" +msgstr "" + +#. B6S5f +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152350\n" +"help.text" +msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria." +msgstr "" + +#. MGqK3 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3148926\n" +"help.text" +msgid "Formulating filter conditions" +msgstr "" + +#. iFSpm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153162\n" +"help.text" +msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:" +msgstr "" + +#. fXeDd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149044\n" +"help.text" +msgid "Operator" +msgstr "" + +#. mfdEx +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152471\n" +"help.text" +msgid "Meaning" +msgstr "" + +#. mBZgC +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147407\n" +"help.text" +msgid "Condition is satisfied if..." +msgstr "" + +#. gqkRK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153026\n" +"help.text" +msgid "equal to" +msgstr "" + +#. hw7KZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148895\n" +"help.text" +msgid "... the content of the field is identical to the indicated expression." +msgstr "" + +#. A8XJU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153120\n" +"help.text" +msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed." +msgstr "" + +#. mWwUE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145223\n" +"help.text" +msgid "not equal to" +msgstr "" + +#. Db7BG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145635\n" +"help.text" +msgid "... the content of the field does not correspond to the specified expression." +msgstr "" + +#. dtjkU +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146815\n" +"help.text" +msgid "greater than" +msgstr "" + +#. gCWug +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149150\n" +"help.text" +msgid "... the content of the field is greater than the specified expression." +msgstr "" + +#. QkAKk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147379\n" +"help.text" +msgid "less than" +msgstr "" + +#. xxPdk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150375\n" +"help.text" +msgid "... the content of the field is less than the specified expression." +msgstr "" + +#. 4aJjX +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150636\n" +"help.text" +msgid "greater than or equal to" +msgstr "" + +#. 2rwQm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154584\n" +"help.text" +msgid "... the content of the field is greater than or equal to the specified expression." +msgstr "" + +#. ADRZk +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154052\n" +"help.text" +msgid "less than or equal to" +msgstr "" + +#. 9KtmZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157902\n" +"help.text" +msgid "... the content of the field is less than or equal to the specified expression." +msgstr "" + +#. DBXG9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154630\n" +"help.text" +msgid "$[officename] command" +msgstr "" + +#. Yo7MG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150484\n" +"help.text" +msgid "SQL command" +msgstr "" + +#. pJay6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154158\n" +"help.text" +msgid "Meaning" +msgstr "" + +#. qmaX5 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149433\n" +"help.text" +msgid "Condition is satisfied if..." +msgstr "" + +#. do6XQ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3143236\n" +"help.text" +msgid "is null" +msgstr "" + +#. NPqBL +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154744\n" +"help.text" +msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)." +msgstr "" + +#. 7Rfbd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151229\n" +"help.text" +msgid "is not empty" +msgstr "" + +#. w3Tva +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3145304\n" +"help.text" +msgid "... the field is not empty, i.e it contains data." +msgstr "" + +#. GGKUH +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153891\n" +"help.text" +msgid "placeholder (*) for any number of characters" +msgstr "" + +#. gbEWB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148887\n" +"help.text" +msgid "placeholder (?) for exactly one character" +msgstr "" + +#. tBQfA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"bm_id3157985\n" +"help.text" +msgid "<bookmark_value>placeholders; in SQL queries</bookmark_value>" +msgstr "" + +#. agxhB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157985\n" +"help.text" +msgid "placeholder (%) for any number of characters" +msgstr "" + +#. EE9ii +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147422\n" +"help.text" +msgid "Placeholder (_) for exactly one character" +msgstr "" + +#. za5g2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154845\n" +"help.text" +msgid "is an element of" +msgstr "" + +#. 2Y3zW +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156130\n" +"help.text" +msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the %PRODUCTNAME interface." +msgstr "" + +#. CPJyr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150271\n" +"help.text" +msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character." +msgstr "" + +#. AAEXi +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159141\n" +"help.text" +msgid "Is not an element of" +msgstr "" + +#. 9vFBZ +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3161664\n" +"help.text" +msgid "... the field does not contain data having the specified expression." +msgstr "" + +#. CD2Ra +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159184\n" +"help.text" +msgid "falls within the interval [x,y]" +msgstr "" + +#. cDe2u +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154395\n" +"help.text" +msgid "... the field contains a data value that lies between the two values x and y." +msgstr "" + +#. KYAXv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155498\n" +"help.text" +msgid "Does not fall within the interval [x,y]" +msgstr "" + +#. cVfAF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148992\n" +"help.text" +msgid "... the field contains a data value that does not lie between the two values x and y." +msgstr "" + +#. DBBQE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159167\n" +"help.text" +msgid "Note that semicolons are used as separators in all value lists!" +msgstr "" + +#. evEuh +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154809\n" +"help.text" +msgid "contains a, b, c..." +msgstr "" + +#. eeFC2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148399\n" +"help.text" +msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters" +msgstr "" + +#. JXq76 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150679\n" +"help.text" +msgid "does not contain a, b, c..." +msgstr "" + +#. U5doB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3158439\n" +"help.text" +msgid "... the field does not contain one of the specified expressions a, b, c,..." +msgstr "" + +#. cECKt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149248\n" +"help.text" +msgid "has the value True" +msgstr "" + +#. fbgDt +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148524\n" +"help.text" +msgid "... the field name has the value True." +msgstr "" + +#. 39zcD +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149955\n" +"help.text" +msgid "has the value false" +msgstr "" + +#. fGHY6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146850\n" +"help.text" +msgid "... the field data value is set to false." +msgstr "" + +#. qQETa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3155954\n" +"help.text" +msgid "Examples" +msgstr "" + +#. 8GaiA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150948\n" +"help.text" +msgid "returns field names with the field content \"Ms.\"" +msgstr "" + +#. C3BDE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id315094A\n" +"help.text" +msgid "returns dates that occurred before January 10, 2001" +msgstr "" + +#. T7ZhS +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147332\n" +"help.text" +msgid "returns records with field content such as \"give\" and \"gave\"." +msgstr "" + +#. f6T3F +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155350\n" +"help.text" +msgid "returns records with field contents such as \"Sun\"." +msgstr "" + +#. AvbKu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159406\n" +"help.text" +msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)." +msgstr "" + +#. 3tymM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149712\n" +"help.text" +msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number." +msgstr "" + +#. uusce +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147279\n" +"help.text" +msgid "returns records that do not contain \"Smith\"." +msgstr "" + +#. AJ8Xo +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146073\n" +"help.text" +msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}" +msgstr "" + +#. Cy7Cc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150661\n" +"help.text" +msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}" +msgstr "" + +#. newGb +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3148541\n" +"help.text" +msgid "The example will give you all of the entries where the item name begins with 'The *'. This means that you can also search for characters that would otherwise be interpreted as placeholders, such as *, ?, _, % or the period." +msgstr "" + +#. bAP3N +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150572\n" +"help.text" +msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" +msgstr "" + +#. VnKGf +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156052\n" +"help.text" +msgid "Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}" +msgstr "" + +#. mWG9p +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3153674\n" +"help.text" +msgid "Querying text fields" +msgstr "" + +#. sxYQF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149134\n" +"help.text" +msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly)." +msgstr "" + +#. BEp4G +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3149302\n" +"help.text" +msgid "Querying date fields" +msgstr "" + +#. D5mjw +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157998\n" +"help.text" +msgid "<emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax." +msgstr "" + +#. Zzuo6 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537341\n" +"help.text" +msgid "Date Type Element" +msgstr "" + +#. JKys2 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537342\n" +"help.text" +msgid "SQL Escape syntax #1 - may be obsolete" +msgstr "" + +#. AzkWz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537343\n" +"help.text" +msgid "SQL Escape syntax #2" +msgstr "" + +#. UJ6VA +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31537344\n" +"help.text" +msgid "SQL2 syntax" +msgstr "" + +#. 9V3Ky +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id315913111\n" +"help.text" +msgid "Date" +msgstr "" + +#. YNF3S +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31559471\n" +"help.text" +msgid "Time" +msgstr "" + +#. ssX5b +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id31509641\n" +"help.text" +msgid "DateTime" +msgstr "" + +#. FqZXM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149539\n" +"help.text" +msgid "Example: select {d '1999-12-31'} from world.years" +msgstr "" + +#. WJ4YB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149540\n" +"help.text" +msgid "Example: select * from mytable where years='1999-12-31'" +msgstr "" + +#. CZdA4 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150510\n" +"help.text" +msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" +msgstr "" + +#. HXdKT +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3150427\n" +"help.text" +msgid "Querying Yes/No fields" +msgstr "" + +#. xWzix +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149523\n" +"help.text" +msgid "To query Yes/No fields, use the following syntax for dBASE tables:" +msgstr "" + +#. A4Uh7 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153180\n" +"help.text" +msgid "Status" +msgstr "" + +#. FnXiE +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147481\n" +"help.text" +msgid "Query criterion" +msgstr "" + +#. e6DJr +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155187\n" +"help.text" +msgid "Example" +msgstr "" + +#. Guy7d +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3156092\n" +"help.text" +msgid "Yes" +msgstr "" + +#. p9WTn +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152414\n" +"help.text" +msgid "for dBASE tables: not equal to any given value" +msgstr "" + +#. RFrvz +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3151265\n" +"help.text" +msgid "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," +msgstr "" + +#. 3P4ZB +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152450\n" +"help.text" +msgid "No" +msgstr "" + +#. BzBAa +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150997\n" +"help.text" +msgid "." +msgstr "" + +#. TFsQG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3155331\n" +"help.text" +msgid "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." +msgstr "" + +#. 9KXzK +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3154179\n" +"help.text" +msgid "Null" +msgstr "" + +#. CwGZv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147035\n" +"help.text" +msgid "IS NULL" +msgstr "" + +#. dyXYc +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3159385\n" +"help.text" +msgid "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." +msgstr "" + +#. YWk5J +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3157888\n" +"help.text" +msgid "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." +msgstr "" + +#. mmVa8 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145772\n" +"help.text" +msgid "Parameter queries" +msgstr "" + +#. ND7xd +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905346795\n" +"help.text" +msgid "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run." +msgstr "" + +#. Be7XG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905439551\n" +"help.text" +msgid "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used." +msgstr "" + +#. 57vjv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905518123\n" +"help.text" +msgid "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" +msgstr "" + +#. DZCXm +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151905584287\n" +"help.text" +msgid "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases." +msgstr "" + +#. bGnxL +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151931441881\n" +"help.text" +msgid "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." +msgstr "" + +#. sSSB9 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3150585\n" +"help.text" +msgid "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\" name=\"subforms\">subforms</link>, to allow the user to restrict the displayed records." +msgstr "" + +#. DRj78 +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3151035\n" +"help.text" +msgid "Parameter Input" +msgstr "" + +#. BisCF +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3153596\n" +"help.text" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" +msgstr "" + +#. eGETM +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151924165870\n" +"help.text" +msgid "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system." +msgstr "" + +#. seFhG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id191120151939594217\n" +"help.text" +msgid "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria." +msgstr "" + +#. wRe6v +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"hd_id3145181\n" +"help.text" +msgid "SQL Mode" +msgstr "" + +#. 5avVu +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3147013\n" +"help.text" +msgid "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." +msgstr "" + +#. wDAAY +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152570\n" +"help.text" +msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created." +msgstr "" + +#. hBQFv +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3152412\n" +"help.text" +msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use." +msgstr "" + +#. kkuBG +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3146842\n" +"help.text" +msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode." +msgstr "" + +#. cBY6B +#: 02010100.xhp +msgctxt "" +"02010100.xhp\n" +"par_id3149632\n" +"help.text" +msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine." +msgstr "" + #. cLmBi #: main.xhp msgctxt "" diff --git a/source/ko/helpcontent2/source/text/sdraw/01.po b/source/ko/helpcontent2/source/text/sdraw/01.po index faec53e7bf6..96f547b597c 100644 --- a/source/ko/helpcontent2/source/text/sdraw/01.po +++ b/source/ko/helpcontent2/source/text/sdraw/01.po @@ -3,7 +3,7 @@ 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-06-22 17:23+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2017-05-10 03:29+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -574,6 +574,42 @@ msgctxt "" msgid "<ahelp hid=\"modules/sdraw/ui/insertlayer/name\">Enter a name for the new layer.</ahelp>" msgstr "" +#. ADN49 +#: insert_layer.xhp +msgctxt "" +"insert_layer.xhp\n" +"hd_id641596204028276\n" +"help.text" +msgid "Title" +msgstr "" + +#. waSME +#: insert_layer.xhp +msgctxt "" +"insert_layer.xhp\n" +"par_id271596204273624\n" +"help.text" +msgid "<ahelp hid=\"modules/sdraw/ui/insertlayer/title\">Enter the title of the layer.</ahelp>" +msgstr "" + +#. GGy5s +#: insert_layer.xhp +msgctxt "" +"insert_layer.xhp\n" +"hd_id791596204033460\n" +"help.text" +msgid "Description" +msgstr "" + +#. q5F9X +#: insert_layer.xhp +msgctxt "" +"insert_layer.xhp\n" +"par_id471596204283656\n" +"help.text" +msgid "<ahelp hid=\"modules/sdraw/ui/insertlayer/textview\">Enter a description of the layer.</ahelp>" +msgstr "" + #. WFSEL #: insert_layer.xhp msgctxt "" diff --git a/source/ko/helpcontent2/source/text/shared/00.po b/source/ko/helpcontent2/source/text/shared/00.po index 536f66e87ec..c537aa8fde6 100644 --- a/source/ko/helpcontent2/source/text/shared/00.po +++ b/source/ko/helpcontent2/source/text/shared/00.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-08-09 08:10+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -673,6 +673,24 @@ msgctxt "" msgid "Close the Options dialog and discard all changes done." msgstr "" +#. EFDpM +#: 00000001.xhp +msgctxt "" +"00000001.xhp\n" +"hd_id321597440555403\n" +"help.text" +msgid "Apply" +msgstr "" + +#. yJtrx +#: 00000001.xhp +msgctxt "" +"00000001.xhp\n" +"par_id51597440622057\n" +"help.text" +msgid "Applies the modified or selected values without closing the Options dialog." +msgstr "" + #. BRStA #: 00000001.xhp msgctxt "" diff --git a/source/ko/helpcontent2/source/text/shared/01.po b/source/ko/helpcontent2/source/text/shared/01.po index 614717c6fc6..95296369037 100644 --- a/source/ko/helpcontent2/source/text/shared/01.po +++ b/source/ko/helpcontent2/source/text/shared/01.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-08-09 08:12+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -25801,32 +25801,14 @@ msgctxt "" msgid "Add" msgstr "추가" -#. sqyhp +#. 5xkB3 #: 05200200.xhp msgctxt "" "05200200.xhp\n" "par_id3149827\n" "help.text" -msgid "<ahelp hid=\"cui/ui/linestyletabpage/BTN_ADD\">Creates a new line style using the current settings.</ahelp>" -msgstr "<ahelp hid=\"cui/ui/linestyletabpage/BTN_ADD\">현재 설정을 사용하여 새로운 선 스타일을 만듭니다.</ahelp>" - -#. T2pNA -#: 05200200.xhp -msgctxt "" -"05200200.xhp\n" -"hd_id3155338\n" -"help.text" -msgid "Name" -msgstr "이름" - -#. 4phXf -#: 05200200.xhp -msgctxt "" -"05200200.xhp\n" -"par_id3153681\n" -"help.text" -msgid "<ahelp hid=\".\">Enter a name.</ahelp>" -msgstr "<ahelp hid=\".\">이름을 입력합니다.</ahelp>" +msgid "<ahelp hid=\"cui/ui/linestyletabpage/BTN_ADD\">Creates a new line style using the current settings.</ahelp> Enter a name for the new line style." +msgstr "" #. 6Yvch #: 05200200.xhp @@ -27259,14 +27241,14 @@ msgctxt "" msgid "<ahelp hid=\".uno:FillShadow\">Adds a shadow to the selected object. If the object already has a shadow, the shadow is removed. If you click this icon when no object is selected, the shadow is added to the next object that you draw.</ahelp>" msgstr "<ahelp hid=\".uno:FillShadow\">선택한 개체에 그림자를 추가합니다. 개체에 이미 그림자가 있으면 원래 있던 그림자는 제거됩니다. 개체를 선택하지 않은 경우 이 아이콘을 클릭하면 다음에 그리는 개체에 그림자가 추가됩니다.</ahelp>" -#. DK9fc +#. gjXA8 #: 05210600.xhp msgctxt "" "05210600.xhp\n" "par_id3145068\n" "help.text" -msgid "<image id=\"img_id3149045\" src=\"cmd/sc_fillshadow.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3149045\">Icon</alt></image>" -msgstr "<image id=\"img_id3149045\" src=\"cmd/sc_fillshadow.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3149045\">아이콘</alt></image>" +msgid "<image id=\"img_id3149045\" src=\"cmd/sc_fillshadow.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149045\">Icon Add Shadow</alt></image>" +msgstr "" #. 6XJUi #: 05210600.xhp @@ -47275,13 +47257,13 @@ msgctxt "" msgid "PDF Export Digital Signature" msgstr "" -#. yMdYf +#. 9FdeP #: ref_pdf_export_digital_signature.xhp msgctxt "" "ref_pdf_export_digital_signature.xhp\n" "bm_id761574111929927\n" "help.text" -msgid "<bookmark_value>PDF export;digital signature</bookmark_value><bookmark_value>PDF export;sign PDF document</bookmark_value>" +msgid "<bookmark_value>PDF export;digital signature</bookmark_value><bookmark_value>PDF export;sign PDF document</bookmark_value><bookmark_value>PDF export;time stamp</bookmark_value>" msgstr "" #. ChX9A @@ -47464,24 +47446,6 @@ msgctxt "" msgid "<ahelp hid=\".\">These three fields allow you to optionally enter additional information about the digital signature that will be applied to the PDF (Where, by whom and why it was made). It will be embedded in the appropriate PDF fields and will be visible to anyone viewing the PDF. Each or all of the three fields may be left blank.</ahelp>" msgstr "" -#. dDtVb -#: ref_pdf_export_digital_signature.xhp -msgctxt "" -"ref_pdf_export_digital_signature.xhp\n" -"hd_id14661702\n" -"help.text" -msgid "Time Stamp Authority" -msgstr "" - -#. MUvFG -#: ref_pdf_export_digital_signature.xhp -msgctxt "" -"ref_pdf_export_digital_signature.xhp\n" -"par_id17868892\n" -"help.text" -msgid "<ahelp hid=\".\">Allows you to optionally select a Time Stamping Authority (TSA) URL. </ahelp>" -msgstr "" - #. Po9jA #: ref_pdf_export_digital_signature.xhp msgctxt "" @@ -47491,15 +47455,6 @@ msgctxt "" msgid "During the PDF signing process, the TSA will be used to obtain a digitally signed timestamp that is then embedded in the signature. This (RFC 3161) timestamp will allow anyone viewing the PDF to verify when the document was signed." msgstr "" -#. aTCsU -#: ref_pdf_export_digital_signature.xhp -msgctxt "" -"ref_pdf_export_digital_signature.xhp\n" -"par_id39089022\n" -"help.text" -msgid "The list of TSA URLs that can be selected is maintained under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph> </caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME - Security - TSAs</emph>." -msgstr "" - #. Gnocd #: ref_pdf_export_digital_signature.xhp msgctxt "" @@ -49561,6 +49516,114 @@ msgctxt "" msgid "<image src=\"media/helpimg/sw_signatureline02.png\" id=\"img_id551526579319036\" width=\"280px\" height=\"173px\"><alt id=\"alt_id641526579319036\">Signed Signature Line</alt></image>" msgstr "" +#. qMNEB +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"tit\n" +"help.text" +msgid "Time Stamp Authorities for Digital Signatures" +msgstr "" + +#. 53EtS +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"bm_id371597437796483\n" +"help.text" +msgid "<bookmark_value>time stamp;digital signature</bookmark_value> <bookmark_value>digital signature;time stamp</bookmark_value> <bookmark_value>time stamp authority</bookmark_value> <bookmark_value>time stamp for PDF digital signature</bookmark_value>" +msgstr "" + +#. QwKC7 +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"hd_id901597433114069\n" +"help.text" +msgid "<variable id=\"timestampauthorityh1\"><link href=\"text/shared/01/timestampauth.xhp\" name=\"tsa\">Time Stamp Authority</link></variable>" +msgstr "" + +#. L47NV +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_id961597433114070\n" +"help.text" +msgid "Time Stamp Authorities (TSA) issue digitally signed timestamps (RFC 3161) that are optionally used during signed PDF export." +msgstr "" + +#. jcBGy +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_id571597434502189\n" +"help.text" +msgid "Adding a trusted timestamp to an electronic signature provides a digital seal of data integrity and a trusted date and time of when the transaction took place. Recipients of documents with a trusted timestamp can verify when the document was digitally or electronically signed, as well as verify that the document was not altered after the date the timestamp vouches for." +msgstr "" + +#. HP6fQ +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_id721597436315261\n" +"help.text" +msgid "Choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME - Security - TSAs</menuitem>" +msgstr "" + +#. n27rF +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"hd_id281597438357127\n" +"help.text" +msgid "List of Time Stamp Authorities" +msgstr "" + +#. Msech +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_id701597438367251\n" +"help.text" +msgid "Display the list of existing TSAs." +msgstr "" + +#. 2TESq +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_idN106871\n" +"help.text" +msgid "Add" +msgstr "" + +#. vZdyd +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_idN1068B1\n" +"help.text" +msgid "Opens the <link href=\"text/shared/02/namedialog.xhp\" name=\"name dialog\">Name dialog</link> to enter a new Time Stamping Authority URL." +msgstr "" + +#. stnAc +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"hd_id251597435168013\n" +"help.text" +msgid "Delete" +msgstr "" + +#. PPq6D +#: timestampauth.xhp +msgctxt "" +"timestampauth.xhp\n" +"par_id381597435161810\n" +"help.text" +msgid "Deletes the selected entry in the list. Deletion is immediate and does not display a confirmation dialog." +msgstr "" + #. m3D8J #: webhtml.xhp msgctxt "" diff --git a/source/ko/helpcontent2/source/text/shared/02.po b/source/ko/helpcontent2/source/text/shared/02.po index 1ee9671fc62..da116c9fc91 100644 --- a/source/ko/helpcontent2/source/text/shared/02.po +++ b/source/ko/helpcontent2/source/text/shared/02.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-08-09 08:13+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -8809,14 +8809,14 @@ msgctxt "" msgid "<ahelp hid=\".\">If you create a <link href=\"text/shared/02/01170203.xhp\" name=\"subform\">subform</link>, enter the data field of the parent form responsible for the synchronization between parent and subform.</ahelp> To enter multiple values, press Shift + Enter after each input line." msgstr "" -#. FRDC5 +#. BB25h #: 01170203.xhp msgctxt "" "01170203.xhp\n" "par_id3149568\n" "help.text" -msgid "The subform is based on an <link href=\"text/shared/00/00000005.xhp#sql\" name=\"SQL\">SQL</link> query; more specifically, on a <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Parameter Query\">Parameter Query</link>. If a field name is entered in the <emph>Link master fields</emph> box, the data contained in that field in the main form is read to a variable that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL statement, this variable is compared to the table data that the subform refers to. Alternatively, you can enter the column name in the <emph>Link master fields</emph> box." -msgstr "하위 양식은 <link href=\"text/shared/00/00000005.xhp#sql\" name=\"SQL\">SQL</link> 쿼리, 특히 <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"매개 변수 쿼리\">매개 변수 쿼리</link>를 기반으로 합니다. <emph>마스터 필드 연결</emph> 상자에 필드 이름을 입력한 경우 주 양식에서 해당 필드에 있는 데이터를 읽어오는 변수를 <emph>슬레이브 필드 연결</emph>에 입력해야 합니다. 해당 SQL 문에서 이 변수는 하위 양식이 참조하는 테이블 데이터와 비교됩니다. 또는 <emph>마스터 필드 연결</emph> 상자에 열 이름을 입력할 수도 있습니다." +msgid "The subform is based on an <link href=\"text/shared/00/00000005.xhp#sql\" name=\"SQL\">SQL</link> query; more specifically, on a <link href=\"text/sdatabase/02010100.xhp\" name=\"Parameter Query\">Parameter Query</link>. If a field name is entered in the <emph>Link master fields</emph> box, the data contained in that field in the main form is read to a variable that you must enter in <emph>Link slave fields</emph>. In an appropriate SQL statement, this variable is compared to the table data that the subform refers to. Alternatively, you can enter the column name in the <emph>Link master fields</emph> box." +msgstr "" #. KAQ4c #: 01170203.xhp @@ -10528,14 +10528,14 @@ msgctxt "" msgid "Each $[officename] application has its own <emph>Styles</emph> window. Hence there are separate windows for <switchinline select=\"appl\"><caseinline select=\"WRITER\"><link href=\"text/swriter/01/05140000.xhp\" name=\"text documents\">text documents</link></caseinline><defaultinline>text documents</defaultinline></switchinline>, for <switchinline select=\"appl\"><caseinline select=\"CALC\"><link href=\"text/scalc/01/05100000.xhp\" name=\"spreadsheets\">spreadsheets</link></caseinline><defaultinline>spreadsheets</defaultinline></switchinline> and for <switchinline select=\"appl\"><caseinline select=\"IMPRESS\"><link href=\"text/simpress/01/05100000.xhp\" name=\"presentations/drawing documents\">presentations/drawing documents</link></caseinline><caseinline select=\"DRAW\"><link href=\"text/simpress/01/05100000.xhp\" name=\"presentations/drawing documents\">presentations/drawing documents</link></caseinline><defaultinline>presentations/drawing documents</defaultinline></switchinline>." msgstr "" -#. qTFgZ +#. VmzDY #: 01230000.xhp msgctxt "" "01230000.xhp\n" "par_id3143267\n" "help.text" -msgid "<image id=\"img_id3149999\" src=\"cmd/sc_designerdialog.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3149999\">Icon</alt></image>" -msgstr "<image id=\"img_id3149999\" src=\"cmd/sc_designerdialog.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3149999\">아이콘</alt></image>" +msgid "<image id=\"img_id3149999\" src=\"cmd/sc_designerdialog.svg\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149999\">Icon Styles</alt></image>" +msgstr "" #. Cwybn #: 01230000.xhp @@ -11761,14 +11761,14 @@ msgctxt "" msgid "The <emph>Arrow Style</emph> icon is only displayed when you create a drawing with the drawing functions. For more information, see the <link href=\"text/shared/01/05200300.xhp\" name=\"Line Styles\"><emph>Line Styles</emph></link> section of the Help." msgstr "<emph>화살표 스타일</emph> 아이콘은 그리기 기능을 사용하여 그리기를 만드는 경우에만 표시됩니다. 자세한 내용은 도움말의 <link href=\"text/shared/01/05200300.xhp\" name=\"선 스타일\"><emph>선 스타일!</emph></link> 섹션을 참조하십시오." -#. iZS9C +#. MeQRj #: 05020000.xhp msgctxt "" "05020000.xhp\n" "par_id3148548\n" "help.text" -msgid "<image id=\"img_id3145090\" src=\"cmd/sc_lineendstyle.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3145090\">Icon</alt></image>" -msgstr "<image id=\"img_id3145090\" src=\"cmd/sc_lineendstyle.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3145090\">아이콘</alt></image>" +msgid "<image id=\"img_id3145090\" src=\"cmd/sc_lineendstyle.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3145090\">Icon Line Ends</alt></image>" +msgstr "" #. RuXvo #: 05020000.xhp @@ -17026,13 +17026,13 @@ msgctxt "" msgid "Run SQL command directly" msgstr "SQL 명령 직접 실행" -#. KmBRr +#. 2GZmA #: 14030000.xhp msgctxt "" "14030000.xhp\n" "par_id3155535\n" "help.text" -msgid "Click the icon again to return to normal mode, in which the changes in the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"New Query Design\"><emph>New Query Design</emph></link> are synchronized with the permitted changes through SQL." +msgid "Click the icon again to return to normal mode, in which the changes in the <link href=\"text/sdatabase/02010100.xhp\" name=\"New Query Design\"><emph>New Query Design</emph></link> are synchronized with the permitted changes through SQL." msgstr "" #. tTG7m @@ -17053,13 +17053,13 @@ msgctxt "" msgid "<link href=\"text/shared/02/14040000.xhp\" name=\"Functions\">Functions</link>" msgstr "<link href=\"text/shared/02/14040000.xhp\" name=\"기능\">기능</link>" -#. JisGv +#. LfbjB #: 14040000.xhp msgctxt "" "14040000.xhp\n" "par_id3159224\n" "help.text" -msgid "<ahelp visibility=\"visible\" hid=\".uno:DBViewFunctions\">Displays the <emph>Function</emph> row in the lower part of the design view of the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link> window.</ahelp>" +msgid "<ahelp visibility=\"visible\" hid=\".uno:DBViewFunctions\">Displays the <emph>Function</emph> row in the lower part of the design view of the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link> window.</ahelp>" msgstr "" #. iGFfH @@ -17098,13 +17098,13 @@ msgctxt "" msgid "<link href=\"text/shared/02/14050000.xhp\" name=\"Table Name\">Table Name</link>" msgstr "<link href=\"text/shared/02/14050000.xhp\" name=\"테이블 이름\">테이블 이름</link>" -#. ZZDpV +#. vEiiV #: 14050000.xhp msgctxt "" "14050000.xhp\n" "par_id3154232\n" "help.text" -msgid "<ahelp hid=\".\">Displays the <emph>Table</emph> row in the lower part of the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link>.</ahelp>" +msgid "<ahelp hid=\".\">Displays the <emph>Table</emph> row in the lower part of the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link>.</ahelp>" msgstr "" #. t48DA @@ -17143,13 +17143,13 @@ msgctxt "" msgid "<link href=\"text/shared/02/14060000.xhp\" name=\"Alias\">Alias</link>" msgstr "<link href=\"text/shared/02/14060000.xhp\" name=\"별칭\">별칭</link>" -#. jd5Ew +#. tE9CF #: 14060000.xhp msgctxt "" "14060000.xhp\n" "par_id3148731\n" "help.text" -msgid "<ahelp visibility=\"visible\" hid=\".uno:DBViewAliases\">Displays the <emph>Alias</emph> row in the lower part of the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link>.</ahelp>" +msgid "<ahelp visibility=\"visible\" hid=\".uno:DBViewAliases\">Displays the <emph>Alias</emph> row in the lower part of the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\"><emph>Query Design</emph></link>.</ahelp>" msgstr "" #. CcbaZ @@ -17197,13 +17197,13 @@ msgctxt "" msgid "<link href=\"text/shared/02/14070000.xhp\" name=\"Distinct Values\">Distinct Values</link>" msgstr "<link href=\"text/shared/02/14070000.xhp\" name=\"단일 값\">단일 값</link>" -#. dwMdA +#. MhStz #: 14070000.xhp msgctxt "" "14070000.xhp\n" "par_id3154894\n" "help.text" -msgid "<ahelp hid=\".uno:DBDistinctValues\">Expands the created select statement of the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"SQL Query\"><emph>SQL Query</emph></link> in the current column by the parameter <emph>DISTINCT</emph>.</ahelp> The consequence is that identical values occurring multiple times are listed only once." +msgid "<ahelp hid=\".uno:DBDistinctValues\">Expands the created select statement of the <link href=\"text/sdatabase/02010100.xhp\" name=\"SQL Query\"><emph>SQL Query</emph></link> in the current column by the parameter <emph>DISTINCT</emph>.</ahelp> The consequence is that identical values occurring multiple times are listed only once." msgstr "" #. EXAFG @@ -19240,13 +19240,40 @@ msgctxt "" msgid "Limit" msgstr "라임" -#. bXFUp +#. SWTG4 #: limit.xhp msgctxt "" "limit.xhp\n" "par_id3154894\n" "help.text" -msgid "<ahelp hid=\".\">Expands the created select statement of the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"SQL Query\">SQL Query</link> by the LIMIT X clause</ahelp>. This can be used to limit your SQL Query results to those that fall within the first X number of it." +msgid "<ahelp hid=\".\">Expands the created select statement of the <link href=\"text/sdatabase/02010100.xhp\" name=\"SQL Query\">SQL Query</link> by the LIMIT X clause</ahelp>. This can be used to limit your SQL Query results to those that fall within the first X number of it." +msgstr "" + +#. bbAX7 +#: namedialog.xhp +msgctxt "" +"namedialog.xhp\n" +"tit\n" +"help.text" +msgid "Enter Name" +msgstr "" + +#. pymwL +#: namedialog.xhp +msgctxt "" +"namedialog.xhp\n" +"hd_id581597430248366\n" +"help.text" +msgid "<variable id=\"namedialogh1\"><link href=\"text/shared/02/namedialog.xhp\" name=\"Name\">Enter Name Dialog</link></variable>" +msgstr "" + +#. edfxG +#: namedialog.xhp +msgctxt "" +"namedialog.xhp\n" +"par_id3153681\n" +"help.text" +msgid "Enter a name or any requested text on the label." msgstr "" #. Ae3Qb diff --git a/source/ko/helpcontent2/source/text/shared/explorer/database.po b/source/ko/helpcontent2/source/text/shared/explorer/database.po index 033055d04ea..5a457cc67da 100644 --- a/source/ko/helpcontent2/source/text/shared/explorer/database.po +++ b/source/ko/helpcontent2/source/text/shared/explorer/database.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2018-11-12 13:50+0000\n" "Last-Translator: Anonymous Pootle User\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -16,2220 +16,6 @@ msgstr "" "X-Generator: LibreOffice\n" "X-POOTLE-MTIME: 1542030622.000000\n" -#. E3MVS -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"tit\n" -"help.text" -msgid "Query Design" -msgstr "쿼리 디자인" - -#. Ys2sC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"bm_id3153323\n" -"help.text" -msgid "<bookmark_value>views; creating database views (Base)</bookmark_value> <bookmark_value>queries; creating in design view (Base)</bookmark_value> <bookmark_value>designing; queries (Base)</bookmark_value> <bookmark_value>design view; queries/views (Base)</bookmark_value> <bookmark_value>joining;tables (Base)</bookmark_value> <bookmark_value>tables in databases; joining for queries (Base)</bookmark_value> <bookmark_value>queries; joining tables (Base)</bookmark_value> <bookmark_value>tables in databases; relations (Base)</bookmark_value> <bookmark_value>relations; joining tables (Base)</bookmark_value> <bookmark_value>queries; deleting table links (Base)</bookmark_value> <bookmark_value>criteria of query design (Base)</bookmark_value> <bookmark_value>queries; formulating filter conditions (Base)</bookmark_value> <bookmark_value>filter conditions;in queries (Base)</bookmark_value> <bookmark_value>parameters; queries (Base)</bookmark_value> <bookmark_value>queries; parameter queries (Base)</bookmark_value> <bookmark_value>SQL; queries (Base)</bookmark_value> <bookmark_value>native SQL (Base)</bookmark_value>" -msgstr "<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>Native SQL(Base)</bookmark_value>" - -#. T4W7n -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3153394\n" -"help.text" -msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design</link>" -msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"쿼리 디자인\">쿼리 디자인</link>" - -#. GU8Jd -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156411\n" -"help.text" -msgid "<ahelp hid=\".\">The <emph>Query Design View </emph>allows you to create and edit a database query.</ahelp>" -msgstr "<ahelp hid=\".\"><emph>쿼리 디자인 보기</emph>를 사용하여 데이터베이스 쿼리를 만들고 편집할 수 있습니다.</ahelp>" - -#. vGBE5 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id7024140\n" -"help.text" -msgid "Most databases use queries to filter or to sort database tables to display records on your computer. Views offer the same functionality as queries, but on the server side. If your database is on a server that supports views, you can use views to filter the records on the server to speed up the display time." -msgstr "대부분의 데이터베이스는 데이터베이스 테이블을 필터링하거나 정렬하는 쿼리를 사용하여 컴퓨터의 레코드를 표시합니다. 보기는 쿼리와 동일한 기능을 제공하지만 서버 사이드에서 작동합니다. 데이터베이스가 보기를 지원하는 서버에 있으면 보기를 사용하여 서버의 레코드를 필터링함으로써 표시 시간을 단축할 수 있습니다." - -#. WZcUE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159176\n" -"help.text" -msgid "Selecting the <emph>Create View</emph> command from the <emph>Tables</emph> tab page of a database document, you see the <emph>View Design</emph> window that resembles the <emph>Query Design</emph> window described here." -msgstr "데이터베이스 문서의 <emph>테이블</emph> 탭 페이지에서 <emph>보기 만들기</emph> 명령을 선택하면 여기서 설명한 <emph>쿼리 디자인</emph> 창과 유사한 <emph>보기 디자인</emph> 창이 표시됩니다." - -#. JMyC7 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id8307138\n" -"help.text" -msgid "The Query Design window layout is stored with a created query, but cannot be stored with a created view." -msgstr "쿼리 디자인 창 레이아웃은 생성된 쿼리에 저장됩니다. 하지만 생성된 보기에는 저장되지 않습니다." - -#. TEBj6 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3149233\n" -"help.text" -msgid "The Design View" -msgstr "디자인 보기" - -#. zkTQc -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145673\n" -"help.text" -msgid "To create a query, click the <emph>Queries</emph> icon in a database document, then click <emph>Create Query in Design View</emph>." -msgstr "쿼리를 만들려면 데이터베이스 문서에서 <emph>쿼리</emph> 아이콘을 클릭하고 <emph>디자인 보기에서 쿼리 만들기</emph>를 클릭합니다." - -#. MAraF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150255\n" -"help.text" -msgid "The lower pane of the Design View is where you <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">define</link> the query. To define a query, specify the database <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">field names</link> to include and the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">criteria</link> for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key." -msgstr "" - -#. GMVkG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152474\n" -"help.text" -msgid "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." -msgstr "쿼리 디자인 보기 창의 맨 위에 <emph>쿼리 디자인</emph> 도구 막대와 <emph>디자인</emph> 도구 막대의 <link href=\"text/shared/main0214.xhp\" name=\"아이콘\">아이콘</link> 이 표시됩니다." - -#. hYsxY -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147559\n" -"help.text" -msgid "If you want to test a query, double-click the query name in the database document. The query result is displayed in a table similar to the Data Source View. Note: the table displayed is only temporary." -msgstr "쿼리를 테스트하려면 데이터베이스 문서에서 쿼리 이름을 더블 클릭합니다. [데이터 원본 보기]와 유사한 테이블에 쿼리 결과가 표시됩니다. 참고: 표시된 테이블은 임시로 작성된 것입니다." - -#. B4HEH -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id8226264\n" -"help.text" -msgid "Keys in Query Design View" -msgstr "쿼리 디자인 보기의 키" - -#. Cvd4o -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id2341074\n" -"help.text" -msgid "Key" -msgstr "키" - -#. mCy9S -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id4384289\n" -"help.text" -msgid "Function" -msgstr "함수" - -#. yybiC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id5839106\n" -"help.text" -msgid "F4" -msgstr "F4" - -#. FMTZD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id8554338\n" -"help.text" -msgid "Preview" -msgstr "미리보기" - -#. YQhGF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id1254921\n" -"help.text" -msgid "F5" -msgstr "F5" - -#. C9yhE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id7636646\n" -"help.text" -msgid "Run Query" -msgstr "쿼리 실행" - -#. jdEeJ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id8579363\n" -"help.text" -msgid "F7" -msgstr "F7" - -#. 6Y6Uw -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3227942\n" -"help.text" -msgid "Add Table or Query" -msgstr "테이블 또는 쿼리 추가" - -#. WN7wR -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154939\n" -"help.text" -msgid "Browse" -msgstr "찾아보기" - -#. 5y4VZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148799\n" -"help.text" -msgid "When you open the query design for the first time, you see a dialog in which you must first select the table or query that will be the basis for your new query." -msgstr "쿼리 디자인을 처음 열면, 새 쿼리의 기초가 되는 테이블이나 쿼리를 선택하는 대화 상자가 나타납니다." - -#. FBQA9 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3144762\n" -"help.text" -msgid "<ahelp hid=\"HID_CTL_QRYDGNTAB\">Double-click fields to add them to the query. Drag-and-drop to define relations.</ahelp>" -msgstr "<ahelp hid=\"HID_CTL_QRYDGNTAB\">필드를 더블 클릭하면 쿼리에 추가됩니다. 관계를 지정하려면 끌어서 놓습니다.</ahelp>" - -#. eG8FD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157894\n" -"help.text" -msgid "While designing a query, you cannot modify the selected tables." -msgstr "쿼리를 디자인할 때 선택한 테이블을 수정할 수 없습니다." - -#. NLywF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3149562\n" -"help.text" -msgid "Remove tables" -msgstr "테이블 제거" - -#. TbQzA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150685\n" -"help.text" -msgid "To remove the table from Design View, click the upper border of the table window and display the context menu. You can use the <emph>Delete</emph> command to remove the table from the Design View. Another option is to press the Delete key." -msgstr "디자인 보기에서 테이블을 삭제하려면 테이블 창의 위쪽 여백을 클릭한 다음 콘텍스트 메뉴를 불러오십시오. <emph>삭제</emph> 명령어를 사용하여 테이블이 디자인 보기에서 삭제됩니다. 또는 (삭제) 키를 사용할 수도 있습니다." - -#. VLTKB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3150012\n" -"help.text" -msgid "Move table and modify table size" -msgstr "테이블 이동과 테이블 크기 변경" - -#. amBsQ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146922\n" -"help.text" -msgid "You can resize and arrange the tables according to your preferences. To move tables, drag the upper border to the desired position. Enlarge or reduce the size in which the table is displayed by positioning the mouse cursor on a border or on a corner and dragging the table until it is the desired size." -msgstr "사용자가 원하는대로 테이블을 정렬하고 그 크기를 변경할 수 있습니다. 테이블을 이동하려면 마우스로 테이블의 위쪽 여백을 포착한 다음 원하는 위치로 테이블을 끌어오십시오. 테이블 표시를 확대하거나 축소하려면 여백이나 모서리를 끌어오십시오." - -#. UoCRG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3145365\n" -"help.text" -msgid "Table Relations" -msgstr "테이블 관계" - -#. BFCxB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154145\n" -"help.text" -msgid "If there are data relations between a field name in one table and a field name in another table, you can use these relations for your query." -msgstr "테이블의 데이터 필드와 다른 테이블의 데이터 필드 사이에 데이터 관계가 있을 경우 이 관계를 사용자의 쿼리에 이용할 수 있습니다." - -#. jcLbE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152577\n" -"help.text" -msgid "If, for example, you have a spreadsheet for articles identified by an article number, and a spreadsheet for customers in which you record all articles that a customer orders using the corresponding article numbers, then there is a relationship between the two \"article number\" data fields. If you now want to create a query that returns all articles that a customer has ordered, you must retrieve data from two spreadsheets. To do this, you must inform $[officename] about the relationship which exists between the data in the two spreadsheets." -msgstr "" - -#. FspJi -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155302\n" -"help.text" -msgid "To do this, click a field name in a table (for example, the field name \"Item-Number\" from the Customer table), hold down the mouse button and then drag the field name to the field name of the other table (\"Item-Number\" from the Item table). When you release the mouse button, a line connecting the two fields between the two table windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." -msgstr "" - -#. FmAaU -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153876\n" -"help.text" -msgid "The creation of a query that is based on several related sheets is only possible if you use $[officename] as the interface for a relational database." -msgstr "$[officename]을(를) 관계형 데이터베이스에 대한 인터페이스로 사용하는 경우에만 여러 관련 시트를 기반으로 하는 쿼리를 만들 수 있습니다." - -#. N2f8q -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145646\n" -"help.text" -msgid "You cannot access tables from different databases in a query. Queries involving multiple tables can only be created within one database." -msgstr "각기 다른 데이터베이스의 테이블을 하나의 쿼리로 액세스할 수 없습니다. 여러 테이블과 관련된 쿼리는 한 데이터베이스 내에서만 만들 수 있습니다." - -#. nLSiq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3153279\n" -"help.text" -msgid "Specifying the relation type" -msgstr "" - -#. kDhFD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154791\n" -"help.text" -msgid "If you double-click on the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of relation in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog." -msgstr "" - -#. rAkmw -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150094\n" -"help.text" -msgid "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">Edit Join Properties.</ahelp> Alternatively, press Tab until the line is selected, then press Shift+F10 to display the context menu and there choose the command <emph>Edit</emph>. Some databases support only a subset of the possible join types." -msgstr "<ahelp hid=\"HID_QUERY_EDIT_JOINCONNECTION\" visibility=\"hidden\">결합 속성을 편집합니다.</ahelp>또는 라인이 선택될 때까지 Tab 키를 누른 다음, 콘텍스트 메뉴를 보기 위하여 Shift + F10 을 누르고 이 메뉴에서 <emph>편집</emph> 명령을 선택합니다. 일부의 데이터베이스는 결합 유형의 하위집합만을 지원합니다." - -#. n3PMB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3155851\n" -"help.text" -msgid "Deleting relations" -msgstr "관계 삭제" - -#. jCb4H -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156178\n" -"help.text" -msgid "To delete a relation between two tables, click the connection line and then press the Delete key." -msgstr "두 테이블 사이의 관계를 삭제하려면 마우스를 사용하여 연결선을 클릭한 다음 (삭제) 키를 누르십시오." - -#. 3UCig -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150715\n" -"help.text" -msgid "Alternatively, delete the respective entries in <emph>Fields involved </emph>in the <emph>Relations</emph> dialog. Or press Tab until the connecting vector is displayed highlighted, then press Shift+F10 to open the context menu and select <emph>Delete </emph>command." -msgstr "또는 <emph>관계</emph> 대화 상자의 <emph>사용된 필드</emph>에서 해당 항목을 삭제합니다. 또한 연결 벡터가 강조 표시될 때까지 Tab 키를 누른 다음 Shift + F10 을 눌러 콘텍스트 메뉴를 열고 <emph>삭제</emph> 명령을 선택합니다." - -#. pBybB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3151208\n" -"help.text" -msgid "Defining the query" -msgstr "" - -#. yGfhU -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3158416\n" -"help.text" -msgid "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">Select conditions to define the query.</ahelp> Each column of the design table accepts a data field for the query. The conditions in one row are linked with a Boolean AND." -msgstr "<ahelp hid=\"HID_CTL_QRYDGNCRIT\">쿼리를 지정할 조건을 선택합니다.</ahelp> 디자인 테이블의 각 열은 쿼리의 데이터 필드를 포함합니다. 한 행의 조건은 부울 AND로 연결됩니다." - -#. UB5nG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154161\n" -"help.text" -msgid "Specifying field names" -msgstr "" - -#. jyKMG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146791\n" -"help.text" -msgid "First, select all field names from the tables that you want to add to the query. You can do this either by drag-and-drop or by double-clicking a field name in the table window. With the drag-and-drop method, use the mouse to drag a field name from the table window into the lower area of the query design window. As you do this, you can decide which column in the query design window will receive the selected field. A field name can also be selected by double-clicking. It will then be added to the next free column in the query design window." -msgstr "" - -#. 66Dcr -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3150750\n" -"help.text" -msgid "Deleting field names" -msgstr "데이터 필드 삭제" - -#. AbhrW -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154479\n" -"help.text" -msgid "To remove a field name from the query, click the column header of the field and choose the <emph>Delete</emph> command on the context menu for the column." -msgstr "데이터 필드를 쿼리에서 삭제하려면 마우스를 사용하여 필드의 열 머리글을 클릭한 다음 열의 콘텍스트 메뉴에서 <emph>삭제</emph> 명령어를 불러오십시오." - -#. V92gB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3155764\n" -"help.text" -msgid "Saving the query" -msgstr "" - -#. 2kWoA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148481\n" -"help.text" -msgid "Use the <emph>Save</emph> icon on the Standard toolbar to save the query. You will see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema name." -msgstr "" - -#. M9UQL -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154362\n" -"help.text" -msgid "Schema" -msgstr "구성표" - -#. 4Jwm3 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154754\n" -"help.text" -msgid "<ahelp hid=\"dbaccess/ui/savedialog/schema\">Enter the name of the schema that is assigned to the query or table view.</ahelp>" -msgstr "<ahelp hid=\"dbaccess/ui/savedialog/schema\">쿼리 또는 테이블 보기에 지정할 스키마 이름을 입력합니다.</ahelp>" - -#. 6Q72c -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3156717\n" -"help.text" -msgid "Query name or table view name" -msgstr "쿼리/테이블 보기 이름" - -#. Cw73K -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154253\n" -"help.text" -msgid "<ahelp hid=\"dbaccess/ui/savedialog/title\">Enter the name of the query or table view.</ahelp>" -msgstr "<ahelp hid=\"dbaccess/ui/savedialog/title\">쿼리 또는 테이블 보기의 이름을 입력합니다.</ahelp>" - -#. qgbNu -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3163805\n" -"help.text" -msgid "Filtering data" -msgstr "데이터 필터링" - -#. Q9pG5 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154964\n" -"help.text" -msgid "To filter data for the query, set the desired criteria in the lower area of the query design window. The following options are available:" -msgstr "" - -#. xxoMA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3146916\n" -"help.text" -msgid "Field" -msgstr "필드" - -#. 4KDzZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156372\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that is referred to in the Query. All settings made in the filter option rows refer to this field.</ahelp> If you activate a cell here with a mouse click you'll see an arrow button, which enables you to select a field. The \"Table name.*\" option selects all data fields with the effect that the specified criteria will be applied to all table fields." -msgstr "" - -#. Z3pwF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3145150\n" -"help.text" -msgid "Alias" -msgstr "별칭" - -#. EDa3A -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146315\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Specifies an alias. This alias will be listed in the query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field is named PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as the alias." -msgstr "" - -#. vvWbt -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155959\n" -"help.text" -msgid "In a SQL statement, aliases are defined as follows:" -msgstr "" - -#. CGsBz -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149922\n" -"help.text" -msgid "SELECT column AS alias FROM table." -msgstr "SELECT column AS alias FROM table." - -#. TWexq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159335\n" -"help.text" -msgid "For example:" -msgstr "예를 들면 다음과 같습니다." - -#. ynSGq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148478\n" -"help.text" -msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" -msgstr "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" - -#. roTzi -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3148485\n" -"help.text" -msgid "Table" -msgstr "테이블" - -#. GM9Sp -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3163665\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">The corresponding database table of the selected data field is listed here.</ahelp> If you activate this cell with a mouse click, an arrow will appear which enables you to select a different table for the current query." -msgstr "" - -#. JGcfa -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154207\n" -"help.text" -msgid "Sort" -msgstr "정렬" - -#. uXuDt -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150979\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click on this cell, you can choose a sort option: ascending, descending and unsorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options at the database level." -msgstr "" - -#. XsqW8 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3150384\n" -"help.text" -msgid "Visible" -msgstr "표시" - -#. AAZfA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146133\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">If you mark the <emph>Visible</emph> property for a data field, that field will be visibly displayed in the resulting query</ahelp>. If you are only using a data field to formulate a condition or make a calculation, you do not necessarily need to display it." -msgstr "" - -#. eQFRR -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154714\n" -"help.text" -msgid "Criteria" -msgstr "기준" - -#. JdqLq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145134\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field is to be filtered.</ahelp>" -msgstr "" - -#. qpADC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3152477\n" -"help.text" -msgid "or" -msgstr "또는" - -#. KFVy8 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154585\n" -"help.text" -msgid "Here you can enter one additional filter criterion for each line. Multiple criteria in a single column will be interpreted as boolean OR." -msgstr "" - -#. eXvp7 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148800\n" -"help.text" -msgid "You can also use the context menu of the line headers in the lower area of the query design window to insert a filter based on a function:" -msgstr "" - -#. 5x8LE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3148419\n" -"help.text" -msgid "Functions" -msgstr "기능" - -#. Cxhjn -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153233\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Select a function to run in the query.</ahelp> The functions which are available here depend on those provided by the database engine." -msgstr "" - -#. qFuqw -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id8760818\n" -"help.text" -msgid "If you are working with the embedded HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" -msgstr "" - -#. 9tdDn -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150307\n" -"help.text" -msgid "Option" -msgstr "옵션" - -#. kBvXF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152993\n" -"help.text" -msgid "Effect" -msgstr "효과" - -#. zCunm -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155377\n" -"help.text" -msgid "No function" -msgstr "기능 없음" - -#. kZMTN -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155533\n" -"help.text" -msgid "No function will be executed." -msgstr "기능이 실행되지 않습니다." - -#. 6dWZZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3166420\n" -"help.text" -msgid "Average" -msgstr "교차점" - -#. NfRNs -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154486\n" -"help.text" -msgid "Calculates the arithmetic mean of a field." -msgstr "필드의 산술 평균을 계산합니다." - -#. 6z2Kj -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149979\n" -"help.text" -msgid "Count" -msgstr "개수" - -#. rvWA5 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155810\n" -"help.text" -msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." -msgstr "" - -#. UyAx2 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151333\n" -"help.text" -msgid "a) COUNT(*): Passing an asterisk as the argument counts all records in the table." -msgstr "a) COUNT(*): 별표를 인수로 이용할 경우 테이블의 모든 데이터 레코드가 계산됩니다." - -#. FNCC8 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152889\n" -"help.text" -msgid "b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted." -msgstr "" - -#. 2ubvb -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153067\n" -"help.text" -msgid "Maximum" -msgstr "최대" - -#. ds4ey -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159221\n" -"help.text" -msgid "Determines the highest value of a record for that field." -msgstr "" - -#. EhSWy -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146866\n" -"help.text" -msgid "Minimum" -msgstr "최소" - -#. VxmeB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157982\n" -"help.text" -msgid "Determines the lowest value of a record for that field." -msgstr "" - -#. CvkuF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154828\n" -"help.text" -msgid "Sum" -msgstr "합계" - -#. 82gAC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154536\n" -"help.text" -msgid "Calculates the sum of the values of records for the associated fields." -msgstr "" - -#. zCzVC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148820\n" -"help.text" -msgid "Group" -msgstr "그룹화" - -#. tSPNG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149438\n" -"help.text" -msgid "Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause." -msgstr "" - -#. qHfpD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156038\n" -"help.text" -msgid "You can also enter function calls directly into the SQL statement. The syntax is:" -msgstr "SQL 문에 직접 함수 호출을 입력할 수도 있습니다. 구문은 다음과 같습니다." - -#. Qg6Ue -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156340\n" -"help.text" -msgid "SELECT FUNCTION(column) FROM table." -msgstr "SELECT FUNCTION(column) FROM table." - -#. qAAoF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155075\n" -"help.text" -msgid "For example, the function call in SQL for calculating a sum is:" -msgstr "SQL에서 합계 계산 기능 호출은 예를 들어 다음과 같습니다:" - -#. VrHLf -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154591\n" -"help.text" -msgid "SELECT SUM(\"Price\") FROM \"Article\"." -msgstr "SELECT SUM(\"가격\") FROM \"항목\"." - -#. dABCo -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159205\n" -"help.text" -msgid "Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine." -msgstr "" - -#. BVC6J -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148651\n" -"help.text" -msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." -msgstr "" - -#. WkboS -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155098\n" -"help.text" -msgid "You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>." -msgstr "" - -#. 98GCC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155539\n" -"help.text" -msgid "The corresponding function in an SQL statement is:" -msgstr "SQL 설명에서 해당 기능 호출은 다음과 같습니다:" - -#. WACG9 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149425\n" -"help.text" -msgid "SELECT FUNCTION() AS alias FROM table" -msgstr "SELECT FUNCTION() AS alias FROM table" - -#. EjzuD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3144431\n" -"help.text" -msgid "Example:" -msgstr "예:" - -#. G9URE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154614\n" -"help.text" -msgid "SELECT COUNT(*) AS count FROM \"Item\"" -msgstr "SELECT COUNT(*) AS 개수 FROM \"항목\"" - -#. xiNnR -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154610\n" -"help.text" -msgid "If you run such a function, you cannot insert any additional columns for the query other than as an argument in a \"Group\" function." -msgstr "" - -#. EHACK -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154644\n" -"help.text" -msgid "<emph>Examples</emph>" -msgstr "<emph>예</emph>" - -#. N5CBE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151120\n" -"help.text" -msgid "In the following example, a query is run through two tables: an \"Item\" table with the \"Item_No\" field and a \"Suppliers\" table with the \"Supplier_Name\" field. In addition, both tables have a common field name \"Supplier_No.\"" -msgstr "다음의 예에서 두 테이블에 대한 쿼리가 실행됩니다: 하나는 \"항목_No\" 필드가 있는 \"항목\" 테이블이고 또 하나는 \"공급자_이름\" 필드가 있는 \"공급자\" 테이블입니다. 뿐만 아니라 두 테이블에는 공동의 데이터 필드인 \"공급자_No\"가 있습니다." - -#. P5hJD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155144\n" -"help.text" -msgid "The following steps are required to create a query containing all suppliers who deliver more than three items." -msgstr "3개 이상의 항목을 공급하는 모든 공급자가 포함된 쿼리를 만들려면 다음 단계가 필요합니다:" - -#. ZhRQD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153240\n" -"help.text" -msgid "Insert the \"Item\" and \"Suppliers\" tables into the query design." -msgstr "\"항목\"과 \"공급자\" 테이블을 쿼리 디자인에 삽입." - -#. LMRUV -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148807\n" -"help.text" -msgid "Link the \"Supplier_No\" fields of the two tables if there is not already a relation of this type." -msgstr "두 개 테이블 사이에 해당 관계가 없을 경우 두 테이블의 \"공급자_No\" 필드 연결." - -#. qWhFA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3161652\n" -"help.text" -msgid "Double-click on the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function." -msgstr "" - -#. TgPA2 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151009\n" -"help.text" -msgid "Enter >3 as a criterion and disable the Visible field." -msgstr "기준으로 >3 입력하고 표시 필드 숨기기." - -#. VwEhF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145601\n" -"help.text" -msgid "Double-click the \"Supplier_Name\" field in the \"Suppliers\" table and choose the Group function." -msgstr "\"공급자\" 테이블의 \"공급자_이름\" 필드 더블 클릭, 그룹화 기능 선택." - -#. zsjaa -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147512\n" -"help.text" -msgid "Run the query." -msgstr "쿼리를 실행합니다." - -#. EzQsj -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148638\n" -"help.text" -msgid "If the \"price\" (for the individual price of an article) and \"Supplier_No\" (for the supplier of the article) fields exist in the \"Item\" table, you can obtain the average price of the item that a supplier provides with the following query:" -msgstr "\"항목\" 테이블에 \"가격\" (항목의 개별 가격) 필드와 \"공급자_No\" (항목 공급자) 필드가 있을 경우 공급자가 준비한 다음의 쿼리를 사용하여 항목의 평균 가격을 얻을 수 있습니다:" - -#. qAByp -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153045\n" -"help.text" -msgid "Insert the \"Item\" table into the query design." -msgstr "\"항목\" 테이블을 쿼리 디자인에 삽입." - -#. tjfuE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149802\n" -"help.text" -msgid "Double-click the \"Price\" and \"Supplier_No\" fields." -msgstr "\"가격\"과 \"공급자_No\" 필드 더블 클릭." - -#. 6dBkt -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153554\n" -"help.text" -msgid "Enable the <emph>Function</emph> line and select the Average function from the \"Price\" field." -msgstr "<emph>기능</emph> 행 적용, \"가격\" 필드에서 평균 기능 선택." - -#. x8JB3 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155597\n" -"help.text" -msgid "You can also enter \"Average\" in the line for the alias name (without quotation marks)." -msgstr "원할 경우 행에 별칭 이름으로 \"평균\"을 입력 (따옴표 없이)." - -#. D4A9u -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151191\n" -"help.text" -msgid "Choose Group for the \"Supplier_No\" field." -msgstr "\"공급자_No\" 필드에서 그룹화 선택." - -#. BUYS9 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155547\n" -"help.text" -msgid "Run the query." -msgstr "쿼리를 실행합니다." - -#. EkHzB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147549\n" -"help.text" -msgid "The following context menu commands and symbols are available:" -msgstr "다음의 콘텍스트 메뉴 명령어와 아이콘이 있습니다:" - -#. PesFs -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3154172\n" -"help.text" -msgid "Functions" -msgstr "기능" - -#. BchuJ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150414\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>" -msgstr "" - -#. yx5XE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3149872\n" -"help.text" -msgid "Table Name" -msgstr "테이블 이름" - -#. ELTGJ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147246\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the table name.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">테이블 이름 행을 표시하거나 숨깁니다.</ahelp>" - -#. DDFEA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3145117\n" -"help.text" -msgid "Alias Name" -msgstr "별칭 이름" - -#. LDFZB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155754\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides the row for the alias name.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">별칭 이름 행을 표시하거나 숨깁니다.</ahelp>" - -#. wnNhq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3153298\n" -"help.text" -msgid "Distinct Values" -msgstr "단일 값" - -#. 23sAF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147500\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Retrieves only distinct values from the query.</ahelp> This applies to multiple records that might contain several repeating occurrences of data in the selected fields. If the <emph>Distinct Values</emph> command is active, you should only see one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)." -msgstr "" - -#. RZED7 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150436\n" -"help.text" -msgid "For example, if the name \"Smith\" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name \"Smith\" will occur only once." -msgstr "예를 들어, 주소 데이터베이스에서 \"Smith\"란 이름이 여러 번 발생하는 경우 <emph>명료값</emph> 명령을 선택하여 \"Smith\"란 이름이 한 번만 발생할 것을 쿼리에 지정할 수 있습니다." - -#. 2GvRf -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152352\n" -"help.text" -msgid "For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have \"Smith in Chicago\" once in your address book and \"Smith in London\" twice. With the<emph> Distinct Values</emph> command, the query will use the two fields \"last name\" and \"city\" and return the query result \"Smith in Chicago\" once and \"Smith in London\" once." -msgstr "여러 필드와 관련된 쿼리의 경우 결과가 특정 레코드로부터 구성될 수 있게 모든 필드의 값 조합이 고유해야 합니다. 예를 들어, 주소록에 \"Smith in Chicago\"가 한 번 나오고 \"Smith in London\"이 두 번 나오는 경우. <emph>명료값</emph> 명령을 사용하면 쿼리에서 \"last name\"과 \"city\"라는 두 필드를 사용하여 \"Smith in Chicago\"가 한 번, \"Smith in London\"이 한 번 발생하는 쿼리 결과를 구합니다." - -#. m5UcG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149825\n" -"help.text" -msgid "In SQL, this command corresponds to the DISTINCT predicate." -msgstr "SQL에서 이 명령은 DISTINCT 조건자에 해당합니다." - -#. GHsJd -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3153290\n" -"help.text" -msgid "Limit" -msgstr "라임" - -#. MijJg -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147501\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>" -msgstr "" - -#. B6S5f -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152350\n" -"help.text" -msgid "If a <emph>Limit</emph> construction is added, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria." -msgstr "" - -#. MGqK3 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3148926\n" -"help.text" -msgid "Formulating filter conditions" -msgstr "필터 조건 수식화" - -#. iFSpm -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153162\n" -"help.text" -msgid "When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax via an internal parser. You can also enter the SQL command directly and bypass the internal parser. The following tables give an overview of the operators and commands:" -msgstr "" - -#. fXeDd -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149044\n" -"help.text" -msgid "Operator" -msgstr "연산자" - -#. mfdEx -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152471\n" -"help.text" -msgid "Meaning" -msgstr "의미" - -#. mBZgC -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147407\n" -"help.text" -msgid "Condition is satisfied if..." -msgstr "...의 경우 조건이 충족됩니다" - -#. gqkRK -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153026\n" -"help.text" -msgid "equal to" -msgstr "등가입니다" - -#. hw7KZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148895\n" -"help.text" -msgid "... the content of the field is identical to the indicated expression." -msgstr "... 필드 내용이 지정된 표현과 동일합니다." - -#. A8XJU -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153120\n" -"help.text" -msgid "The operator = will not be displayed in the query fields. If you enter a value without any operator, the = operator is automatically assumed." -msgstr "" - -#. mWwUE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145223\n" -"help.text" -msgid "not equal to" -msgstr "동일하지 않습니다" - -#. Db7BG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145635\n" -"help.text" -msgid "... the content of the field does not correspond to the specified expression." -msgstr "... 필드 내용이 지정된 표현과 일치하지 않습니다." - -#. dtjkU -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146815\n" -"help.text" -msgid "greater than" -msgstr "..보다 큽니다" - -#. gCWug -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149150\n" -"help.text" -msgid "... the content of the field is greater than the specified expression." -msgstr "... 필드 내용이 지정된 표현보다 큽니다." - -#. QkAKk -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147379\n" -"help.text" -msgid "less than" -msgstr "..보다 작습니다" - -#. xxPdk -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150375\n" -"help.text" -msgid "... the content of the field is less than the specified expression." -msgstr "... 필드 내용이 지정된 표현보다 작습니다." - -#. 4aJjX -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150636\n" -"help.text" -msgid "greater than or equal to" -msgstr "greater than or equal to" - -#. 2rwQm -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154584\n" -"help.text" -msgid "... the content of the field is greater than or equal to the specified expression." -msgstr "... 필드 내용이 지정된 표현보다 크거나 동일합니다." - -#. ADRZk -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154052\n" -"help.text" -msgid "less than or equal to" -msgstr "작거나 같습니다" - -#. 9KtmZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157902\n" -"help.text" -msgid "... the content of the field is less than or equal to the specified expression." -msgstr "... 필드 내용이 지정된 표현보다 작거나 동일합니다." - -#. DBXG9 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154630\n" -"help.text" -msgid "$[officename] command" -msgstr "$[officename] 명령어" - -#. Yo7MG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150484\n" -"help.text" -msgid "SQL command" -msgstr "SQL 명령어" - -#. pJay6 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154158\n" -"help.text" -msgid "Meaning" -msgstr "의미" - -#. qmaX5 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149433\n" -"help.text" -msgid "Condition is satisfied if..." -msgstr "...의 경우 조건이 충족됩니다" - -#. do6XQ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3143236\n" -"help.text" -msgid "is null" -msgstr "비어 있음" - -#. NPqBL -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154744\n" -"help.text" -msgid "... the field contains no data. For Yes/No fields with three possible states, this command automatically queries the undetermined state (neither Yes nor No)." -msgstr "" - -#. 7Rfbd -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151229\n" -"help.text" -msgid "is not empty" -msgstr "비어 있지 않음" - -#. w3Tva -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145304\n" -"help.text" -msgid "... the field is not empty, i.e it contains data." -msgstr "" - -#. GGKUH -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153891\n" -"help.text" -msgid "placeholder (*) for any number of characters" -msgstr "" - -#. gbEWB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148887\n" -"help.text" -msgid "placeholder (?) for exactly one character" -msgstr "" - -#. tBQfA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"bm_id3157985\n" -"help.text" -msgid "<bookmark_value>placeholders; in SQL queries</bookmark_value>" -msgstr "<bookmark_value>자리 표시자;SQL 쿼리</bookmark_value>" - -#. agxhB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157985\n" -"help.text" -msgid "placeholder (%) for any number of characters" -msgstr "" - -#. EE9ii -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147422\n" -"help.text" -msgid "Placeholder (_) for exactly one character" -msgstr "" - -#. za5g2 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154845\n" -"help.text" -msgid "is an element of" -msgstr "..의 구성요소입니다" - -#. 2Y3zW -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156130\n" -"help.text" -msgid "... the data field contains the indicated expression. The (*) placeholder indicates whether the expression x occurs at the beginning of (x*), at the end of (*x) or inside the field content (*x*). You can enter as a placeholder in SQL queries either the SQL % character or the familiar (*) file system placeholder in the %PRODUCTNAME interface." -msgstr "" - -#. CPJyr -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150271\n" -"help.text" -msgid "The (*) or (%) placeholder stands for any number of characters. The question mark (?) in the $[officename] interface or the underscore (_) in SQL queries is used to represent exactly one character." -msgstr "" - -#. AAEXi -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159141\n" -"help.text" -msgid "Is not an element of" -msgstr "...의 구성요소가 아닙니다" - -#. 9vFBZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3161664\n" -"help.text" -msgid "... the field does not contain data having the specified expression." -msgstr "" - -#. CD2Ra -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159184\n" -"help.text" -msgid "falls within the interval [x,y]" -msgstr "간격 [x,y]에 위치합니다" - -#. cDe2u -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154395\n" -"help.text" -msgid "... the field contains a data value that lies between the two values x and y." -msgstr "" - -#. KYAXv -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155498\n" -"help.text" -msgid "Does not fall within the interval [x,y]" -msgstr "[x,y] 간격 내에 위치하지 않습니다." - -#. cVfAF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148992\n" -"help.text" -msgid "... the field contains a data value that does not lie between the two values x and y." -msgstr "" - -#. DBBQE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159167\n" -"help.text" -msgid "Note that semicolons are used as separators in all value lists!" -msgstr "" - -#. evEuh -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154809\n" -"help.text" -msgid "contains a, b, c..." -msgstr "a, b, c...를 포함합니다" - -#. eeFC2 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148399\n" -"help.text" -msgid "... the field name contains one of the specified expressions a, b, c,... Any number of expressions can be specified, and the result of the query is determined by a boolean OR operator. The expressions a, b, c... can be either numbers or characters" -msgstr "" - -#. JXq76 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150679\n" -"help.text" -msgid "does not contain a, b, c..." -msgstr "a, b, c...를 포함하지 않습니다" - -#. U5doB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3158439\n" -"help.text" -msgid "... the field does not contain one of the specified expressions a, b, c,..." -msgstr "" - -#. cECKt -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149248\n" -"help.text" -msgid "has the value True" -msgstr "True 값이 있습니다" - -#. fbgDt -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148524\n" -"help.text" -msgid "... the field name has the value True." -msgstr "... 데이터 필드에 True 값이 있습니다." - -#. 39zcD -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149955\n" -"help.text" -msgid "has the value false" -msgstr "False 값이 있습니다" - -#. fGHY6 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146850\n" -"help.text" -msgid "... the field data value is set to false." -msgstr "" - -#. qQETa -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3155954\n" -"help.text" -msgid "Examples" -msgstr "예" - -#. 8GaiA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150948\n" -"help.text" -msgid "returns field names with the field content \"Ms.\"" -msgstr "\"여성\"이라는 필드 내용이 있는 데이터 필드를 제공합니다." - -#. C3BDE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id315094A\n" -"help.text" -msgid "returns dates that occurred before January 10, 2001" -msgstr "2001년 1월 10일 이전 날짜를 구합니다." - -#. T7ZhS -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147332\n" -"help.text" -msgid "returns records with field content such as \"give\" and \"gave\"." -msgstr "" - -#. f6T3F -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155350\n" -"help.text" -msgid "returns records with field contents such as \"Sun\"." -msgstr "" - -#. AvbKu -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159406\n" -"help.text" -msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)." -msgstr "" - -#. 3tymM -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149712\n" -"help.text" -msgid "returns records with the values 1, 3, 5, 7. If the field name contains an item number, for example, you can create a query that returns the item having the specified number." -msgstr "" - -#. uusce -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147279\n" -"help.text" -msgid "returns records that do not contain \"Smith\"." -msgstr "" - -#. AJ8Xo -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146073\n" -"help.text" -msgid "<emph>Like </emph>Escape Sequence: {escape 'escape-character'}" -msgstr "<emph>Like </emph>Escape 시퀀스: {escape 'escape-character'}" - -#. Cy7Cc -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150661\n" -"help.text" -msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}" -msgstr "예: select * from Artikel where Artikelname like 'The *%' {escape '*'}" - -#. newGb -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148541\n" -"help.text" -msgid "The example will give you all of the entries where the item name begins with 'The *'. This means that you can also search for characters that would otherwise be interpreted as placeholders, such as *, ?, _, % or the period." -msgstr "이 예는 항목 이름이 'The *'로 시작하는 모든 항목을 제공합니다. 그러므로 *, ?, _, % 나점과 같이 보통 자리 표시자로 해석되는 문자도 찾을 수 있습니다." - -#. bAP3N -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150572\n" -"help.text" -msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" -msgstr "<emph>외부 조인</emph> Escape 시퀀스: {oj outer-join}" - -#. VnKGf -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156052\n" -"help.text" -msgid "Example: select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}" -msgstr "예: select 항목.* from {oj 항목 LEFT OUTER JOIN 주문 ON 항목.No=주문.ANR}" - -#. mWG9p -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3153674\n" -"help.text" -msgid "Querying text fields" -msgstr "텍스트 필드 쿼리" - -#. sxYQF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149134\n" -"help.text" -msgid "To query the content of a text field, you must put the expression between single quotes. The distinction between uppercase and lowercase letters depends on the database in use. LIKE, by definition, is case-sensitive (though some databases don't interpret this strictly)." -msgstr "" - -#. BEp4G -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3149302\n" -"help.text" -msgid "Querying date fields" -msgstr "날짜 필드 쿼리" - -#. D5mjw -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157998\n" -"help.text" -msgid "<emph>Date fields</emph> are represented as #Date# to clearly identify them as dates. Date, time and date/time constants (literals) used in conditions can be of either the SQL Escape Syntax type, or default SQL2 syntax." -msgstr "<emph>날짜 필드</emph>는 명확하게 날짜로 식별하기 위해 #Date#로 표시됩니다. 조건에서 문자 상수로 사용되는 date, time, date/time 는 SQL Escape Syntax 형식이거나 기본 SQL2 구문일 수 있습니다." - -#. Zzuo6 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31537341\n" -"help.text" -msgid "Date Type Element" -msgstr "날짜 유형 요소" - -#. JKys2 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31537342\n" -"help.text" -msgid "SQL Escape syntax #1 - may be obsolete" -msgstr "SQL Escape 문법 #1 - 오래된 구문일 수 있음" - -#. AzkWz -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31537343\n" -"help.text" -msgid "SQL Escape syntax #2" -msgstr "SQL Escape 구문 #2" - -#. UJ6VA -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31537344\n" -"help.text" -msgid "SQL2 syntax" -msgstr "SQL2 구문" - -#. 9V3Ky -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id315913111\n" -"help.text" -msgid "Date" -msgstr "날짜" - -#. YNF3S -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31559471\n" -"help.text" -msgid "Time" -msgstr "시간" - -#. ssX5b -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31509641\n" -"help.text" -msgid "DateTime" -msgstr "날짜 시간" - -#. FqZXM -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149539\n" -"help.text" -msgid "Example: select {d '1999-12-31'} from world.years" -msgstr "예: select {d '1999-12-31'} from world.years" - -#. WJ4YB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149540\n" -"help.text" -msgid "Example: select * from mytable where years='1999-12-31'" -msgstr "예: select * from mytable where years='1999-12-31'" - -#. CZdA4 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150510\n" -"help.text" -msgid "All date expressions (date literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" -msgstr "" - -#. HXdKT -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3150427\n" -"help.text" -msgid "Querying Yes/No fields" -msgstr "예/아니요 필드 쿼리" - -#. xWzix -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149523\n" -"help.text" -msgid "To query Yes/No fields, use the following syntax for dBASE tables:" -msgstr "예/아니요 필드를 쿼리하려면 dBASE 테이블에 대해 다음 구문을 사용합니다." - -#. A4Uh7 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153180\n" -"help.text" -msgid "Status" -msgstr "상태" - -#. FnXiE -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147481\n" -"help.text" -msgid "Query criterion" -msgstr "쿼리 기준" - -#. e6DJr -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155187\n" -"help.text" -msgid "Example" -msgstr "예제" - -#. Guy7d -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3156092\n" -"help.text" -msgid "Yes" -msgstr "예" - -#. p9WTn -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152414\n" -"help.text" -msgid "for dBASE tables: not equal to any given value" -msgstr "dBASE 테이블에 대해서: 0과 같지 않은 임의의 값" - -#. RFrvz -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151265\n" -"help.text" -msgid "=1 returns all records where the Yes/No field has the status \"Yes\" or \"On\" (selected in black)," -msgstr "=1 은 예/아니요 필드의 상태가 \"예\"나 \"작동\"인 모든 데이터 레코드를 제공합니다 (검은색 선택 표시)." - -#. 3P4ZB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152450\n" -"help.text" -msgid "No" -msgstr "아니요" - -#. BzBAa -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150997\n" -"help.text" -msgid "." -msgstr "." - -#. TFsQG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3155331\n" -"help.text" -msgid "=0 returns all records for which the Yes/No field has the status \"No\" or \"Off\" (no selection)." -msgstr "=0 은 예/아니요 필드의 상태가 \"아니요\"나 \"해제\"인 모든 데이터 레코드를 제공합니다(선택 표시 없음)." - -#. 9KXzK -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154179\n" -"help.text" -msgid "Null" -msgstr "Null" - -#. CwGZv -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147035\n" -"help.text" -msgid "IS NULL" -msgstr "IS NULL" - -#. dyXYc -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159385\n" -"help.text" -msgid "IS NULL returns all records for which the Yes/No field has neither of the states Yes or No (selected in gray)." -msgstr "IS NULL은 예/아니요 필드의 상태가 예나 아니요가 아닌 모든 데이터 레코드를 제공합니다 (회색 선택 표시)." - -#. YWk5J -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3157888\n" -"help.text" -msgid "The syntax depends on the database system used. You should also note that Yes/No fields can be defined differently (only 2 states instead of 3)." -msgstr "구문은 사용되는 데이터베이스 시스템에 따라 달라집니다. 예/아니요 필드는 세 가지가 아닌 두 가지 상태로 다르게 지정될 수도 있음에 유의해야 합니다." - -#. mmVa8 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3145772\n" -"help.text" -msgid "Parameter queries" -msgstr "매개 변수 쿼리" - -#. ND7xd -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151905346795\n" -"help.text" -msgid "Parameter queries allow the user to input values at run-time. These values are used within the criteria for selecting the records to be displayed. Each such value has a parameter name associated with it, which is used to prompt the user when the query is run." -msgstr "매개 변수 쿼리를 이용해 사용자는 런타임에 값을 입력할 수 있습니다. 이 값은 표시할 레코드를 선택하기 위한 기준 내에서 사용됩니다. 이러한 각 값에는 쿼리와 관련된 매개 변수 이름이 있습니다. 이 이름은 쿼리가 실행될 때 사용자에게 표시됩니다." - -#. Be7XG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151905439551\n" -"help.text" -msgid "Parameter names are preceded by a colon in both the Design and SQL views of a query. This can be used wherever a value can appear. If the same value is to appear more than once in the query, the same parameter name is used." -msgstr "쿼리의 디자인 보기 및 SQL 보기에서 파라미터명 앞에는 콜론이 표시됩니다. 이 변수에는 어떤 값도 사용할 수 있습니다. 쿼리에 같은 값이 두 번 이상 있으면, 같은 파라미터명이 사용됩니다." - -#. rSkkZ -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151905518123\n" -"help.text" -msgid "In the simplest case, where the user enters a value which is matched for equality, the parameter name with its preceding colon is simply entered in the Criterion row. In <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" -msgstr "가장 간단한 예로, '같음' 과 일치하는 값을 입력하면 이름 앞에 콜론이 붙은 매개 변수 이름이 기준 영역에 입력됩니다. <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL 모드</link> 에서는 <item type=\"input\">WHERE \"Field\" = :Parameter_name</item> 와 같이 입력되어야 합니다." - -#. DZCXm -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151905584287\n" -"help.text" -msgid "Parameter names may not contain any of the characters <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. They may not be the same as field names or SQL reserved words. They may be the same as aliases." -msgstr "매개 변수 이름에는 <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item> 과 같은 문자를 사용할 수 없습니다. 또한 필드명이나 SQL 예약어도 사용할 수 없습니다. 다만 별칭(alias)와는 같아도 됩니다." - -#. AY8e3 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151931441881\n" -"help.text" -msgid "A useful construction for selecting records based on parts of a text field's content is to add a hidden column with <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> as the criterion. This will select records with an exact match. If a case-insensitive test is wanted, one solution is to use <item type=\"input\">LOWER (Field_Name)</item> as the field and <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> as the criterion. Note that the spaces in the criterion are important; if they are left out the SQL parser interprets the entire criterion as a string to be matched. In <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." -msgstr "특정 텍스트를 포함하는 레코드를 선택하는데 유용한 조건은 <item type=\"input\">\"LIKE '%' || :Part_of_field || '%'\"</item> 입니다. 이 조건을 사용하면 지정한 텍스트와 정확하게 일치하는 텍스트를 포함한 레코드를 선택합니다. 대소문자를 구분하지 않으려면 필드 항목에<item type=\"input\">LOWER(Field_Name)</item>을 사용하고, 조건으로 <item type=\"input\">LIKE LOWER ( '%' || :Part_of_field || '%' )</item> 를 사용합니다. SQL 파서는 조건에 사용된 공백도 문자로 취급되므로 주의해야 합니다.<link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL 모드</link>에서는 <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item> 로 입력합니다." - -#. sSSB9 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150585\n" -"help.text" -msgid "Parameter queries may be used as the data source for <link href=\"text/shared/02/01170203.xhp\" name=\"subforms\">subforms</link>, to allow the user to restrict the displayed records." -msgstr "<link href=\"text/shared/02/01170203.xhp\" name=\"subforms\">하위 양식</link>의 원본 데이터로 매개 변수 쿼리를 사용하여 표시되는 레코드를 제한할 수 있습니다." - -#. DRj78 -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3151035\n" -"help.text" -msgid "Parameter Input" -msgstr "매개 변수 입력" - -#. BisCF -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153596\n" -"help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">The <emph>Parameter Input</emph> dialog asks the user to enter the parameter values. Enter a value for each query parameter and confirm by clicking <emph>OK</emph> or typing <emph>Enter</emph>.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\"><emph>매개 변수 입력</emph> 대화 상자에 각 쿼리 매개 변수의 값을 입력하고 <emph>[확인]</emph> 버튼을 누르거나 <emph>Enter</emph> 키를 누릅니다.</ahelp>" - -#. eGETM -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151924165870\n" -"help.text" -msgid "The values entered by the user may consist of any characters which are allowable for the SQL for the relevant criterion; this may depend on the underlying database system." -msgstr "사용자는 관련 기준에 해당하는 SQL 문법에서 허용하는 문자만 입력할 수 있습니다. 이는 기본 데이터베이스 시스템에 따라 다를 수 있습니다." - -#. seFhG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id191120151939594217\n" -"help.text" -msgid "The user can use the SQL wild-card characters \"%\" (arbitrary string) or \"_\" (arbitrary single character) as part of the value to retrieve records with more complex criteria." -msgstr "\"%\" (임의 문자열) 또는 \"_\" (임의 문자) 와 같은 SQL 와일드카드 문자를 사용하여 좀 더 복잡한 조건을 통해 레코드를 검색할 수 있습니다." - -#. wRe6v -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"hd_id3145181\n" -"help.text" -msgid "SQL Mode" -msgstr "SQL 모드" - -#. 5avVu -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147013\n" -"help.text" -msgid "SQL stands for \"Structured Query Language\" and describes instructions for updating and administering relational databases." -msgstr "SQL는 \"Structured Query Language\"의 약어이며 관계 데이터베이스를 쿼리하려는 목적으로 업데이트하고 관리하는 지침을 설명합니다." - -#. wDAAY -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152570\n" -"help.text" -msgid "In $[officename] you do not need any knowledge of SQL for most queries, since you do not have to enter the SQL code. If you create a query in the query designer, $[officename] automatically converts your instructions into the corresponding SQL syntax. If, with the help of the <emph>Switch Design View On/Off </emph>button, you change to the SQL view, you can see the SQL commands for a query that has already been created." -msgstr "" - -#. hBQFv -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152412\n" -"help.text" -msgid "You can formulate your query directly in SQL code. Note, however, that the special syntax is dependent upon the database system that you use." -msgstr "" - -#. kkuBG -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146842\n" -"help.text" -msgid "If you enter the SQL code manually, you can create SQL-specific queries that are not supported by the graphical interface in the <emph>Query designer</emph>. These queries must be executed in native SQL mode." -msgstr "" - -#. cBY6B -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149632\n" -"help.text" -msgid "By clicking the <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Run SQL command directly</emph></link> icon in the SQL view, you can formulate a query that is not processed by $[officename] and sent directly to the database engine." -msgstr "" - #. fKBDD #: 02010101.xhp msgctxt "" @@ -5488,14 +3274,14 @@ msgctxt "" msgid "You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here." msgstr "Grant, Create Table, Drop Table 같은 관리 명령만 이 대화 상자에 입력할 수 있으며, 필터 명령은 입력할 수 없습니다. 입력할 수 있는 명령은 데이터 원본에 따라 달라집니다. 예를 들어, dBASE의 경우 여기에 있는 SQL 명령 목록 중 일부만 실행할 수 있습니다." -#. zMG8X +#. JZmCZ #: 11080000.xhp msgctxt "" "11080000.xhp\n" "par_id3154860\n" "help.text" -msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design View</link>." -msgstr "데이터베이스에서 데이터를 필터링할 때 필요한 SQL 쿼리를 실행하려면 <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">쿼리 디자인 보기</link>을 클릭합니다." +msgid "To run an SQL query for filtering data in the database, use the <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design View</link>." +msgstr "" #. Ck9G4 #: 11080000.xhp diff --git a/source/ko/helpcontent2/source/text/shared/guide.po b/source/ko/helpcontent2/source/text/shared/guide.po index 8f37af4bacc..dbd6ccd1ee2 100644 --- a/source/ko/helpcontent2/source/text/shared/guide.po +++ b/source/ko/helpcontent2/source/text/shared/guide.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2020-07-28 14:35+0000\n" "Last-Translator: sophie <gautier.sophie@gmail.com>\n" "Language-Team: Korean <https://weblate.documentfoundation.org/projects/libo_help-master/textsharedguide/ko/>\n" @@ -6523,14 +6523,14 @@ msgctxt "" msgid "Click the <emph>Save</emph> or <emph>Save As</emph> icon <image id=\"img_id3153159\" src=\"cmd/sc_save.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153159\">Icon</alt></image> to save the query." msgstr "<emph>저장</emph> 또는 <emph>다른 이름으로 저장</emph> 아이콘 <image id=\"img_id3153159\" src=\"cmd/sc_save.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3153159\">아이콘</alt></image>을 클릭하여 쿼리를 저장하십시오." -#. WiVpi +#. CFL3H #: data_enter_sql.xhp msgctxt "" "data_enter_sql.xhp\n" "par_id3153223\n" "help.text" -msgid "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design</link>" -msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"쿼리 디자인\">쿼리 디자인</link>" +msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>" +msgstr "" #. 2ArGc #: data_forms.xhp @@ -7081,14 +7081,14 @@ msgctxt "" msgid "Click <emph>Create Query in Design View</emph>." msgstr "<emph>디자인 보기에서 쿼리 만들기</emph>를 클릭합니다." -#. 9nBBo +#. xkwQQ #: data_queries.xhp msgctxt "" "data_queries.xhp\n" "par_idN1065F\n" "help.text" -msgid "You see the <link href=\"text/shared/explorer/database/02010100.xhp\">Query Design window</link>." -msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\">쿼리 디자인 창</link>이 표시됩니다." +msgid "You see the <link href=\"text/sdatabase/02010100.xhp\">Query Design window</link>." +msgstr "" #. xGFGr #: data_register.xhp @@ -7747,14 +7747,14 @@ msgctxt "" msgid "Enter the filter conditions into one or several fields. Note that if you enter filter conditions into several fields, all of the entered conditions must match (Boolean AND)." msgstr "한 개 이상의 필드에 필터 조건을 입력합니다. 여러 필드에 필터 조건을 입력하면 입력한 모든 조건이 충족되어야 합니다(Boolean AND)." -#. FjhEB +#. sNJBm #: data_search2.xhp msgctxt "" "data_search2.xhp\n" "par_id3149481\n" "help.text" -msgid "More information about wildcards and operators can be found in <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Query Design\">Query Design</link>." -msgstr "와일드카드와 연산자에 대한 자세한 내용은 <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"쿼리 디자인\">쿼리 디자인</link>에서 찾을 수 있습니다." +msgid "More information about wildcards and operators can be found in <link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>." +msgstr "" #. cEDEo #: data_search2.xhp @@ -8107,14 +8107,14 @@ msgctxt "" msgid "Click <emph>Create Table View</emph>." msgstr "<emph>테이블 보기 만들기</emph>를 클릭합니다." -#. oUbtR +#. QEHKK #: data_tables.xhp msgctxt "" "data_tables.xhp\n" "par_idN10795\n" "help.text" -msgid "You see the View Design window, which is almost the same as the <link href=\"text/shared/explorer/database/02010100.xhp\">Query Design window</link>." -msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\">쿼리 디자인 창</link>과 거의 똑같은 보기 디자인 창이 열립니다." +msgid "You see the View Design window, which is almost the same as the <link href=\"text/sdatabase/020010100.xhp\">Query Design window</link>." +msgstr "" #. bTx8G #: data_view.xhp @@ -21058,13 +21058,13 @@ msgctxt "" msgid "<bookmark_value>changes; protecting</bookmark_value><bookmark_value>protecting; recorded changes</bookmark_value><bookmark_value>records; protecting</bookmark_value><bookmark_value>review function;protecting records</bookmark_value>" msgstr "<bookmark_value>변경 사항; 보호</bookmark_value><bookmark_value>보호; 변경 사항 기록</bookmark_value><bookmark_value>기록; 보호</bookmark_value><bookmark_value>재검토 기능;기록 보호</bookmark_value>" -#. 4cTt7 +#. Tj23h #: redlining_protect.xhp msgctxt "" "redlining_protect.xhp\n" "hd_id3159201\n" "help.text" -msgid "<variable id=\"redlining_protect\"><link href=\"text/shared/guide/redlining_protect.xhp\" name=\"Protecting Changes\">Protecting Changes</link> </variable>" +msgid "<variable id=\"redlining_protect\"><link href=\"text/shared/guide/redlining_protect.xhp\" name=\"Protecting Changes\">Protecting Changes</link></variable>" msgstr "" #. jVeUw diff --git a/source/ko/helpcontent2/source/text/shared/optionen.po b/source/ko/helpcontent2/source/text/shared/optionen.po index f9e4d217614..2d5832d1bf8 100644 --- a/source/ko/helpcontent2/source/text/shared/optionen.po +++ b/source/ko/helpcontent2/source/text/shared/optionen.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-08-09 08:14+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -61,14 +61,14 @@ msgctxt "" msgid "All your settings are saved automatically. To expand an entry either double click this entry or click the plus sign. To collapse the entry, click the minus sign or double click the entry." msgstr "모든 설정은 자동으로 저장됩니다. 항목을 확장하려면 해당 항목을 더블 클릭하거나 더하기 기호를 클릭합니다. 항목을 축소하려면 빼기 기호를 클릭하거나 해당 항목을 더블 클릭합니다." -#. Dn9AL +#. HMSEY #: 01000000.xhp msgctxt "" "01000000.xhp\n" "par_idN10607\n" "help.text" -msgid "You see only the entries that are applicable to the current document. If the current document is a text document, you see the %PRODUCTNAME Writer entry, and so on for all modules of %PRODUCTNAME. %PRODUCTNAME Impress and %PRODUCTNAME Draw are treated as the same in this dialog. The common entries are always visible." -msgstr "현재 문서에 적용할 수 있는 항목만 표시됩니다. 현재 문서가 텍스트 문서이면 %PRODUCTNAME Writer 항목이 표시되며, %PRODUCTNAME의 다른 모듈의 경우도 마찬가지입니다. 이 대화 상자에서 %PRODUCTNAME Impress와 %PRODUCTNAME Draw는 동일한 것으로 간주됩니다. 공통 항목은 항상 표시됩니다." +msgid "You see only the entries that are applicable to the current document. If the current document is a text document, you see the %PRODUCTNAME Writer entry, and so on for all modules of %PRODUCTNAME." +msgstr "" #. uYcBu #: 01000000.xhp @@ -79,13 +79,13 @@ msgctxt "" msgid "<ahelp hid=\"HID_OFADLG_TREELISTBOX\" visibility=\"hidden\">Select an entry to edit.</ahelp>" msgstr "<ahelp hid=\"HID_OFADLG_TREELISTBOX\" visibility=\"hidden\">기본 설정을 보거나 변경하려는 영역을 선택하십시오.</ahelp>" -#. qV89h +#. cLKW2 #: 01000000.xhp msgctxt "" "01000000.xhp\n" -"par_id1013200911280529\n" +"par_id61597440155071\n" "help.text" -msgid "Note for macOS users: The Help mentions the menu path Tools - Options at numerous places. Replace this path with %PRODUCTNAME - Preferences on your macOS main menu. Both menu entries open the Options dialog box." +msgid "<switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline>" msgstr "" #. WS53M @@ -5245,42 +5245,6 @@ msgctxt "" msgid "<ahelp hid=\"cui/ui/optsecuritypage/cert\">Opens the <emph>Certificate Path</emph> dialog.</ahelp>" msgstr "" -#. yZc9g -#: 01030300.xhp -msgctxt "" -"01030300.xhp\n" -"par_idN106871\n" -"help.text" -msgid "TSAs" -msgstr "" - -#. yxkXg -#: 01030300.xhp -msgctxt "" -"01030300.xhp\n" -"par_idN1068B1\n" -"help.text" -msgid "Allows you to maintain a list of Time Stamping Authority (TSA) URLs. TSAs issue digitally signed timestamps (RFC 3161) that are optionally used during signed PDF export." -msgstr "" - -#. LBhZv -#: 01030300.xhp -msgctxt "" -"01030300.xhp\n" -"par_idN1068E1\n" -"help.text" -msgid "TSAs" -msgstr "" - -#. 3GGAj -#: 01030300.xhp -msgctxt "" -"01030300.xhp\n" -"par_idN106921\n" -"help.text" -msgid "<ahelp hid=\"cui/ui/optsecuritypage/tsas\">Opens the <emph>Time Stamping Authority URLs</emph> dialog.</ahelp>" -msgstr "" - #. tY5b3 #: 01030500.xhp msgctxt "" @@ -7522,6 +7486,168 @@ msgctxt "" msgid "<ahelp hid=\"modules/swriter/ui/optredlinepage/markcolor\">Specifies the color for highlighting the changed lines in the text.</ahelp>" msgstr "" +#. BANMp +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"tit\n" +"help.text" +msgid "Comparison Options" +msgstr "" + +#. E6UnW +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"bm_id481597340419434\n" +"help.text" +msgid "<bookmark_value>document comparison;options</bookmark_value> <bookmark_value>comparison;automatic</bookmark_value> <bookmark_value>comparison;by word</bookmark_value> <bookmark_value>comparison;by character</bookmark_value> <bookmark_value>document comparison;random ID</bookmark_value>" +msgstr "" + +#. Bw9mZ +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id801597320214148\n" +"help.text" +msgid "<variable id=\"comparisonoptionh1\"><link href=\"text/shared/optionen/01040800.xhp\" name=\"Comparison\">Document Comparison Options</link></variable>" +msgstr "" + +#. DRYng +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id761597320214148\n" +"help.text" +msgid "Defines the comparison options for the document." +msgstr "" + +#. vgLbk +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id101597332748471\n" +"help.text" +msgid "Open a text document, choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Writer - Comparison</menuitem>." +msgstr "" + +#. mjJDZ +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id421597320817511\n" +"help.text" +msgid "Compare documents" +msgstr "" + +#. uKiJe +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id821597320851919\n" +"help.text" +msgid "<emph>Automatic</emph>: Uses traditional algorithm for document comparison (default)." +msgstr "" + +#. sG9SF +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id771597320878668\n" +"help.text" +msgid "<emph>By word</emph>: compares documents segmenting contents word by word." +msgstr "" + +#. BRvm7 +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id431597320905536\n" +"help.text" +msgid "<emph>By characters</emph>: compares documents segmenting contents character by character. You can define the minimal number of character for the comparison." +msgstr "" + +#. 8Pb46 +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id521597320824763\n" +"help.text" +msgid "Random Number to improve accuracy of document comparison" +msgstr "" + +#. CVid8 +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id411597332706569\n" +"help.text" +msgid "Introduce an identifier to improve accuracy of document comparison when done by word or by characters." +msgstr "" + +#. SBPxy +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id631597333767341\n" +"help.text" +msgid "These options are enabled when the Compare documents options are by words or by characters." +msgstr "" + +#. D8X8F +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id601597323591520\n" +"help.text" +msgid "Take it into account when comparing" +msgstr "" + +#. AzAaF +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id191597335836486\n" +"help.text" +msgid "Activates the document comparison using By word and By character options." +msgstr "" + +#. BRybW +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id1001597323596761\n" +"help.text" +msgid "Ignore pieces of length" +msgstr "" + +#. jrR5L +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id751597333853235\n" +"help.text" +msgid "Set the minimum number of characters to trigger a valid comparison." +msgstr "" + +#. hZ7bt +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"hd_id291597323603653\n" +"help.text" +msgid "Store it when changing the document" +msgstr "" + +#. GgGrD +#: 01040800.xhp +msgctxt "" +"01040800.xhp\n" +"par_id421597332757267\n" +"help.text" +msgid "Stores the random number in the document." +msgstr "" + #. CxgNP #: 01040900.xhp msgctxt "" @@ -16747,40 +16873,40 @@ msgctxt "" msgid "Enable the check to send information about your %PRODUCTNAME version, operating system and basic hardware. This information is used to optimize the download." msgstr "" -#. uDvTG +#. AN7zk #: opencl.xhp msgctxt "" "opencl.xhp\n" "tit_opencl\n" "help.text" -msgid "Open CL" +msgid "OpenCL" msgstr "" -#. enEVC +#. sDXCB #: opencl.xhp msgctxt "" "opencl.xhp\n" "bm_id4077578\n" "help.text" -msgid "<bookmark_value>Open CL;setting options</bookmark_value><bookmark_value>setting options;Open CL</bookmark_value>" +msgid "<bookmark_value>OpenCL;setting options</bookmark_value><bookmark_value>setting options;OpenCL</bookmark_value>" msgstr "" -#. bVCo8 +#. RAY7n #: opencl.xhp msgctxt "" "opencl.xhp\n" "par_idN10558\n" "help.text" -msgid "<link href=\"text/shared/optionen/opencl.xhp\">Open CL</link>" -msgstr "<link href=\"text/shared/optionen/java.xhp\">Java</link>" +msgid "<link href=\"text/shared/optionen/opencl.xhp\">OpenCL</link>" +msgstr "" -#. wKxGg +#. KoASK #: opencl.xhp msgctxt "" "opencl.xhp\n" "par_idN10568\n" "help.text" -msgid "Open CL is a technology to speed up calculation on large spreadsheets." +msgid "OpenCL is a technology to speed up calculation on large spreadsheets." msgstr "" #. ddvkj diff --git a/source/ko/helpcontent2/source/text/simpress.po b/source/ko/helpcontent2/source/text/simpress.po index 28f60362cb5..79a78c1eaa9 100644 --- a/source/ko/helpcontent2/source/text/simpress.po +++ b/source/ko/helpcontent2/source/text/simpress.po @@ -3,7 +3,7 @@ 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-06-22 17:23+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2018-04-14 12:19+0000\n" "Last-Translator: Jihui Choi <jihui.choi@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -601,15 +601,6 @@ msgctxt "" msgid "<link href=\"text/shared/01/05210100.xhp\" name=\"Area Style / Filling\">Area Style / Filling</link>" msgstr "<link href=\"text/shared/01/05210100.xhp\" name=\"영역 스타일/ 채우기\">영역 스타일/ 채우기</link>" -#. nn7rV -#: main0202.xhp -msgctxt "" -"main0202.xhp\n" -"hd_id3150048\n" -"help.text" -msgid "<link href=\"text/shared/01/05210600.xhp\" name=\"Shadow\">Shadow</link>" -msgstr "<link href=\"text/shared/01/05210600.xhp\" name=\"그림자\">그림자</link>" - #. qXLpG #: main0203.xhp msgctxt "" @@ -1105,15 +1096,6 @@ msgctxt "" msgid "Switches the 3D effects on and off for the selected objects." msgstr "선택한 개체에 대해 3D 효과를 설정하고 해제합니다." -#. G5r64 -#: main0210.xhp -msgctxt "" -"main0210.xhp\n" -"hd_id3145350\n" -"help.text" -msgid "<link href=\"text/simpress/01/06070000.xhp\" name=\"Interaction\">Interaction</link>" -msgstr "<link href=\"text/simpress/01/06070000.xhp\" name=\"상호 작용\">상호 작용</link>" - #. NXNKE #: main0211.xhp msgctxt "" diff --git a/source/ko/helpcontent2/source/text/swriter/01.po b/source/ko/helpcontent2/source/text/swriter/01.po index f6a257d106b..0ba2cdabe0f 100644 --- a/source/ko/helpcontent2/source/text/swriter/01.po +++ b/source/ko/helpcontent2/source/text/swriter/01.po @@ -3,7 +3,7 @@ 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-08-04 13:02+0200\n" +"POT-Creation-Date: 2020-08-17 12:39+0200\n" "PO-Revision-Date: 2019-08-09 08:16+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -22777,14 +22777,14 @@ msgctxt "" msgid "<link href=\"text/swriter/01/05150100.xhp\" name=\"While Typing\">While Typing</link>" msgstr "<link href=\"text/swriter/01/05150100.xhp\" name=\"입력하는 동안\">입력하는 동안</link>" -#. 2MCDP +#. FArms #: 05150100.xhp msgctxt "" "05150100.xhp\n" "par_id3154017\n" "help.text" -msgid "<ahelp hid=\".uno:OnlineAutoFormat\">Automatically formats the document while you type. To set the formatting options, choose <emph>Tools - AutoCorrect</emph><emph> Options</emph>, and then click the <emph>Options </emph>tab.</ahelp>" -msgstr "<ahelp hid=\".uno:OnlineAutoFormat\">입력하는 동안 자동으로 문서의 서식을 설정합니다. 서식 옵션을 설정하려면 <emph>도구 - 자동 고침</emph><emph>옵션</emph>을 선택한 다음 <emph>옵션</emph> 탭을 클릭합니다.</ahelp>" +msgid "<ahelp hid=\".uno:OnlineAutoFormat\">Automatically formats the document while you type. To set the formatting options, choose <menuitem>Tools - AutoCorrect - Options</menuitem>, and then click the <emph>Options</emph> tab.</ahelp>" +msgstr "" #. Ddr5r #: 05150100.xhp |