diff options
Diffstat (limited to 'source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po')
| -rw-r--r-- | source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po | 992 |
1 files changed, 356 insertions, 636 deletions
diff --git a/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po b/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po index e98ecaa124e..bbcf4933d71 100644 --- a/source/ca-valencia/helpcontent2/source/text/shared/explorer/database.po +++ b/source/ca-valencia/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: 2018-05-16 16:54+0200\n" +"POT-Creation-Date: 2018-11-05 17:38+0100\n" "PO-Revision-Date: 2018-01-15 13:20+0000\n" "Last-Translator: joamuran <joamuran@gmail.com>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -46,8 +46,8 @@ msgctxt "" "02000000.xhp\n" "par_id3150499\n" "help.text" -msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table to multiple tables, if they are linked by common data fields." -msgstr "Una consulta és una visualització especial d'una taula. Les consultes poden mostrar determinats registres o camps dels registres, i també els poden ordenar. Podeu aplicar una consulta a una sola taula o bé a diverses taules, si estan enllaçades per camps de dades comuns." +msgid "A \"query\" is a special view of a table. A query can display chosen records or chosen fields within records; it can also sort those records. A query can apply to one table or to multiple tables, if they are linked by common data fields." +msgstr "" #: 02000000.xhp msgctxt "" @@ -406,8 +406,8 @@ 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 "La subfinestra que hi ha a la part inferior de la Vista de disseny és l'espai on heu de <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"definir\">definir</link> la consulta. Per definir una consulta, indiqueu els <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"noms dels camps\">noms dels camps</link> de la base de dades que vulgueu incloure i els <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteris\">criteris</link> per a la visualització d'estos camps. Si voleu reorganitzar les columnes d'esta subfinestra arrossegueu una capçalera de columna fins a una nova posició o seleccioneu la columna i premeu <switchinline select=\"sys\"><caseinline select=\"MAC\">Orde</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+tecla de cursor." +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 "" #: 02010100.xhp msgctxt "" @@ -582,16 +582,16 @@ 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 tell $[officename] what the relationship exists between the data in the two spreadsheets." -msgstr "Així, si per exemple disposeu, d'una banda, d'un full de càlcul per a articles identificats amb un número d'article i, de l'altra, d'un altre full de càlcul per a clients en el qual registreu tots els articles que estos clients sol·liciten mitjançant els números d'article corresponents, hi haurà una relació entre els dos camps de dades \"número d'article\". D'esta manera, si voleu crear una consulta que torne tots els articles sol·licitats per un client, haureu de recuperar les dades corresponents dels dos fulls de dades. Per fer-ho, haureu d'indicar al $[officename] que existeix una relació entre les dades dels dos fulls de càlcul." +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 "" #: 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 in the two windows appears. The corresponding condition that the content of the two field names must be identical is entered in the resulting SQL query." -msgstr "Per indicar esta relació, feu clic al nom d'un camp d'una taula (per exemple, al nom del camp \"Número-article\" de la taula Clients), manteniu premut el botó del ratolí i arrossegueu el nom del camp fins a l'altra taula (fins a \"Número-article\" de la taula Articles). Quan deixeu anar el botó del ratolí, apareixerà una línia que connectarà els dos camps de les dues finestres. La condició corresponent, segons la qual els dos noms de camp hauran de ser idèntics, s'introduirà a la consulta SQL resultant." +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 "" #: 02010100.xhp msgctxt "" @@ -614,16 +614,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3153279\n" "help.text" -msgid "Specifying link type" -msgstr "Especificació del tipus d'enllaç" +msgid "Specifying the relation type" +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3154791\n" "help.text" -msgid "If you double-click the line connecting two linked fields or call the menu command <emph>Insert - New Relation</emph>, you can specify the type of link in the <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relations\"><emph>Relations</emph></link> dialog." -msgstr "Si feu doble clic a la línia que connecta els dos camps enllaçats o crideu l'orde de menú <emph>Insereix - Relació nova</emph> s'obrirà el diàleg <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relacions\"><emph>Relacions</emph></link>, que vos permet especificar el tipus d'enllaç." +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 "" #: 02010100.xhp msgctxt "" @@ -662,8 +662,8 @@ msgctxt "" "02010100.xhp\n" "hd_id3151208\n" "help.text" -msgid "Define query" -msgstr "Definició de la consulta" +msgid "Defining the query" +msgstr "" #: 02010100.xhp msgctxt "" @@ -678,16 +678,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3154161\n" "help.text" -msgid "Specify field name" -msgstr "Especificació de noms de camp" +msgid "Specifying field names" +msgstr "" #: 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 with 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. As you do this, you can decide which column you want to add the field to. Select a field name by double-clicking. It will then be added to the next free column." -msgstr "En primer lloc, seleccioneu tots els noms dels camps de les taules que vulgueu afegir a la consulta. Per fer-ho, podeu arrossegar i deixar anar o bé fer doble clic a un nom de camp a la finestra de la taula. Si opteu pel primer mètode, utilitzeu el ratolí per arrossegar un nom de camp des de la finestra de la taula fins a l'àrea inferior del disseny de la consulta. D'esta manera, podreu decidir a quina columna voleu afegir el camp. Seleccioneu un nom de camp fent-hi doble clic per tal que s'afija a la columna lliure següent." +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 "" #: 02010100.xhp msgctxt "" @@ -710,16 +710,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3155764\n" "help.text" -msgid "Save query" -msgstr "Guardar una consulta" +msgid "Saving the query" +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3148481\n" "help.text" -msgid "Use the <emph>Save</emph> icon on the Standard Bar to save the query. You see a dialog that asks you to enter a name for the query. If the database supports schemas, you can also enter a schema." -msgstr "Utilitzeu la icona <emph>Guarda</emph> de la barra Estàndard per guardar la consulta. Visualitzareu un diàleg que vos sol·licitarà un nom per a la consulta. Si la base de dades admet esquemes, també en podreu indicar un." +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 "" #: 02010100.xhp msgctxt "" @@ -766,8 +766,8 @@ msgctxt "" "02010100.xhp\n" "par_id3154964\n" "help.text" -msgid "To filter data for the query, set the desired preferences in the lower area of the Design View. The following lines are available:" -msgstr "Per filtrar les dades per a la consulta, definiu les preferències desitjades a l'àrea inferior de la Vista de disseny. Disposareu de les línies següents:" +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 "" #: 02010100.xhp msgctxt "" @@ -782,8 +782,8 @@ msgctxt "" "02010100.xhp\n" "par_id3156372\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Enter the name of the data field that you referred to in the Query. All settings made in the lower rows refer to this field.</ahelp> If you activate a cell 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 and the criteria is valid for all table fields." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FIELD\">Introduïu el nom del camp de dades al qual heu fet referència a la consulta. Tots els paràmetres indicats a les files inferiors fan referència a este camp.</ahelp> Si activeu una cel·la fent-hi clic amb el ratolí visualitzareu un botó de cursor, amb el qual podreu seleccionar un camp. L'opció \"Nom de la taula.*\" vos permet seleccionar tots els camps de dades i els criteris seran vàlids per a tots els camps de la taula." +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 "" #: 02010100.xhp msgctxt "" @@ -798,16 +798,16 @@ 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 a query instead of the field name. This makes it possible to use user-defined column labels.</ahelp> For example, if the data field has the name PtNo and, instead of that name, you would like to have PartNum appear in the query, enter PartNum as alias." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ALIAS\">Especifica un àlies. Este àlies es llistarà en una consulta en lloc del nom del camp, amb la qual cosa es podran utilitzar etiquetes de columnes definides per l'usuari.</ahelp> Per exemple, introduïu PartNum com a àlies si el camp de dades s'anomena PtNo però preferiu que a la consulta aparega PartNum." +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 "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3155959\n" "help.text" -msgid "In an SQL statement, aliases are defined as following:" -msgstr "En una expressió SQL, els àlies es defineixen de la manera següent:" +msgid "In a SQL statement, aliases are defined as follows:" +msgstr "" #: 02010100.xhp msgctxt "" @@ -846,8 +846,8 @@ 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 the a cell with a mouse click, an arrow will appear which enables you to select another table of the current query." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_TABLE\">Ací es llista la taula de la base de dades corresponent al camp de dades seleccionat.</ahelp> Si activeu una cel·la de la taula fent-hi clic amb el ratolí, apareixerà una fletxa que vos permetrà seleccionar una altra taula de la consulta actual." +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 "" #: 02010100.xhp msgctxt "" @@ -862,8 +862,8 @@ msgctxt "" "02010100.xhp\n" "par_id3150979\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">If you click the cell, you can select among the sorting options: ascending, descending and not sorted.</ahelp> Text fields will be sorted alphabetically and numerical fields numerically. For most databases, administrators can set the sorting options." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_ORDER\">Si feu clic a la cel·la, podreu seleccionar una de les opcions d'ordenació: ascendent, descendent o sense ordenar.</ahelp> Els camps de text s'ordenaran de manera alfabètica, i els numèrics de manera numèrica. Els administradors poden definir les opcions d'ordenació per a la majoria de bases de dades." +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 "" #: 02010100.xhp msgctxt "" @@ -878,8 +878,8 @@ 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 visible in the query</ahelp>. If you only use a data field to formulate a condition, you do not necessarily need to show it." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_VISIBLE\">Si activeu la propietat <emph>Visible</emph> per a un camp de dades, este camp serà visible a la consulta</ahelp>. Noteu que si utilitzeu un determinat camp de dades només per formular una condició, no sempre serà necessari mostrar-lo." +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 "" #: 02010100.xhp msgctxt "" @@ -894,8 +894,8 @@ msgctxt "" "02010100.xhp\n" "par_id3145134\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Specifies the <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criteria </link>by which the content of the data field should be filtered.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_CRIT\">Especifica els <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteris \">criteris </link>pels quals cal filtrar els continguts del camp de dades.</ahelp>" +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 "" #: 02010100.xhp msgctxt "" @@ -910,16 +910,16 @@ msgctxt "" "02010100.xhp\n" "par_id3154585\n" "help.text" -msgid "Here you can enter one additional criterion for filtering in each line. Multiple criteria in one column will be connected by an OR link." -msgstr "Ací podeu introduir un criteri addicional per al filtratge en cada línia. Els criteris múltiples per a una columna quedaran connectats mitjançant un enllaç OR." +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 "" #: 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 to insert another line for functions:" -msgstr "També podeu utilitzar el menú contextual de les capçaleres de línia a la part inferior del disseny de la consulta per inserir una altra línia per a funcions:" +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 "" #: 02010100.xhp msgctxt "" @@ -934,16 +934,16 @@ 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 here.</ahelp> The functions you can run here depend on the database." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\" visibility=\"hidden\">Seleccioneu una funció per executar a la consulta.</ahelp> Les funcions que podreu executar dependran de la base de dades." +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 "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id8760818\n" "help.text" -msgid "If you are working with the HSQL database, the list box in the <emph>Function</emph> row offers you the following options:" -msgstr "Si treballeu amb la base de dades HSQL, el quadre de llista de la línia <emph>Funció</emph> vos oferirà les opcions següents:" +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 "" #: 02010100.xhp msgctxt "" @@ -956,14 +956,6 @@ msgstr "Opció" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3166430\n" -"help.text" -msgid "SQL" -msgstr "SQL" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3152993\n" "help.text" msgid "Effect" @@ -996,14 +988,6 @@ msgstr "Mitjana" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3145268\n" -"help.text" -msgid "AVG" -msgstr "AVG" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3154486\n" "help.text" msgid "Calculates the arithmetic mean of a field." @@ -1020,18 +1004,10 @@ msgstr "Compta" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3154260\n" -"help.text" -msgid "COUNT" -msgstr "COUNT" - -#: 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 not (b)." -msgstr "Determina el nombre de registres de la taula. Els camps buits es poden comptar (a) o no (b)." +msgid "Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b)." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1046,8 +1022,8 @@ msgctxt "" "02010100.xhp\n" "par_id3152889\n" "help.text" -msgid "b) COUNT(column): Passing a field name as an argument counts only fields in which the field name in question contains a value. Null values (empty fields) will not be counted." -msgstr "b) COUNT(columna): si s'indica un nom de camp com a argument només es comptaran els camps els noms dels quals continguen un valor. No es comptaran els valors nuls (és a dir, els camps buits)." +msgid "b) COUNT(column): Passing a field name as an argument counts only those records for fields in which the field name in question contains a value. Records with fields having Null values (i.e. fields containing no characters) will not be counted." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1060,18 +1036,10 @@ msgstr "Màxim" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3148840\n" -"help.text" -msgid "MAX" -msgstr "MAX" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3159221\n" "help.text" -msgid "Determines the highest value of a field." -msgstr "Determina el valor més alt d'un camp." +msgid "Determines the highest value of a record for that field." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1084,18 +1052,10 @@ msgstr "Mínim" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3148604\n" -"help.text" -msgid "MIN" -msgstr "MIN" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3157982\n" "help.text" -msgid "Determines the lowest value of a field." -msgstr "Determina el valor més baix d'un camp." +msgid "Determines the lowest value of a record for that field." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1108,18 +1068,10 @@ msgstr "Suma" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3147070\n" -"help.text" -msgid "SUM" -msgstr "SUM" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3154536\n" "help.text" -msgid "Calculates the sum of values of associated fields." -msgstr "Calcula la suma de valors dels camps associats." +msgid "Calculates the sum of the values of records for the associated fields." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1132,18 +1084,10 @@ msgstr "Agrupa" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3145375\n" -"help.text" -msgid "GROUP BY" -msgstr "GROUP BY" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3149438\n" "help.text" -msgid "Groups query data according to the field name selected. 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." -msgstr "Agrupa les dades de la consulta d'acord amb el nom de camp seleccionat. Les funcions s'executen d'acord amb els grups indicats. A l'SQL, esta opció correspon a la clàusula GROUP BY. Si s'afig un criteri, esta entrada apareix a la clàusula SQL HAVING." +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 "" #: 02010100.xhp msgctxt "" @@ -1182,24 +1126,24 @@ msgctxt "" "02010100.xhp\n" "par_id3159205\n" "help.text" -msgid "Except for the <emph>Group</emph> function, the above functions are so-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 system in use and on the current state of the Base driver." -msgstr "Tret d'<emph>Agrupa</emph>, la resta de funcions indicades anteriorment reben la denominació de funcions d'agregats. Este tipus de funcions calculen dades per crear resums dels seus resultats. Segons el tipus de sistema de bases de dades que s'utilitze i l'estat actual del controlador del Base, també es podran utilitzar altres funcions addicionals que no apareguen en el quadre de llista." +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 "" #: 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 under <emph>Field</emph>." -msgstr "Si voleu utilitzar altres funcions que no apareguen en el quadre de llista, les haureu d'introduir a <emph>Camp</emph>." +msgid "To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3155098\n" "help.text" -msgid "You can also assign aliases to function calls. If the query is not to be displayed in the column header, enter the desired name under <emph>Alias</emph>." -msgstr "També podeu assignar àlies a les crides de funció. Si la consulta no s'ha de visualitzar a la capçalera de columna, introduïu-ne el nom desitjat a <emph>Àlies</emph>." +msgid "You can also assign aliases to function calls. If you not wish the query string to be displayed in the column header, enter a desired substitute name under <emph>Alias</emph>." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1238,8 +1182,8 @@ msgctxt "" "02010100.xhp\n" "par_id3154610\n" "help.text" -msgid "If you run this function, you cannot insert any additional columns for the query other than receiving these columns as a \"Group\" function." -msgstr "Si executeu esta funció, no podreu inserir cap columna addicional per a la consulta i només rebreu estes columnes com a funció \"Agrupa\"." +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 "" #: 02010100.xhp msgctxt "" @@ -1286,8 +1230,8 @@ msgctxt "" "02010100.xhp\n" "par_id3161652\n" "help.text" -msgid "Double-click the \"Item_No\" field from the \"Item\" table. Display the <emph>Function</emph> line using the context menu and select the Count function." -msgstr "Feu doble clic al camp \"Núm_Element\" de la taula \"Element\". Feu que es mostre la línia <emph>Funció</emph> mitjançant el menú contextual i seleccioneu la funció Compta." +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 "" #: 02010100.xhp msgctxt "" @@ -1390,8 +1334,8 @@ msgctxt "" "02010100.xhp\n" "par_id3150414\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for selection of functions.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Mostra o amaga una fila per a una selecció de funcions.</ahelp>" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1438,8 +1382,8 @@ msgctxt "" "02010100.xhp\n" "par_id3147500\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Applies only distinct values to the query.</ahelp> This applies to records containing data that appears several times in the selected fields. If the <emph>Distinct Values</emph> command is active, you will see only one record in the query (DISTINCT). Otherwise, you will see all records corresponding to the query criteria (ALL)." -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Només aplica valors diferents a la consulta.</ahelp> S'aplica als registres que contenen dades que apareixen diverses vegades en els camps seleccionats. Si l'orde <emph>Valors diferents</emph> és activa, només visualitzareu un registre a la consulta (DISTINCT). En cas contrari, visualitzareu tots els registres corresponents als criteris de la consulta (ALL)." +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 "" #: 02010100.xhp msgctxt "" @@ -1478,15 +1422,15 @@ msgctxt "" "02010100.xhp\n" "par_id3147501\n" "help.text" -msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to maximize the number of records with which query returns.</ahelp>" -msgstr "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Vos permet maximitzar el nombre de registres que retorna la consulta.</ahelp>" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Allows you to limit the maximum number of records returned by a query.</ahelp>" +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3152350\n" "help.text" -msgid "If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria." +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 "" #: 02010100.xhp @@ -1502,8 +1446,8 @@ 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. You can also enter the SQL command directly. The following tables give an overview of the operators and commands:" -msgstr "Disposeu de diversos operadors i ordes per formular condicions de filtratge. A banda dels operadors relacionals, disposeu d'una sèrie d'ordes SQL específiques per consultar els continguts dels camps de la base de dades. Si utilitzeu estes ordes en la sintaxi del $[officename], el $[officename] les convertirà a la sintaxi SQL corresponent de manera automàtica. També podeu introduir estes ordes SQL directament. Les taules següents vos ofereixen una visió general d'estos operadors i ordes:" +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 "" #: 02010100.xhp msgctxt "" @@ -1532,14 +1476,6 @@ msgstr "La condició es compleix si..." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3156161\n" -"help.text" -msgid "=" -msgstr "=" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3153026\n" "help.text" msgid "equal to" @@ -1558,16 +1494,8 @@ 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 = will be automatically adopted." -msgstr "L'operador = no es mostrarà en els camps de la consulta. Si introduïu un valor sense cap operador, s'interpretarà l'operador = de manera automàtica." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3150470\n" -"help.text" -msgid "<>" -msgstr "<>" +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 "" #: 02010100.xhp msgctxt "" @@ -1588,14 +1516,6 @@ msgstr "... el contingut del camp no es correspon amb l'expressió indicada." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3153015\n" -"help.text" -msgid ">" -msgstr ">" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3146815\n" "help.text" msgid "greater than" @@ -1612,14 +1532,6 @@ msgstr "... el contingut del camp és major que l'expressió indicada." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3147270\n" -"help.text" -msgid "<" -msgstr "<" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3147379\n" "help.text" msgid "less than" @@ -1636,14 +1548,6 @@ msgstr "... el contingut del camp és menor que l'expressió indicada." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3149787\n" -"help.text" -msgid ">=" -msgstr ">=" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3150636\n" "help.text" msgid "greater than or equal to" @@ -1660,14 +1564,6 @@ msgstr "... el contingut del camp és major que l'expressió indicada o igual a #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3157964\n" -"help.text" -msgid "<=" -msgstr "<=" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3154052\n" "help.text" msgid "less than or equal to" @@ -1716,22 +1612,6 @@ msgstr "La condició es compleix si..." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3154275\n" -"help.text" -msgid "IS EMPTY" -msgstr "IS EMPTY" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149893\n" -"help.text" -msgid "IS NULL" -msgstr "IS NULL" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3143236\n" "help.text" msgid "is null" @@ -1742,28 +1622,12 @@ msgctxt "" "02010100.xhp\n" "par_id3154744\n" "help.text" -msgid "... The value of the field is empty. For Yes/No fields with three states, this command automatically queries the undetermined state (neither Yes nor No)." +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 "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3146940\n" -"help.text" -msgid "IS NOT EMPTY" -msgstr "IS NOT EMPTY" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3147471\n" -"help.text" -msgid "IS NOT NULL" -msgstr "IS NOT NULL" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3151229\n" "help.text" msgid "is not empty" @@ -1774,40 +1638,24 @@ msgctxt "" "02010100.xhp\n" "par_id3145304\n" "help.text" -msgid "... the field name is not empty." -msgstr "... el nom del camp no és buit." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153578\n" -"help.text" -msgid "LIKE" -msgstr "LIKE" +msgid "... the field is not empty, i.e it contains data." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3153891\n" "help.text" -msgid "(placeholder * for any number of characters" -msgstr "(utilitzeu l'espai reservat * per a un nombre de caràcters indeterminat," +msgid "placeholder (*) for any number of characters" +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3148887\n" "help.text" -msgid "placeholder ? for exactly one character)" -msgstr "o bé l'espai reservat ? per a un sol caràcter)" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148623\n" -"help.text" -msgid "LIKE" -msgstr "LIKE" +msgid "placeholder (?) for exactly one character" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1822,16 +1670,16 @@ msgctxt "" "02010100.xhp\n" "par_id3157985\n" "help.text" -msgid "(% placeholder for any number of characters" -msgstr "(utilitzeu l'espai reservat % per a qualsevol nombre de caràcters," +msgid "placeholder (%) for any number of characters" +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3147422\n" "help.text" -msgid "Placeholder _ for exactly one character)" -msgstr "o bé l'espai reservat _ per a un sol caràcter)" +msgid "Placeholder (_) for exactly one character" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1846,32 +1694,16 @@ 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 $[officename] interface." -msgstr "... el camp de dades conté l'expressió indicada. L'espai reservat (*) indica si l'expressió x apareix al principi del contingut del camp (x*), al final (*x) o dins d'este (*x*). Quan treballeu amb consultes SQL a la interfície del $[officename] podeu utilitzar com a espais reservats tant el caràcter SQL % com l'espai reservat habitual del sistema de fitxers, (*)." +msgid "... the data field must contain the indicated search string in the order given. The position of the (*) placeholder indicates whether the searched for string (x) occurs before the placeholder (x*), after the placeholder (*x) or between the placeholders (*x*). Instead of the familiar file system (*) placeholder, you can also use the SQL (%) character as a placeholder in SQL queries in the $[officename] interface." +msgstr "" #: 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 "Els espais reservats * i % fan referència a qualsevol nombre de caràcters. Si voleu representar un sol caràcter, podeu utilitzar el signe d'interrogació (?) a la interfície del $[officename] o la ratlla baixa (_) a les consultes SQL." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152954\n" -"help.text" -msgid "NOT LIKE" -msgstr "NOT LIKE" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3161669\n" -"help.text" -msgid "NOT LIKE" -msgstr "NOT LIKE" +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 "" #: 02010100.xhp msgctxt "" @@ -1886,24 +1718,8 @@ msgctxt "" "02010100.xhp\n" "par_id3161664\n" "help.text" -msgid "... the field name does not contain the specified expression." -msgstr "... el nom del camp no conté l'expressió indicada." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149185\n" -"help.text" -msgid "BETWEEN x AND y" -msgstr "BETWEEN x AND y" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3151259\n" -"help.text" -msgid "BETWEEN x AND y" -msgstr "BETWEEN x AND y" +msgid "... the field does not contain data having the specified expression." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1918,24 +1734,8 @@ msgctxt "" "02010100.xhp\n" "par_id3154395\n" "help.text" -msgid "... the field name contains a value that lies between the two values x and y." -msgstr "... el nom del camp conté un valor que es troba entre els valors x i y." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154561\n" -"help.text" -msgid "NOT BETWEEN x AND y" -msgstr "NOT BETWEEN x AND y" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148753\n" -"help.text" -msgid "NOT BETWEEN x AND y" -msgstr "NOT BETWEEN x AND y" +msgid "... the field contains a data value that lies between the two values x and y." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1950,32 +1750,16 @@ msgctxt "" "02010100.xhp\n" "par_id3148992\n" "help.text" -msgid "... the field name contains a value that does not lie between the two values x and y." -msgstr "... el nom del camp conté un valor que no es troba entre els valors x i y." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3149995\n" -"help.text" -msgid "IN (a; b; c...)" -msgstr "IN (a; b; c...)" +msgid "... the field contains a data value that does not lie between the two values x and y." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3159167\n" "help.text" -msgid "Note that the semicolons are used as separators in all value lists!" -msgstr "Noteu que s'utilitzen signes de punt i coma com a separadors a totes les llistes de valors." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3159085\n" -"help.text" -msgid "IN (a, b, c...)" -msgstr "IN (a, b, c...)" +msgid "Note that semicolons are used as separators in all value lists!" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1990,24 +1774,8 @@ 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 an Or link. The expressions a, b, c... can be either numbers or characters" -msgstr "... el nom del camp conté una de les expressions a, b, c... indicades. Podeu expressar un nombre d'expressions il·limitat, i el resultat de la consulta queda determinat per un enllaç OR. Les expressions a, b, c... poden ser tant nombres com caràcters." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3154112\n" -"help.text" -msgid "NOT IN (a; b; c...)" -msgstr "NOT IN (a; b; c...)" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3153544\n" -"help.text" -msgid "NOT IN (a, b, c...)" -msgstr "NOT IN (a, b, c...)" +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 "" #: 02010100.xhp msgctxt "" @@ -2022,24 +1790,8 @@ msgctxt "" "02010100.xhp\n" "par_id3158439\n" "help.text" -msgid "... the field name does not contain one of the specified expressions a, b, c,..." -msgstr "... el nom del camp no conté una de les expressions a, b, c... indicades." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3145145\n" -"help.text" -msgid "= TRUE" -msgstr "= TRUE" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146804\n" -"help.text" -msgid "= TRUE" -msgstr "= TRUE" +msgid "... the field does not contain one of the specified expressions a, b, c,..." +msgstr "" #: 02010100.xhp msgctxt "" @@ -2060,22 +1812,6 @@ msgstr "... el nom del camp té el valor True." #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3159212\n" -"help.text" -msgid "= FALSE" -msgstr "= FALSE" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3144751\n" -"help.text" -msgid "= FALSE" -msgstr "= FALSE" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3149955\n" "help.text" msgid "has the value false" @@ -2086,8 +1822,8 @@ msgctxt "" "02010100.xhp\n" "par_id3146850\n" "help.text" -msgid "... the field name has the value false." -msgstr "... el nom del camp té el valor False." +msgid "... the field data value is set to false." +msgstr "" #: 02010100.xhp msgctxt "" @@ -2100,14 +1836,6 @@ msgstr "Exemples" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3153792\n" -"help.text" -msgid "='Ms.'" -msgstr "='Sra.'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3150948\n" "help.text" msgid "returns field names with the field content \"Ms.\"" @@ -2116,14 +1844,6 @@ msgstr "retorna els noms de camp que continguen \"Sra.\"" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id315379A\n" -"help.text" -msgid "<'2001-01-10'" -msgstr "<'2001-01-10'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id315094A\n" "help.text" msgid "returns dates that occurred before January 10, 2001" @@ -2132,82 +1852,42 @@ msgstr "retorna les dates anteriors al 10 de gener de 2001" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3150333\n" -"help.text" -msgid "LIKE 'g?ve'" -msgstr "LIKE 'c?la'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3147332\n" "help.text" -msgid "returns field names with field content such as \"give\" and \"gave\"." -msgstr "retorna noms de camp amb continguts com ara \"cola\" i \"cala\"." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3146062\n" -"help.text" -msgid "LIKE 'S*'" -msgstr "LIKE 'S*'" +msgid "returns records with field content such as \"give\" and \"gave\"." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3155350\n" "help.text" -msgid "returns data fields with field contents such as \"Sun\"." -msgstr "retorna camps de dades amb continguts com ara \"Sol\"." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152883\n" -"help.text" -msgid "BETWEEN 10 AND 20" -msgstr "BETWEEN 10 AND 20" +msgid "returns records with field contents such as \"Sun\"." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3159406\n" "help.text" -msgid "returns field names with field content between the values 10 and 20. (The fields can be either text fields or number fields)." -msgstr "retorna noms de camp amb continguts que es troben entre els valors 10 i 20 (els camps poden ser tant numèrics com de text)." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3148765\n" -"help.text" -msgid "IN (1; 3; 5; 7)" -msgstr "IN (1; 3; 5; 7)" +msgid "returns records with field content between the values 10 and 20. (The fields can be either text fields or number fields)." +msgstr "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3149712\n" "help.text" -msgid "returns field names 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 "retorna noms de camp amb els valors 1, 3, 5, 7. Si, per exemple, el nom de camp conté un número d'element, podeu crear una consulta que torne l'element amb el número especificat." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152948\n" -"help.text" -msgid "NOT IN ('Smith')" -msgstr "NOT IN ('Martí')" +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 "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3147279\n" "help.text" -msgid "returns field names that do not contain \"Smith\"." -msgstr "retorna noms de camp que no continguen \"Martí\"." +msgid "returns records that do not contain \"Smith\"." +msgstr "" #: 02010100.xhp msgctxt "" @@ -2262,8 +1942,8 @@ 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 see it that strict)." -msgstr "Per consultar el contingut d'un camp de text, heu d'escriure l'expressió entre cometes simples. La distinció entre majúscules i minúscules dependrà de la base de dades que s'estiga utilitzant. Per definició, LIKE distingeix entre majúscules i minúscules (malgrat que algunes bases de dades no segueixen este criteri estrictament)." +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 "" #: 02010100.xhp msgctxt "" @@ -2324,30 +2004,6 @@ msgstr "Data" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id315913112\n" -"help.text" -msgid "{D'YYYY-MM-DD'}" -msgstr "{D'YYYY-MM-DD'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id314975313\n" -"help.text" -msgid "{d 'YYYY-MM-DD'}" -msgstr "{d 'YYYY-MM-DD'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id314975314\n" -"help.text" -msgid "'YYYY-MM-DD'" -msgstr "'YYYY-MM-DD'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id31559471\n" "help.text" msgid "Time" @@ -2356,30 +2012,6 @@ msgstr "Hora" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id31559472\n" -"help.text" -msgid "{D'HH:MM:SS'}" -msgstr "{D'HH:MM:SS'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31559473\n" -"help.text" -msgid "{t 'HH:MI:SS[.SS]'}" -msgstr "{t 'HH:MI:SS[.SS]'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31559474\n" -"help.text" -msgid "'HH:MI:SS[.SS]'" -msgstr "'HH:MI:SS[.SS]'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id31509641\n" "help.text" msgid "DateTime" @@ -2388,30 +2020,6 @@ msgstr "Data i hora" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id31509642\n" -"help.text" -msgid "{D'YYYY-MM-DD HH:MM:SS'}" -msgstr "{D'YYYY-MM-DD HH:MM:SS'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31509643\n" -"help.text" -msgid "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}" -msgstr "{ts 'YYYY-MM-DD HH:MI:SS[.SS]'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id31509644\n" -"help.text" -msgid "'YYYY-MM-DD HH:MI:SS[.SS]'" -msgstr "'YYYY-MM-DD HH:MI:SS[.SS]'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3149539\n" "help.text" msgid "Example: select {d '1999-12-31'} from world.years" @@ -2430,7 +2038,7 @@ msgctxt "" "02010100.xhp\n" "par_id3150510\n" "help.text" -msgid "All date expressions (literals) must be enclosed with single quotation marks. (Consult the reference for the particular database and connector you are using for more details.)" +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 "" #: 02010100.xhp @@ -2662,32 +2270,32 @@ 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 design, $[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 been created previously." -msgstr "Si treballeu amb el $[officename] no necessitareu tindre coneixements d'SQL per a la majoria de consultes, ja que no haureu d'introduir codi SQL. Si creeu una consulta en el disseny de la consulta, el $[officename] convertirà automàticament les vostres instruccions en la sintaxi SQL corresponent. Podeu utilitzar el botó <emph>Commuta la vista de disseny a activa/inactiva</emph> per passar a la vista SQL, on podreu visualitzar les ordes SQL per a una consulta que hàgeu creat anteriorment." +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 "" #: 02010100.xhp msgctxt "" "02010100.xhp\n" "par_id3152412\n" "help.text" -msgid "You can formulate your query directly in the SQL code. Note, however, that the special syntax is dependent upon the database system that you use." -msgstr "També podeu formular una consulta directament en codi SQL. No obstant això, noteu que la sintaxi especial dependrà del sistema de bases de dades que utilitzeu." +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 "" #: 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 <emph>Query design</emph>. These queries must be executed in native SQL mode." -msgstr "Si introduïu el codi SQL manualment, podreu crear consultes específiques per a SQL no admeses per la interfície gràfica al <emph>Disseny de la consulta</emph>. Estes consultes s'hauran d'executar en mode SQL natiu." +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 "" #: 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]." -msgstr "Fent clic a la icona <link href=\"text/shared/02/14030000.xhp\" name=\"Executa l'orde SQL directament\"><emph>Executa l'orde SQL directament</emph></link> de la vista SQL podreu formular una consulta que no siga processada pel $[officename]." +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 "" #: 02010101.xhp msgctxt "" @@ -2774,8 +2382,8 @@ msgctxt "" "02010101.xhp\n" "par_id3152482\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the link type of the selected link.</ahelp> Some databases support only a subset of the possible types." -msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Indica de quin tipus és l'enllaç seleccionat.</ahelp> Algunes bases de dades només admeten un subconjunt de tots els tipus possibles." +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">Specifies the join type of the selected join.</ahelp> Some databases support only a subset of the various possible types." +msgstr "" #: 02010101.xhp msgctxt "" @@ -2790,8 +2398,8 @@ msgctxt "" "02010101.xhp\n" "par_id3155936\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the internal join, the results table contains only the records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." -msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Amb la unió interna, la taula de resultats només conté els registres per als quals el contingut dels camps enllaçats és el mateix. </ahelp> A l'SQL del $[officename] este tipus d'enllaç es crea mitjançant la clàusula WHERE corresponent." +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In an inner join, the results table contains only those records for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link is created by a corresponding WHERE clause." +msgstr "" #: 02010101.xhp msgctxt "" @@ -2806,8 +2414,8 @@ msgctxt "" "02010101.xhp\n" "par_id3166450\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the left join, the results table contains all fields of the left table and only those fields of the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." -msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Amb la unió esquerra, la taula de resultats conté tots els camps de la taula esquerra i només els camps de la taula dreta per als quals el contingut dels camps enllaçats és el mateix.</ahelp> A l'SQL del $[officename] este tipus d'enllaç correspon a l'orde LEFT OUTER JOIN." +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a left join, the results table contains all records of the queried fields from the left table and only those records of the queried fields from the right table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the LEFT OUTER JOIN command." +msgstr "" #: 02010101.xhp msgctxt "" @@ -2822,8 +2430,8 @@ msgctxt "" "02010101.xhp\n" "par_id3150647\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">With the right join, the results table contains all fields of the right table and only those fields of the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." -msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Amb la unió dreta, la taula de resultats conté tots els camps de la taula dreta i només els camps de la taula esquerra per als quals el contingut dels camps enllaçats és el mateix.</ahelp> A l'SQL del $[officename] este tipus d'enllaç correspon a l'orde RIGHT OUTER JOIN." +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a right join, the results table contains all records of the queried fields from the right table and only those records of the queried fields from the left table for which the content of the linked fields is the same.</ahelp> In $[officename] SQL this type of link corresponds to the RIGHT OUTER JOIN command." +msgstr "" #: 02010101.xhp msgctxt "" @@ -2838,8 +2446,8 @@ msgctxt "" "02010101.xhp\n" "par_id3163665\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">For a full join, the results table contains all fields of the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command." -msgstr "<ahelp hid=\"dbaccess/ui/joindialog/type\">Amb la unió completa, la taula de resultats conté tots els camps de les taules esquerra i dreta.</ahelp> A l'SQL del $[officename] este tipus d'enllaç correspon a l'orde FULL OUTER JOIN." +msgid "<ahelp hid=\"dbaccess/ui/joindialog/type\">In a full join, the results table contains all records of the queried fields from the left and right tables.</ahelp> In the SQL of $[officename] this type of link corresponds to the FULL OUTER JOIN command." +msgstr "" #: 02010101.xhp msgctxt "" @@ -2854,8 +2462,8 @@ msgctxt "" "02010101.xhp\n" "par_id0305200912031977\n" "help.text" -msgid "<ahelp hid=\".\">Inserts the keyword NATURAL into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>" -msgstr "<ahelp hid=\".\">Insereix la paraula clau NATURAL a l'expressió SQL que defineix la relació. La relació uneix totes les columnes que tenen el mateix nom de columna en ambdues taules. La taula unida resultant conté només una columna per cada parella de columnes que tenen el mateix nom.</ahelp>" +msgid "<ahelp hid=\".\">In a natural join, the keyword NATURAL in inserted into the SQL statement that defines the relation. The relation joins all columns that have the same column name in both tables. The resulting joined table contains only one column for each pair of equally named columns.</ahelp>" +msgstr "" #: 04000000.xhp msgctxt "" @@ -2910,8 +2518,8 @@ msgctxt "" "04000000.xhp\n" "par_id3156156\n" "help.text" -msgid "The Form Controls toolbar offers the tools required to create a form in a text, table, drawing, or presentation document." -msgstr "La barra d'eines Controls de formulari vos ofereix les eines necessàries per crear un formulari en un text, una taula, un dibuix o una presentació." +msgid "The Form Controls toolbar provides the tools required to create a form in a text, table, drawing, or presentation document." +msgstr "" #: 04000000.xhp msgctxt "" @@ -2998,32 +2606,32 @@ msgctxt "" "04030000.xhp\n" "par_id3153146\n" "help.text" -msgid "In the form design you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>." -msgstr "En el disseny dels formularis podeu <link href=\"text/shared/02/01170000.xhp\" name=\"incloure controls\">incloure controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"aplicar propietats\">aplicar propietats</link>, definir les <link href=\"text/shared/02/01170200.xhp\" name=\"propietats de formulari\">propietats de formulari</link> i també <link href=\"text/shared/02/01170203.xhp\" name=\"definir subformularis\">definir subformularis</link>." +msgid "In form design mode you can <link href=\"text/shared/02/01170000.xhp\" name=\"include controls\">include controls</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"apply properties\">apply properties</link> to them, define <link href=\"text/shared/02/01170200.xhp\" name=\"Form properties\">Form properties</link>, and <link href=\"text/shared/02/01170203.xhp\" name=\"define subforms\">define subforms</link>." +msgstr "" #: 04030000.xhp msgctxt "" "04030000.xhp\n" "par_id3154924\n" "help.text" -msgid "The<emph> Form Navigator</emph> icon <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>." -msgstr "La icona<emph> Navegador de formularis</emph> <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icona</alt></image> de la barra Disseny del formulari obri el <link href=\"text/shared/02/01170600.xhp\" name=\"Navegador de formularis\"><emph>Navegador de formularis</emph></link>." +msgid "The<emph> Form Navigator</emph> icon<image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icon</alt></image> on the Form Design bar opens the <link href=\"text/shared/02/01170600.xhp\" name=\"Form Navigator\"><emph>Form Navigator</emph></link>." +msgstr "" #: 04030000.xhp msgctxt "" "04030000.xhp\n" "par_id3153968\n" "help.text" -msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in editing mode." -msgstr "La icona <link href=\"text/shared/02/01171000.xhp\" name=\"Obri en mode de disseny\"><emph>Obri en mode de disseny</emph></link> <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icona</alt></image> vos permet guardar un document de formulari de manera que sempre s'òbriga en mode d'edició." +msgid "The <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Open in Design Mode</emph></link> icon<image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icon</alt></image> allows you to save a form document so that it always opens in form design mode." +msgstr "" #: 04030000.xhp msgctxt "" "04030000.xhp\n" "par_id3154948\n" "help.text" -msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>" -msgstr "En cas que es produïsca un error en assignar propietats als objectes continguts en el formulari (per exemple, si assigneu una taula de base de dades que no existeix per a un objecte), es mostrarà el missatge d'error corresponent. Este missatge pot contindre un botó <emph>Més</emph>. <ahelp hid=\"dummy\">Si hi feu clic, visualitzareu un diàleg amb més informació sobre l'error.</ahelp>" +msgid "If there is an error when assigning properties to the objects contained in the form (for example, when assigning a non-existent database table to an object), a corresponding error message appears. This error message may contain a <emph>More</emph> button. <ahelp hid=\"dummy\">If you click on <emph>More</emph>, a dialog displaying more information about the current problem appears.</ahelp>" +msgstr "" #: 05000000.xhp msgctxt "" @@ -3046,8 +2654,8 @@ msgctxt "" "05000000.xhp\n" "par_id3147102\n" "help.text" -msgid "Data sources tables allow you see your data line by line. You can make new entries and deletions." -msgstr "Les taules de fonts de dades vos permeten visualitzar les dades línia per línia. Hi podeu incloure entrades noves i suprimir-ne." +msgid "Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records." +msgstr "" #: 05000000.xhp msgctxt "" @@ -3102,16 +2710,16 @@ msgctxt "" "05000001.xhp\n" "par_id3163829\n" "help.text" -msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a special table within the database, select the corresponding table and open its context menu." -msgstr "El menú contextual del contenidor de taules vos ofereix diverses funcions que s'apliquen a totes les taules de la base de dades. Per editar una taula específica de la base de dades, seleccioneu-la i obriu-ne el menú contextual." +msgid "The context menu of the table container offers various functions that apply to all database tables. To edit a particular table within the database, select the corresponding table and open its context menu." +msgstr "" #: 05000001.xhp msgctxt "" "05000001.xhp\n" "par_id3146958\n" "help.text" -msgid "Depending on the context, it is possible that not all the functions for your current database are listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases." -msgstr "Segons el context, és possible que els menús contextuals no llistin totes les funcions disponibles per a la base de dades actual. Per exemple, l'orde <emph>Relacions</emph>, que permet definir relacions entre diverses taules, només està disponible per a les bases de dades relacionals." +msgid "Depending on the context, it is possible that not all the functions for your current database will be listed in the context menus. For example, the <emph>Relationships</emph> command for defining relationships between various tables is only available with relational databases." +msgstr "" #: 05000001.xhp msgctxt "" @@ -3150,8 +2758,8 @@ msgctxt "" "05000003.xhp\n" "par_id3148520\n" "help.text" -msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user's name in this dialog." -msgstr "Vos permet introduir i confirmar una contrasenya nova o modificada. Si heu definit un usuari nou, introduïu-ne el nom en este diàleg." +msgid "Allows you to enter and confirm a new or changed password. If you have defined a new user, enter the user name in this dialog." +msgstr "" #: 05000003.xhp msgctxt "" @@ -3182,8 +2790,8 @@ msgctxt "" "05000003.xhp\n" "par_id3147576\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password.</ahelp> This field is visible when you have started the dialog via <emph>Change password</emph>." -msgstr "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Introduïu la contrasenya anterior.</ahelp> Este camp és visible si heu obert el diàleg a través de <emph>Canvia la contrasenya</emph>." +msgid "<ahelp hid=\"dbaccess/ui/password/oldpassword\">Enter the old password here.</ahelp> This field is visible when you have opened the dialog via <emph>Change password</emph>." +msgstr "" #: 05000003.xhp msgctxt "" @@ -3238,8 +2846,8 @@ msgctxt "" "05010000.xhp\n" "par_id3152363\n" "help.text" -msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of a table." -msgstr "A la finestra <emph>Disseny de taula</emph> podeu definir taules noves o editar l'estructura d'una taula existent." +msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table." +msgstr "" #: 05010000.xhp msgctxt "" @@ -3278,8 +2886,8 @@ msgctxt "" "05010000.xhp\n" "par_id3156113\n" "help.text" -msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. Note the database restrictions, such as the length of the name, special characters and spaces.</ahelp>" -msgstr "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Indica el nom del camp de dades. Noteu les restriccions de la base de dades, com ara la longitud del nom, els caràcters especials i els espais.</ahelp>" +msgid "<ahelp hid=\"HID_TABDESIGN_NAMECELL\">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3294,8 +2902,8 @@ msgctxt "" "05010000.xhp\n" "par_id3154897\n" "help.text" -msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type.</ahelp>" -msgstr "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Indica el tipus de camp.</ahelp>" +msgid "<ahelp hid=\"HID_TABDESIGN_TYPECELL\">Specifies the field type. The available field types are limited by the database engine being used.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3310,8 +2918,8 @@ msgctxt "" "05010000.xhp\n" "par_id3145315\n" "help.text" -msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description.</ahelp>" -msgstr "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Indica una descripció opcional.</ahelp>" +msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3398,8 +3006,8 @@ msgctxt "" "05010000.xhp\n" "par_id3149456\n" "help.text" -msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has been saved.</ahelp>" -msgstr "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Insereix una fila buida damunt de la fila actual si la taula no s'ha guardat. En cas que l'hàgeu guardada, la fila buida s'inserirà al final de la taula.</ahelp>" +msgid "<ahelp hid=\"SID_TABLEDESIGN_INSERTROWS\">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3414,8 +3022,8 @@ msgctxt "" "05010000.xhp\n" "par_id3150398\n" "help.text" -msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field in this line is a primary key.</ahelp> By clicking the command you activate/deactivate the status. The command is only visible if the data source supports primary keys." -msgstr "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">Si l'orde està activada amb una marca de selecció, el camp de dades d'esta línia serà una clau primària.</ahelp> Podeu activar i desactivar este estat fent clic a l'orde, que només és visible si la font de dades admet claus primàries." +msgid "<ahelp hid=\"SID_TABLEDESIGN_TABED_PRIMARYKEY\">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys." +msgstr "" #: 05010000.xhp msgctxt "" @@ -3446,8 +3054,8 @@ msgctxt "" "05010000.xhp\n" "par_id3144761\n" "help.text" -msgid "Specifies the length of the data field." -msgstr "Indica la longitud del camp de dades." +msgid "Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters." +msgstr "" #: 05010000.xhp msgctxt "" @@ -3494,8 +3102,8 @@ msgctxt "" "05010000.xhp\n" "par_id3155131\n" "help.text" -msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code that you can select with the<emph> ... </emph>button.</ahelp>" -msgstr "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Mostra el codi de format, que podeu seleccionar amb el botó <emph> ... </emph>.</ahelp>" +msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3526,8 +3134,8 @@ msgctxt "" "05010000.xhp\n" "par_id3150685\n" "help.text" -msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays help texts.</ahelp>" -msgstr "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Mostra textos d'ajuda.</ahelp>" +msgid "<ahelp hid=\"HID_TABLE_DESIGN_HELP_WINDOW\">Displays a help string or hint defined by the database designer for the given field.</ahelp>" +msgstr "" #: 05010100.xhp msgctxt "" @@ -3550,8 +3158,8 @@ msgctxt "" "05010100.xhp\n" "par_id3166460\n" "help.text" -msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you edit the indexes for the current table.</ahelp>" -msgstr "<ahelp hid=\".uno:DBIndexDesign\">El diàleg <emph>Disseny d'índex </emph>vos permet editar els índexs per a la taula actual.</ahelp>" +msgid "<ahelp hid=\".uno:DBIndexDesign\">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp>" +msgstr "" #: 05010100.xhp msgctxt "" @@ -3566,8 +3174,8 @@ msgctxt "" "05010100.xhp\n" "par_id3155342\n" "help.text" -msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays the available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>" -msgstr "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Mostra els índexs disponibles. Per editar un índex, seleccioneu-lo a la llista. El diàleg mostrarà els detalls de l'índex seleccionat.</ahelp>" +msgid "<ahelp hid=\"dbaccess/ui/indexdesigndialog/INDEX_LIST\">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp>" +msgstr "" #: 05010100.xhp msgctxt "" @@ -3662,8 +3270,8 @@ msgctxt "" "05010100.xhp\n" "par_id3154938\n" "help.text" -msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon." -msgstr "Quan canvieu els detalls de l'índex actual i seleccioneu un altre índex, els canvis realitzats es traspassen immediatament a la font de dades. Només podreu eixir del diàleg o seleccionar un altre índex en cas que la font de dades reconegui els canvis correctament, o bé podeu desfer els canvis fent clic a la icona <emph>Reinicialitza l'índex actual</emph>." +msgid "As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon." +msgstr "" #: 05010100.xhp msgctxt "" @@ -3726,8 +3334,8 @@ msgctxt "" "05010100.xhp\n" "par_id3149561\n" "help.text" -msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order.</ahelp>" -msgstr "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determina el criteri d'ordenació.</ahelp>" +msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>" +msgstr "" #: 05010100.xhp msgctxt "" @@ -3798,8 +3406,8 @@ msgctxt "" "05020000.xhp\n" "par_id3149235\n" "help.text" -msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables that you want." -msgstr "En triar <emph>Eines - Relacions</emph> s'obri una finestra que mostra totes les relacions existents entre les taules de la base de dades actual. Si no s'ha definit cap relació, o si voleu relacionar altres taules de la base de dades, feu clic a la icona <emph>Afig taules</emph>. S'obrirà el diàleg <link href=\"text/shared/02/14020100.xhp\" name=\"Afig taules\">Afig taules</link>, on podreu seleccionar les taules que vulgueu." +msgid "When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click on the <emph>Add Tables</emph> icon. The <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Add Tables</link> dialog opens in which you can select the tables with which to create a relation." +msgstr "" #: 05020000.xhp msgctxt "" @@ -3814,8 +3422,8 @@ msgctxt "" "05020000.xhp\n" "par_id3150541\n" "help.text" -msgid "The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key." -msgstr "Les taules seleccionades es mostren a l'àrea superior de la vista de disseny. Podeu tancar una finestra de taula mitjançant el menú contextual o la tecla Supr." +msgid "The selected tables are shown in the top area of the relation design view. You can close a table window through the context menu or with the Delete key." +msgstr "" #: 05020000.xhp msgctxt "" @@ -3830,16 +3438,16 @@ msgctxt "" "05020000.xhp\n" "hd_id3148922\n" "help.text" -msgid "Primary key and other key" -msgstr "Claus primàries i altres claus" +msgid "Primary key and foreign keys" +msgstr "" #: 05020000.xhp msgctxt "" "05020000.xhp\n" "par_id3149168\n" "help.text" -msgid "If you want to define a relation among the different tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key." -msgstr "Si voleu definir una relació entre diverses taules, heu d'introduir una <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"clau primària\">clau primària</link> que identifiqui clarament un camp de dades de la taula. Podeu fer referència a la clau primària des d'altres taules per accedir a les dades d'esta taula. Tots els camps de dades que facen referència a esta clau primària s'identificaran com a una clau externa." +msgid "If you want to define a relation among the various tables, you should enter a <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">primary key</link> that uniquely identifies a data field of an existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as a foreign key." +msgstr "" #: 05020000.xhp msgctxt "" @@ -3870,8 +3478,8 @@ msgctxt "" "05020000.xhp\n" "par_id3155430\n" "help.text" -msgid "All existing relations are shown in the relations windows by a line that connects the primary and other key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key." -msgstr "La finestra de relacions mostra totes les relacions existents, en què una línia connecta el camp de clau primària amb la resta de camps de clau. Podeu afegir una relació arrossegant el camp d'una taula i deixant-lo anar damunt del camp d'una altra taula. Per suprimir una relació, seleccioneu-la i premeu la tecla Supr." +msgid "All existing relations are shown in the relations windows by a line that connects the primary and foreign key fields. You can add a relation by using drag-and-drop to drop the field of one table onto the field of the other table. A relation is removed again by selecting it and pressing the Delete key." +msgstr "" #: 05020000.xhp msgctxt "" @@ -3886,8 +3494,8 @@ msgctxt "" "05020000.xhp\n" "par_id3153093\n" "help.text" -msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the external database." -msgstr "Si utilitzeu el $[officename] com a aplicació per a una base de dades relacional, la creació i supressió de relacions no se situarà en una memòria intermèdia del $[officename], sinó que es reenviarà automàticament a la base de dades externa." +msgid "If you use $[officename] as the front-end for a relational database, the creation and deletion of relationships is not placed in an intermediate memory by $[officename], but is forwarded directly to the database." +msgstr "" #: 05020000.xhp msgctxt "" @@ -11017,6 +10625,158 @@ msgctxt "" msgid "You can click the date or time field and drag to another position within the same area, or edit the properties in the Properties window." msgstr "Podeu fer clic al camp de data o d'hora i arrossegar-lo a una altra posició de la mateixa àrea, i també en podeu editar les propietats a la finestra Propietats." +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"tit\n" +"help.text" +msgid "Insert Fields" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"bm_id61540566967968\n" +"help.text" +msgid "<bookmark_value>insert fields;in report design</bookmark_value> <bookmark_value>add fields;in report design</bookmark_value> <bookmark_value>report design;add fields to report</bookmark_value>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"hd_id361540562942432\n" +"help.text" +msgid "<variable id=\"addfields\"><link href=\"text/shared/explorer/database/rep_insertfield.xhp\" name=\"Add Fields\">Add fields to report</link></variable>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id3587145\n" +"help.text" +msgid "<ahelp hid=\".\">The Add Field window helps you to insert the table entries in the report.</ahelp>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id4503921\n" +"help.text" +msgid "The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id171540674707522\n" +"help.text" +msgid "Choose <item type=\"menuitem\">View - Add Field</item>." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id991540674901837\n" +"help.text" +msgid "<image src=\"media/icon-themes/cmd/lc_addfield.svg\" id=\"img_id621540674901837\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id491540674901837\">Add field icon</alt></image>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id121540674874655\n" +"help.text" +msgid "Click the Add Field icon on the toolbar." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id141540563922693\n" +"help.text" +msgid "Select the field in the Add Field dialog and click <emph>Insert</emph>. You can select multiples fields pressing the <switchinline select=\"sys\"> <caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline> </switchinline> key while clicking on the fields name or using the Shift key while pressing the mouse button. Click <emph>Insert</emph> in the toolbar to add the fields to the report." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id4051026\n" +"help.text" +msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id3397320\n" +"help.text" +msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id3059785\n" +"help.text" +msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon <image id=\"img_id5605334\" src=\"media/icon-themes/cmd/lc_addfield.svg\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"hd_id251540563929787\n" +"help.text" +msgid "Sorting fields names" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id651540564204840\n" +"help.text" +msgid "<image src=\"media/icon-themes/cmd/sc_sortascending.svg\" id=\"img_id631540564204841\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id141540564204841\">Sort Ascending icon</alt></image>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id401540563992665\n" +"help.text" +msgid "Sort names ascending." +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id811540564184191\n" +"help.text" +msgid "<image src=\"media/icon-themes/cmd/sc_sortdescending.svg\" id=\"img_id391540564184192\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id571540564184192\">Sort descending icon</alt></image>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id401540563942665\n" +"help.text" +msgid "Sort names descending," +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id851540564212907\n" +"help.text" +msgid "<image src=\"media/icon-themes/cmd/lc_removefiltersort.svg\" id=\"img_id41540564212907\" width=\"1.0cm\" height=\"1.0cm\"><alt id=\"alt_id421540564212908\">Undo sorting icon</alt></image>" +msgstr "" + +#: rep_insertfield.xhp +msgctxt "" +"rep_insertfield.xhp\n" +"par_id401540533942665\n" +"help.text" +msgid "Restore original sorting" +msgstr "" + #: rep_main.xhp msgctxt "" "rep_main.xhp\n" @@ -11278,48 +11038,8 @@ msgctxt "" "rep_main.xhp\n" "par_id2531815\n" "help.text" -msgid "The Add Field window opens automatically and shows all fields of the selected table." -msgstr "S'obrirà automàticament la finestra Afig un camp, on es mostraran tots els camps de la taula seleccionada." - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id5927304\n" -"help.text" -msgid "To insert fields into the report" -msgstr "Com inserir camps a l'informe" - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id4503921\n" -"help.text" -msgid "The Add Field window helps you to insert the table entries in the report. Click the Add Field icon in the toolbar to open the Add Field window." -msgstr "La finestra Afig un camp vos ajuda a inserir les entrades de la taula a l'informe. Feu clic a la icona Afig un camp de la barra d'eines per obrir la finestra Afig un camp." - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id4051026\n" -"help.text" -msgid "Drag and drop the field names one by one from the Add Field window into the Detail area of the report. Position the fields as you like. Use the icons in the toolbars to align the fields." -msgstr "Arrossegueu i deixeu anar els noms dels camps un per un des de la finestra Afig un camp fins a l'àrea Detall de l'informe. Col·loqueu els camps com vulgueu i utilitzeu les icones de les barres d'eines per alinear-los." - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id3397320\n" -"help.text" -msgid "It is not possible to overlap the fields. If you drop a table field on the Detail area, then a label and a text box are inserted." -msgstr "No es poden superposar els camps. Si arrossegueu un camp de la taula a l'àrea Detall, s'inseriran una etiqueta i un quadre de text." - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id3059785\n" -"help.text" -msgid "You can also insert text that should be the same on every page of the report. Click the Label Field icon<image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icon</alt></image>, then drag a rectangle in the Page Header or Page Footer area. Edit the Label property to show the text you want." -msgstr "També podeu inserir un text que vulgueu que es repetisca a cada pàgina de l'informe. Feu clic a la icona Camp d'etiqueta <image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icona</alt></image> i arrossegueu un rectangle a les àrees Capçalera de pàgina o Peu de pàgina. Editeu la propietat Etiqueta perquè es mostre el text que vulgueu." +msgid "The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/> window opens automatically and shows all fields of the selected table." +msgstr "" #: rep_main.xhp msgctxt "" @@ -12030,8 +11750,8 @@ msgctxt "" "rep_prop.xhp\n" "par_id3587145\n" "help.text" -msgid "<ahelp hid=\".\">The Add Field window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>" -msgstr "<ahelp hid=\".\">La finestra Afig un camp es mostra automàticament si heu seleccionat una taula en el quadre Continguts i heu eixit d'este quadre. També podeu fer clic a la icona Afig un camp de la barra d'eines, o bé triar <item type=\"menuitem\">Visualitza - Afig un camp</item>.</ahelp>" +msgid "<ahelp hid=\".\">The <embedvar href=\"text/shared/explorer/database/rep_insertfield.xhp#addfields\" markup=\"ignore\"/> window is shown automatically when you have selected a table in the Contents box and leave that box. You can also click the Add Field icon on the toolbar, or choose <item type=\"menuitem\">View - Add Field</item>.</ahelp>" +msgstr "" #: rep_prop.xhp msgctxt "" |