diff options
Diffstat (limited to 'source/id/helpcontent2/source/text/sdatabase.po')
-rw-r--r-- | source/id/helpcontent2/source/text/sdatabase.po | 123 |
1 files changed, 57 insertions, 66 deletions
diff --git a/source/id/helpcontent2/source/text/sdatabase.po b/source/id/helpcontent2/source/text/sdatabase.po index 9588cbf63c6..104266fcd0f 100644 --- a/source/id/helpcontent2/source/text/sdatabase.po +++ b/source/id/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: 2022-02-21 15:22+0100\n" +"POT-Creation-Date: 2022-05-25 12:36+0200\n" "PO-Revision-Date: 2021-05-21 20:37+0000\n" "Last-Translator: Rizal Muttaqin <riz_17_oke@yahoo.co.id>\n" "Language-Team: Indonesian <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/id/>\n" @@ -384,13 +384,13 @@ msgctxt "" 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 +#. 2BrD2 #: 02010100.xhp msgctxt "" "02010100.xhp\n" "hd_id3153394\n" "help.text" -msgid "<link href=\"text/sdatabase/020010100.xhp\" name=\"Query Design\">Query Design</link>" +msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>" msgstr "" #. GU8Jd @@ -447,13 +447,13 @@ msgctxt "" 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 +#. AtAHv #: 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." +msgid "The lower pane of the Design View is where you define the query. To define a query, specify the database field names to include and the criteria for displaying the fields. To rearrange the columns in the lower pane of the Design View, drag a column header to a new location, or select the column and press <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+arrow key." msgstr "" #. GMVkG @@ -924,15 +924,6 @@ msgctxt "" 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 "" @@ -996,13 +987,13 @@ msgctxt "" msgid "Criteria" msgstr "" -#. f3DvJ +#. fWRgB #: 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>" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies a first criteria by which the content of the data field is to be filtered.</ahelp>" msgstr "" #. qpADC @@ -2157,15 +2148,6 @@ msgctxt "" 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 "" @@ -2184,15 +2166,6 @@ msgctxt "" 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 "" @@ -2292,24 +2265,6 @@ msgctxt "" 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 "" @@ -2481,13 +2436,13 @@ msgctxt "" 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 +#. f2NMg #: 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>" +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/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">WHERE \"Field\" = :Parameter_name</item>" msgstr "" #. DZCXm @@ -2499,13 +2454,13 @@ msgctxt "" 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 +#. WBEtt #: 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>." +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/02010100.xhp#sqlmode\">SQL mode</link> this should be typed as <item type=\"input\">LOWER ( \"Field_Name\" ) LIKE LOWER ( '%' || :Part_of_field || '%' )</item>." msgstr "" #. sSSB9 @@ -5919,6 +5874,42 @@ msgctxt "" msgid "For more information on SQL commands, please consult the documentation that came with the database." msgstr "" +#. hdoAK +#: 11080000.xhp +msgctxt "" +"11080000.xhp\n" +"hd_id91652478785999\n" +"help.text" +msgid "Show output of \"select\" statements" +msgstr "" + +#. nB4gp +#: 11080000.xhp +msgctxt "" +"11080000.xhp\n" +"par_id281652481037143\n" +"help.text" +msgid "Show the result of the SQL SELECT command in the Output box." +msgstr "" + +#. uaXF8 +#: 11080000.xhp +msgctxt "" +"11080000.xhp\n" +"hd_id3154071\n" +"help.text" +msgid "Execute" +msgstr "" + +#. 6UCdY +#: 11080000.xhp +msgctxt "" +"11080000.xhp\n" +"par_id3151210\n" +"help.text" +msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute</emph> box.</ahelp>" +msgstr "" + #. BQmT9 #: 11080000.xhp msgctxt "" @@ -5928,13 +5919,13 @@ msgctxt "" msgid "Previous commands" msgstr "" -#. hkxBT +#. 8AWBX #: 11080000.xhp msgctxt "" "11080000.xhp\n" "par_id3149045\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp>" +msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Execute</emph>.</ahelp>" msgstr "" #. AvXck @@ -5946,31 +5937,31 @@ msgctxt "" msgid "Status" msgstr "" -#. yhCpt +#. 7RS4e #: 11080000.xhp msgctxt "" "11080000.xhp\n" "par_id3151054\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>" +msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the status, including errors, of the SQL command that you ran.</ahelp>" msgstr "" -#. BUpxX +#. 8qcm5 #: 11080000.xhp msgctxt "" "11080000.xhp\n" -"hd_id3154071\n" +"hd_id841652479655639\n" "help.text" -msgid "Run" +msgid "Output" msgstr "" -#. qDYRx +#. pEFoq #: 11080000.xhp msgctxt "" "11080000.xhp\n" -"par_id3151210\n" +"par_id511652479714010\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>" +msgid "Displays the results of the SQL command that you ran." msgstr "" #. 93Xfs |