diff options
Diffstat (limited to 'source/de/helpcontent2/source/text/sdatabase.po')
| -rw-r--r-- | source/de/helpcontent2/source/text/sdatabase.po | 133 |
1 files changed, 62 insertions, 71 deletions
diff --git a/source/de/helpcontent2/source/text/sdatabase.po b/source/de/helpcontent2/source/text/sdatabase.po index dc275e70c4f..1d6e40850f4 100644 --- a/source/de/helpcontent2/source/text/sdatabase.po +++ b/source/de/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-02-14 06:39+0000\n" "Last-Translator: Annabelle Wübbelsmann <translowl@web.de>\n" "Language-Team: German <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/de/>\n" @@ -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>Ansichten; Datenbanken erstellen (Base)</bookmark_value><bookmark_value>Abfragen; in der Designansicht erstellen (Base)</bookmark_value><bookmark_value>Entwerfen; Abfragen (Base)</bookmark_value><bookmark_value>Entwurfsansicht; Abfragen/Ansichten (Base)</bookmark_value><bookmark_value>verbinden; Tabellen (Base)</bookmark_value><bookmark_value>Tabellen in Datenbanken; Abfragen verbinden (Base)</bookmark_value><bookmark_value>Abfragen; Tabellen verbinden (Base)</bookmark_value><bookmark_value>Tabellen in Datenbanken; Relationen (Base)</bookmark_value><bookmark_value>Relationen; Tabellen verbinden (Base)</bookmark_value><bookmark_value>Abfragen; Tabellenverknüpfungen löschen (Base)</bookmark_value><bookmark_value>Kriterien für Abfragedesigns (Base)</bookmark_value><bookmark_value>Abfragen; Filterbedingungen formulieren (Base)</bookmark_value><bookmark_value>Filterbedingungen; in Abfragen (Base)</bookmark_value><bookmark_value>Parameter; Abfragen (Base)</bookmark_value><bookmark_value>Abfragen; Parameter (Base)</bookmark_value><bookmark_value>SQL; Abfragen (Base)</bookmark_value><bookmark_value>natives SQL (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/sdatabase/020010100.xhp\" name=\"Query Design\">Abfrageentwurf</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 "Um eine Abfrage zu erstellen, klicken Sie in einem Datenbankdokument auf das Symbol <emph>Abfragen</emph> und dann auf <emph>Abfrage in der Entwurfsansicht erstellen</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 "Im unteren Bereich der Entwurfsansicht <link href=\"text/sdatabase/020010100.xhp\" name=\"define\">definieren</link> Sie die Abfrage. Um eine Abfrage zu definieren, geben Sie die einzuschließende Datenbank-<link href=\"text/sdatabase/020010100.xhp\" name=\"field names\">Feldnamen</link> und die <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria\">Kriterien</link> für die Anzeige der Felder an. Um die Spalten im unteren Bereich der Entwurfsansicht neu anzuordnen, ziehen Sie eine Spaltenüberschrift an eine neue Position oder wählen Sie die Spalte aus und drücken Sie <switchinline select=\"sys\"><caseinline select=\"MAC\">Befehl</caseinline><defaultinline>Strg</defaultinline></switchinline>+Pfeiltaste." +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 "Zum Beispiel:" -#. ynSGq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148478\n" -"help.text" -msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" -msgstr "SELECT \"TlNr\" AS \"TeilNum\" FROM \"Teile\"" - #. roTzi #: 02010100.xhp msgctxt "" @@ -996,14 +987,14 @@ msgctxt "" msgid "Criteria" msgstr "Kriterien" -#. 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\">Gibt ein erstes <link href=\"text/sdatabase/020010100.xhp\" name=\"criteria \">Kriterium</link> an, nach dem der Inhalt des Datenfelds gefiltert werden soll.</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 "<emph>Like</emph> Abbruchsequenz: {escape 'Abbruchzeichen'}" -#. Cy7Cc -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150661\n" -"help.text" -msgid "Example: select * from Item where ItemName like 'The *%' {escape '*'}" -msgstr "Beispiel: select * from Artikel where Artikelname like 'Der *%' {escape '*'}" - #. newGb #: 02010100.xhp msgctxt "" @@ -2184,15 +2166,6 @@ msgctxt "" msgid "<emph>Outer Join</emph> Escape Sequence: {oj outer-join}" msgstr "<emph>Outer Join</emph> Abbruchsequenz: {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 "Beispiel: select Artikel.* from {oj Artikel LEFT OUTER JOIN Bestellungen ON Artikel.Nr=Bestellungen.ANR}" - #. mWG9p #: 02010100.xhp msgctxt "" @@ -2292,24 +2265,6 @@ msgctxt "" msgid "DateTime" msgstr "DatumZeit" -#. FqZXM -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149539\n" -"help.text" -msgid "Example: select {d '1999-12-31'} from world.years" -msgstr "Beispiel: select {d '1999-12-31'} from Welt.Jahre" - -#. WJ4YB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149540\n" -"help.text" -msgid "Example: select * from mytable where years='1999-12-31'" -msgstr "Beispiel: select * from meineTabelle where years='1999-12-31'" - #. CZdA4 #: 02010100.xhp msgctxt "" @@ -2481,14 +2436,14 @@ 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 "Parameternamen wird sowohl in der Entwurfs- als auch in der SQL-Ansicht einer Abfrage ein Doppelpunkt vorangestellt. Dies kann immer dort geschehen, wo ein Wert erscheinen kann. Falls derselbe Wert mehr als einmal in der Abfrage erscheint, wird derselbe Parametername verwendet." -#. 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>" -msgstr "Im einfachsten Fall, bei dem der Benutzer einen Wert eingibt, der auf Gleichheit überprüft werden soll, wird der Parametername mit seinem vorangestellten Doppelpunkten in der Kriteriumszeile eingeben. Im <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL-Modus</link> sollte dies als <item type=\"input\">WHERE \"Feld\" = :Parametername</item> eingegeben werden." +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 #: 02010100.xhp @@ -2499,14 +2454,14 @@ 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 "Parameternamen dürfen keines der Zeichen <item type=\"input\"><Leerstelle>`!\"$%^*()+={}[]@'~#<>?/,</item> enthalten. Sie dürfen nicht gleich Feldnamen oder für SQL reservierten Wörter sein. Sie können aber gleich Aliasen sein." -#. 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>." -msgstr "Eine nützliche Konstruktion, um Datensätze basierend auf Inhaltsteilen eines Textfelds auszuwählen, besteht darin, eine versteckte Spalte mit <item type=\"input\">\"LIKE '%' || :Teil_des_Felds || '%'\"</item> als Kriterium hinzuzufügen. Dies wird Datensätze mit einem exakten Treffer auswählen. Falls ein Test ohne Berücksichtigung der Groß- und Kleinschreibung benötigt wird, besteht eine Lösung darin <item type=\"input\">LOWER (Feldname)</item> als Feld und <item type=\"input\">LIKE LOWER ( '%' || :Teil_des_Felds || '%' )</item> als Kriterium zu verwenden. Beachten Sie, dass die Leerzeichen im Kriterium wichtig sind; falls sie weggelassen werden, interpretiert der SQL-Parser das gesamte Kriterium als eine passende Zeichenkette. Im <link href=\"text/sdatabase/020010100.xhp#sqlmode\">SQL-Modus</link> sollte dies als <item type=\"input\">LOWER ( \"Feldname\" ) LIKE LOWER ( '%' || :Teil_des_Felds || '%' )</item> eingegeben werden." +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 #: 02010100.xhp @@ -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 |