aboutsummaryrefslogtreecommitdiff
path: root/source/gl/helpcontent2/source/text/sdatabase.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/gl/helpcontent2/source/text/sdatabase.po')
-rw-r--r--source/gl/helpcontent2/source/text/sdatabase.po131
1 files changed, 61 insertions, 70 deletions
diff --git a/source/gl/helpcontent2/source/text/sdatabase.po b/source/gl/helpcontent2/source/text/sdatabase.po
index e09d195a01d..79541a0d139 100644
--- a/source/gl/helpcontent2/source/text/sdatabase.po
+++ b/source/gl/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: 2022-05-03 12:47+0000\n"
"Last-Translator: Xosé <xosecalvo@gmail.com>\n"
"Language-Team: Galician <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/gl/>\n"
@@ -13,7 +13,7 @@ msgstr ""
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=n != 1;\n"
"X-Accelerator-Marker: ~\n"
-"X-Generator: Weblate 4.11.2\n"
+"X-Generator: LibreOffice\n"
#. ugSgG
#: 02000000.xhp
@@ -384,14 +384,14 @@ 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 "<bookmark_value>vistas; crear vistas de bases de datos (Base)</bookmark_value> <bookmark_value>consultas; crear na vista de deseño (Base)</bookmark_value> <bookmark_value>deseño; consultas (Base)</bookmark_value> <bookmark_value>vista de deseño; consultas/vistas (Base)</bookmark_value> <bookmark_value>unir;táboas (Base)</bookmark_value> <bookmark_value>táboas en bases de datos;unir para consultas (Base)</bookmark_value> <bookmark_value>consultas; unir táboas (Base)</bookmark_value> <bookmark_value>táboas en bases de datos; relacións (Base)</bookmark_value> <bookmark_value>relacións; unir táboas (Base)</bookmark_value> <bookmark_value>consultas; eliminar ligazóns a táboas (Base)</bookmark_value> <bookmark_value>criterios para deseñar consultas (Base)</bookmark_value> <bookmark_value>consultas; formular condicións de filtro (Base)</bookmark_value> <bookmark_value>condicións de filtro;en consultas (Base)</bookmark_value> <bookmark_value>parámetros; consultas (Base)</bookmark_value> <bookmark_value>consultas; consultas de parámetros (Base)</bookmark_value> <bookmark_value>SQL; consultas (Base)</bookmark_value> <bookmark_value>SQL nativo (Base)</bookmark_value>"
-#. 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>"
-msgstr "<link href=\"text/shared/explorer/database/02010100.xhp\" name=\"Deseño de consulta\">Deseño de consulta</link>"
+msgid "<link href=\"text/sdatabase/02010100.xhp\" name=\"Query Design\">Query Design</link>"
+msgstr ""
#. GU8Jd
#: 02010100.xhp
@@ -447,14 +447,14 @@ 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 "Para crear unha consulta, prema na icona <emph>Consultas</emph> dun documento de base de datos e, a seguir, prema en <emph>Crear consulta na visualización de deseño</emph>."
-#. 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."
-msgstr "O panel inferior da vista de deseño é onde se <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">define</link> a consulta. Para definir unha consulta, indique os <link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">nomes de campos</link> da base de datos que desexe incluír e os <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">criterios</link> para mostrar os campos. Para reorganizar as columnas no panel inferior da vista de deseño, arrastre a cabeceira da columna para un sitio novo ou seleccione a columna e prema <switchinline select=\"sys\"><caseinline select=\"MAC\">Orde</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Tecla de frecha."
+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
#: 02010100.xhp
@@ -924,15 +924,6 @@ msgctxt ""
msgid "For example:"
msgstr "Por exemplo:"
-#. ynSGq
-#: 02010100.xhp
-msgctxt ""
-"02010100.xhp\n"
-"par_id3148478\n"
-"help.text"
-msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\""
-msgstr "SELECT \"Compostela\" AS \"Santiago\" FROM \"Historia\""
-
#. roTzi
#: 02010100.xhp
msgctxt ""
@@ -996,14 +987,14 @@ msgctxt ""
msgid "Criteria"
msgstr "Criterios"
-#. 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>"
-msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Especifica os primeiros <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">cri</link> polos que se ha de filtrar o contido do campo de datos.</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
#: 02010100.xhp
@@ -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