diff options
Diffstat (limited to 'source/nn/helpcontent2/source/text/sdatabase.po')
| -rw-r--r-- | source/nn/helpcontent2/source/text/sdatabase.po | 141 |
1 files changed, 66 insertions, 75 deletions
diff --git a/source/nn/helpcontent2/source/text/sdatabase.po b/source/nn/helpcontent2/source/text/sdatabase.po index 8125d04523d..0710e7a4f24 100644 --- a/source/nn/helpcontent2/source/text/sdatabase.po +++ b/source/nn/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-09-13 09:36+0000\n" "Last-Translator: Kolbjørn Stuestøl <kolbjoern@stuestoel.no>\n" "Language-Team: Norwegian Nynorsk <https://translations.documentfoundation.org/projects/libo_help-master/textsdatabase/nn/>\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>visingar; laga databasevisingar (Base)</bookmark_value><bookmark_value>spørjingar; laga i utformingsvising (Base)</bookmark_value><bookmark_value>utforma; spørjingar (Base)</bookmark_value><bookmark_value>utformingsvising; spørjingar og visingar (Base)</bookmark_value><bookmark_value>slå saman;tabellar (Base)</bookmark_value><bookmark_value>tabellar i databasar; slå saman for spørjingar (Base)</bookmark_value><bookmark_value>spørjingar; slå saman tabellar (Base)</bookmark_value><bookmark_value>tabellar i databasar; relasjonar (Base)</bookmark_value><bookmark_value>relasjonar; slå saman tabellar (Base)</bookmark_value><bookmark_value>spørjingar; sletta tabellenkjer (Base)</bookmark_value><bookmark_value>kriterium for spørjingsutforming (Base)</bookmark_value><bookmark_value>spørjingar; formulera filtreringsvilkår (Base)</bookmark_value><bookmark_value>filtreringsvilkår;i spørjingar i Base</bookmark_value><bookmark_value>parametrar; spørjingar i Base</bookmark_value><bookmark_value>spørjingar; parameterspørjingar i Base</bookmark_value><bookmark_value>SQL; spørjingar i Base</bookmark_value><bookmark_value>lokal SQL i 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\">Spørjingsutforming</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 "Trykk på ikonet <emph>Spørjingar</emph> i eit databasedokument, og deretter på <emph>Lag spørjing i utformingsvising</emph> for å oppretta ei spørjing." -#. 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 "Nedst i vindauget for utformingsvising kan du <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"define\">velja alternativ</link> for spørjinga. For å setja opp ei spørjing, gjev du opp kva for <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"field names\">feltnamn</link> i databasen som skal vera med og <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria\">kriterium</link> for vising av felta. For å endra kolonnerekkjefølgja, dreg du ei kolonneoverskrift til ei ny plassering, eller merkjar kolonnen og trykkjer <switchinline select=\"sys\"><caseinline select=\"MAC\">Cmd</caseinline><defaultinline>Ctrl </defaultinline></switchinline> + Piltast." +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 "For eksempel:" -#. ynSGq -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148478\n" -"help.text" -msgid "SELECT \"PtNo\" AS \"PartNum\" FROM \"Parts\"" -msgstr "SELECT \"Delnr\" AS \"Delnummer\" FROM \"Delar\"" - #. roTzi #: 02010100.xhp msgctxt "" @@ -996,14 +987,14 @@ msgctxt "" msgid "Criteria" msgstr "Kriterium" -#. 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\">Vel det første <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">kriteriet</link> innhaldet i datafeltet skal sorterast etter.</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>-escapesekvensen: {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 "Eksempel: select * from Del where Delnamn like '*%' {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>-escapesekvensen: {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 "Eksempel: select Del.* from {oj-element LEFT OUTER JOIN ordrar ON del.no=ordrar.DNR}" - #. mWG9p #: 02010100.xhp msgctxt "" @@ -2292,24 +2265,6 @@ msgctxt "" msgid "DateTime" msgstr "DateTime" -#. FqZXM -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149539\n" -"help.text" -msgid "Example: select {d '1999-12-31'} from world.years" -msgstr "Eksempel: select {d '1999-12-31'} from verda.år" - -#. WJ4YB -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149540\n" -"help.text" -msgid "Example: select * from mytable where years='1999-12-31'" -msgstr "Eksempel: vel * frå tabellen_min der år='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 "Parameternamna har eit kolon framføre seg både i utformings- og SQL-visinga av ei spørjing. Desse kan brukast kvar som helst der ein verdi kan brukast. Viss den same verdien skal brukast meir enn éin gong i ei spørjing, brukar du det same namnet." -#. 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 "I det enklaste tilfellet, der brukaren skriv inn ein verdi som vert samanlikna for likskap, skriv du inn namnet på parameteren med innleiande kolon i rekkja for kriterium. I <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL-modus</link> må dette skrivast som <item type=\"input\">WHERE \"Field\" = :Parameter_namn</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 #: 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 "Parameternamna kan ikkje innehalda teikna <item type=\"input\"><space>`!\"$%^*()+={}[]@'~#<>?/,</item>. Dei kan heller ikkje vera dei same som feltnamn eller reserverte ord i SQL. Derimot kan dei heita det same som aliasar." -#. 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 "Ein grei måte å merkja datapostar baserte på innhaldet i tekstfelt er å leggja til ein gøymd kolonne med kriteriet <item type=\"input\">\"LIKE '%' || :Del_av_felt || '%'\"</item>. Dette vil markera datapostar med eit nøyaktig treff. Dersom testen skal skilja mellom små og store bokstavar, kan du bruka <item type=\"input\">LOWER (Felt_namn)</item> som felt og <item type=\"input\">LIKE LOWER ( '%' || :Del_av_felt || '%' )</item> som kriterium. Merk at mellomromma i kriteriet er viktige. Utan desse mellomromma vil SQL-tolkaren leita etter samsvar for heile strengen. I <link href=\"text/shared/explorer/database/02010100.xhp#sqlmode\">SQL-modus</link> må dette skrivast inn som<item type=\"input\">LOWER ( \"Fielt_namn\" ) LIKE LOWER ( '%' || :Del_av_felt || '%' )</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 #: 02010100.xhp @@ -5919,6 +5874,42 @@ msgctxt "" msgid "For more information on SQL commands, please consult the documentation that came with the database." msgstr "Du kan finne meir informasjon om SQL-kommandoar i dokumentasjonen som fylgde med databasen." +#. 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,14 +5919,14 @@ msgctxt "" msgid "Previous commands" msgstr "Førre kommandoar" -#. 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>" -msgstr "<ahelp hid=\"dbaccess/ui/directsqldialog/sqlhistory\">Lister opp dei SQL-kommandoane som er køyrde tidlegare. Vel ein kommando og trykk <emph>Køyr</emph> for å køyra ein kommando på nytt.</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 #: 11080000.xhp @@ -5946,32 +5937,32 @@ msgctxt "" msgid "Status" msgstr "Status" -#. 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>" -msgstr "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Viser resultatet, med eventuelle feilmeldingar, for SQL-kommandoen du køyrde.</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" -msgstr "Køyr" +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>" -msgstr "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Køyrer kommandoen som du skreiv inn i boksen <emph>Køyr kommando</emph>.</ahelp>" +msgid "Displays the results of the SQL command that you ran." +msgstr "" #. 93Xfs #: 11090000.xhp |