diff options
Diffstat (limited to 'source/es/helpcontent2/source/text/shared/explorer/database.po')
| -rw-r--r-- | source/es/helpcontent2/source/text/shared/explorer/database.po | 998 |
1 files changed, 359 insertions, 639 deletions
diff --git a/source/es/helpcontent2/source/text/shared/explorer/database.po b/source/es/helpcontent2/source/text/shared/explorer/database.po index e8013c3f23a..d6bf8ffe2a7 100644 --- a/source/es/helpcontent2/source/text/shared/explorer/database.po +++ b/source/es/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-05-17 21:26+0000\n" "Last-Translator: Adolfo Jayme Barrientos <fito@libreoffice.org>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -45,8 +45,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» es una visualización especial de una tabla. Las consultas pueden mostrar determinados registros o campos de los registros y, si es necesario, pueden ordenar estos registros. Una consulta puede aplicarse a una tabla o a varias, si estas se enlazan a través de campos de datos en común." +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 "" @@ -405,8 +405,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 consulta <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"-\">se define</link> en el panel inferior de la vista Diseño. Para definir una consulta, especifique los <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"-\">nombres de campos</link> de la base de datos que se deben incluir, así como los <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"-\">criterios</link> de visualización de los campos. Para reorganizar las columnas en el panel inferior de la vista Diseño, arrastre la cabecera a otra posición, o bien, seleccione la columna y oprima <switchinline select=\"sys\"><caseinline select=\"MAC\">⌘</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + ↑, ↓, ← o →." +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 "" @@ -581,16 +581,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 "Si, por ejemplo, dispone de una hoja de cálculo de artículos identificados mediante un número de artículo y una hoja de cálculo de clientes en la que se registran todos los artículos pedidos por un cliente mediante el número de artículo correspondiente, entonces existe una relación entre los campos de datos \"número de artículo\". Si desea crear una consulta que devuelva todos los artículos pedidos por un cliente, deberá recuperar datos de dos hojas de cálculo. Para ello deberá indicar a $[officename] cuál es la relación entre los datos contenidos en ambas hojas." +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 "Para hacerlo, pulse un campo de datos de una tabla (p. ej. el campo de datos \"Referencia\" de la tabla de clientes) y, con la tecla del ratón pulsada, arrástrelo al campo de datos de la otra tabla (\"Referencia\" de la tabla de artículos). Cuando suelte el botón del ratón, se muestra una línea que vincula los dos campos en las dos ventanas. La condición de que el contenido de los dos campos de datos debe ser idéntico se introduce en la consulta SQL resultante." +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 "" @@ -613,16 +613,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3153279\n" "help.text" -msgid "Specifying link type" -msgstr "Especificar el tipo de enlace" +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 "Al hacer una doble pulsación en la línea de conexión entre dos campos vinculados o al acceder a la orden de menú <emph>Insertar - Relación nueva</emph>, se puede especificar el tipo de vínculo en el diálogo <link href=\"text/shared/explorer/database/02010101.xhp\" name=\"Relaciones\"><emph>Relaciones</emph></link>." +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 "" @@ -661,8 +661,8 @@ msgctxt "" "02010100.xhp\n" "hd_id3151208\n" "help.text" -msgid "Define query" -msgstr "Definir una consulta" +msgid "Defining the query" +msgstr "" #: 02010100.xhp msgctxt "" @@ -677,16 +677,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3154161\n" "help.text" -msgid "Specify field name" -msgstr "Definir campo de datos" +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 "Seleccione en primer lugar todos los nombres de campo de las tablas que desee agregar a la consulta. Para ello utilice la técnica de arrastrar y soltar o haga una doble pulsación en los nombres de campo de la ventana de la tabla. Mediante arrastrar y soltar, utilice el ratón para arrastrar un nombre de campo de la ventana de la tabla al área inferior de la ventana de diseño de consulta. Al hacerlo puede decidir en qué columna desea agregar el campo. Seleccione un nombre de campo haciendo una doble pulsación en él. Se agregará a la siguiente columna libre." +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 "" @@ -709,16 +709,16 @@ msgctxt "" "02010100.xhp\n" "hd_id3155764\n" "help.text" -msgid "Save query" -msgstr "Guardar 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 "Guarde la consulta con el icono <emph>Guardar</emph> de la barra Estándar. Un diálogo solicita la asignación de un nombre para la consulta. Si la base de datos admite esquemas, también se puede especificar un esquema." +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 "" @@ -765,8 +765,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 "Para filtrar los datos de la consulta, establezca las preferencias deseadas en el área inferior de la vista Diseño. Dispone de las siguientes líneas:" +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 "" @@ -781,8 +781,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\">Escriba el nombre del campo de datos al que hace referencia en la consulta. Los parámetros de las filas inferiores hacen referencia a este campo.</ahelp> Si activa una celda pulsando en ella con el ratón verá un botón de flecha que le permitirá seleccionar un campo. La opción \"Nombre de tabla.*\" selecciona todos los campos de datos y los criterios son válidos para todos los campos de la tabla." +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 "" @@ -797,16 +797,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 alias. Este alias se mostrará en la consulta en lugar del nombre de campo. De esta forma se pueden emplear etiquetas de columna definidas por el usuario.</ahelp> Por ejemplo, si el campo de datos se denomina NºRef. y desea que en la consulta aparezca NúmRef., escriba NúmRef. como alias." +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 SQL los alias se definen como se muestra a continuación:" +msgid "In a SQL statement, aliases are defined as follows:" +msgstr "" #: 02010100.xhp msgctxt "" @@ -845,8 +845,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\">Aquí se muestra la tabla de base de datos correspondiente al campo de datos seleccionado.</ahelp> Si activa una celda haciendo clic en ella, se muestra una flecha que permite seleccionar otra tabla 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 "" @@ -861,8 +861,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 presiona la celda, puede elegir entre las opciones de ordenamiento: ascendente, descendente y sin ordenamiento.</ahelp> Los campos de texto se ordenarán alfabéticamente, los campos numéricos en orden númerico. Para la mayoría de las bases de datos, el administrador puede definir las opciones de ordenamiento." +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 "" @@ -877,8 +877,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 selecciona la propiedad <emph>Visible</emph> para un campo de datos, dicho campo se ve en la consulta</ahelp>. Si sólo se emplea un campo de datos para formular una condición, no es necesario que se muestre." +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 "" @@ -893,8 +893,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 los <link href=\"text/shared/explorer/database/02010100.xhp\" name=\"criteria \">criterios</link>de filtro del contenido del campo de datos.</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 "" @@ -909,16 +909,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 "Introduzca en cada fila un criterio adicional para el filtrado. Los diferentes criterios de una columna se vinculan por una relación del tipo O." +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 "Por otra parte, es posible introducir una fila para funciones mediante el menú contextual de los títulos de fila en el área inferior del diseño de consulta:" +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 "" @@ -933,16 +933,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\">Seleccione una función para ejecutarse en la consulta.</ahelp> Las funciones que se puedan ejecutar dependen de la base de datos." +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 trabaja con la base de datos HSQL, el cuadro de lista en la fila <emph>Función</emph> incluye las siguientes opciones:" +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 "" @@ -955,14 +955,6 @@ msgstr "Opción" #: 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" @@ -995,14 +987,6 @@ msgstr "Promedio" #: 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." @@ -1019,18 +1003,10 @@ msgstr "Count" #: 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 número de registros en la tabla. Los campos vacíos pueden contarse (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 "" @@ -1045,8 +1021,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(column): Si introduce un campo de datos como argumento, sólo se calculan los campos cuyos campos de datos contienen un valor. Los valores cero (campos vacíos) no se tienen en cuenta." +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 "" @@ -1059,18 +1035,10 @@ msgstr "Maximum" #: 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 "Calcula el valor máximo de un campo." +msgid "Determines the highest value of a record for that field." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1083,18 +1051,10 @@ msgstr "Mínimo" #: 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 "Calcula el valor mínimo de un campo." +msgid "Determines the lowest value of a record for that field." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1107,18 +1067,10 @@ msgstr "Sum" #: 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 valores de los campos correspondientes." +msgid "Calculates the sum of the values of records for the associated fields." +msgstr "" #: 02010100.xhp msgctxt "" @@ -1131,18 +1083,10 @@ msgstr "Agrupar" #: 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 los datos de la consulta según el campo seleccionado. Las funciones se ejecutan según los grupos especificados. En SQL, esta opción corresponde a la cláusula GROUP BY. Si se agrega un criterio, esta entrada aparece en 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 "" @@ -1181,24 +1125,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 "A excepción de la función <emph>Agrupar</emph>, las funciones anteriores se conocen como funciones de totalización. Estas funciones permiten realizar resúmenes a partir de los resultados del cálculo de los datos. Además son posibles funciones que no aparecen en el cuadro de lista. Estas dependen del sistema de base de datos usado y el controlador utilizado por Base." +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 "Para utilizar otras funciones no encontradas en el cuadro de lista, debe ingresarlas en <emph>Campo</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 "También se pueden asignar alias a las funciones. Para que en el título de la columna no se muestre el nombre de la función, introduzca el nombre deseado en <emph>Alias</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 "" @@ -1237,8 +1181,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 "Al ejecutar una función no es posible añadir más columnas a la consulta, a menos que a dichas columnas se les aplique la función Agrupar." +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 "" @@ -1285,8 +1229,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 "Pulsar dos veces en el campo \"Referencia\" de la tabla \"Artículos\". Mostrar la fila <emph>Función</emph> mediante el menú contextual y seleccionar la cantidad de la función." +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 "" @@ -1389,8 +1333,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\">Muestra u oculta una fila para seleccionar funciones.</ahelp>" +msgid "<ahelp hid=\"HID_QRYDGN_ROW_FUNCTION\">Shows or hides a row for the selection of functions.</ahelp>" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1437,8 +1381,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\">Aplica a la consulta únicamente valores inequívocos.</ahelp> Se refiere a los registros que contienen datos que aparecen varias veces en los campos seleccionados. Si se ha seleccionado la opción <emph>Valores inequívocos</emph> sólo podrá ver un registro que cumpla los criterios de la consulta (DISTINCT). En caso contrario, podrá ver todos los registros correspondientes a los criterios 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 "" @@ -1477,16 +1421,16 @@ 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\">Le permite maximizar la cantidad de registros que devuelve 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." -msgstr "Si se añade un <emph>límite</emph> obtendrá cuantas filas haya especificado. Si no utiliza el límite, verá todos los registros que correspondan con los criterios de la consulta." +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 msgctxt "" @@ -1501,8 +1445,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 "Dispone de diversos operadores y órdenes para formular condiciones de filtro. Aparte de los operadores de relación, SQL dispone de órdenes específicas para consultar el contenido de campos de base de datos. Si utiliza dichas órdenes en la sintaxis de $[officename], $[officename] las convertirá automáticamente a la sintaxis correspondiente de SQL. También puede introducir la orden SQL directamente. En las tablas siguientes se ofrece un resumen de los operadores y órdenes:" +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 "" @@ -1531,14 +1475,6 @@ msgstr "La condición se cumple 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" @@ -1557,16 +1493,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 "El operador = no se mostrará en los campos de consulta. Si proporciona un valor sin operador, se adoptará automáticamente el operador =." - -#: 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 "" @@ -1587,14 +1515,6 @@ msgstr "... el contenido del campo no se corresponde con la expresión introduci #: 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" @@ -1611,14 +1531,6 @@ msgstr "... el contenido del campo es mayor que la expresión introducida." #: 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" @@ -1635,14 +1547,6 @@ msgstr "... el contenido del campo es menor que la expresión introducida." #: 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" @@ -1659,14 +1563,6 @@ msgstr "... el contenido del campo es idéntico o mayor que la expresión introd #: 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" @@ -1715,22 +1611,6 @@ msgstr "La condición se cumple 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" @@ -1741,24 +1621,8 @@ 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)." -msgstr "… El valor del campo está vacío. Para campos «sí/no» con tres estados, esta orden consulta automáticamente el estado indeterminado (ni «sí» ni «no»)." - -#: 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" +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 "" @@ -1773,40 +1637,24 @@ msgctxt "" "02010100.xhp\n" "par_id3145304\n" "help.text" -msgid "... the field name is not empty." -msgstr "... el campo de datos no está vacío." - -#: 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 "(use el marcador de posición * para un número de caracteres indeterminado," +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 bien el marcador de posición ? para un solo 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 "" @@ -1821,16 +1669,16 @@ msgctxt "" "02010100.xhp\n" "par_id3157985\n" "help.text" -msgid "(% placeholder for any number of characters" -msgstr "(use el marcador de posición % para cualquier número de caracteres," +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 bien, el marcador de posición _ para un solo carácter)" +msgid "Placeholder (_) for exactly one character" +msgstr "" #: 02010100.xhp msgctxt "" @@ -1845,32 +1693,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 campo de datos contiene la expresión introducida. Los comodines (*) indican si la expresión x se encuentra al inicio (x*), al final (*x) o dentro del contenido del campo (*x*). En las consultas SQL utilice % como comodín SQL y en la superficie de $[officename] puede utilizar el comodín habitual (*) del sistema de archivos." +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 "Los comodines * o % sustituyen un número cualquiera de caracteres. En la superficie de $[officename] se emplea como comodín para representar exactamente un solo carácter el signo de interrogación (?) y en las consultas SQL, el guión de subrayado (_)." - -#: 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 "" @@ -1885,24 +1717,8 @@ msgctxt "" "02010100.xhp\n" "par_id3161664\n" "help.text" -msgid "... the field name does not contain the specified expression." -msgstr "... el campo de datos no contiene la expresión introducida." - -#: 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 "" @@ -1917,24 +1733,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 campo de datos contiene un valor comprendido entre x y 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 "" @@ -1949,32 +1749,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 campo de datos contiene un valor no comprendido entre x y 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 "Recuerde que el punto y coma sirve de separador en todas las listas de valores" - -#: 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 "" @@ -1989,24 +1773,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 campo de datos contiene una de las expresiones introducidas a, b, c,... Se pueden introducir muchas expresiones; el resultado de la consulta se obtiene con un operador O. Las expresiones a, b, c... pueden ser tanto cifras como caracteres" - -#: 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 "" @@ -2021,24 +1789,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 campo de datos no contiene una de las expresiones introducidas a, b, c,..." - -#: 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 "" @@ -2059,22 +1811,6 @@ msgstr "... el campo de datos tiene el valor Verdadero." #: 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" @@ -2085,8 +1821,8 @@ msgctxt "" "02010100.xhp\n" "par_id3146850\n" "help.text" -msgid "... the field name has the value false." -msgstr "... el campo de datos tiene el valor False." +msgid "... the field data value is set to false." +msgstr "" #: 02010100.xhp msgctxt "" @@ -2099,14 +1835,6 @@ msgstr "Ejemplos" #: 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.\"" @@ -2115,14 +1843,6 @@ msgstr "muestra los campos de datos que contengan «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" @@ -2131,82 +1851,42 @@ msgstr "devuelve las fechas anteriores al 10 de enero de 2001" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id3150333\n" -"help.text" -msgid "LIKE 'g?ve'" -msgstr "LIKE 'd?me'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id3147332\n" "help.text" -msgid "returns field names with field content such as \"give\" and \"gave\"." -msgstr "devuelve los nombres de los campos que contienen tanto «dime» como «dame»." - -#: 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 "muestra los campos de datos con contenidos como «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 "muestra los campos de datos con contenidos comprendidos entre los valores 10 y 20. (Puede tratarse tanto de campos de texto y como de cifras.)" - -#: 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 "muestra los campos de datos con los valores 1, 3, 5, 7. Si, por ejemplo, el campo de datos contiene una referencia, se puede definir una consulta que muestre el artículo en cuestión con el número introducido." - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id3152948\n" -"help.text" -msgid "NOT IN ('Smith')" -msgstr "NOT IN ('Perez')" +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 "muestra los campos de datos que no contienen «Pérez»." +msgid "returns records that do not contain \"Smith\"." +msgstr "" #: 02010100.xhp msgctxt "" @@ -2261,8 +1941,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 "Para consultar el contenido de un cuadro de texto simplemente hay que definir la expresión entre comillas. No se diferencia entre mayúsculas y las minúsculas." +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 "" @@ -2323,30 +2003,6 @@ msgstr "Date" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id315913112\n" -"help.text" -msgid "{D'YYYY-MM-DD'}" -msgstr "{D'AAAA-MM-DD'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id314975313\n" -"help.text" -msgid "{d 'YYYY-MM-DD'}" -msgstr "{d 'AAAA-MM-DD'}" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" -"par_id314975314\n" -"help.text" -msgid "'YYYY-MM-DD'" -msgstr "'AAAA-MM-DD'" - -#: 02010100.xhp -msgctxt "" -"02010100.xhp\n" "par_id31559471\n" "help.text" msgid "Time" @@ -2355,30 +2011,6 @@ msgstr "Time" #: 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" @@ -2387,30 +2019,6 @@ msgstr "DateTime" #: 02010100.xhp msgctxt "" "02010100.xhp\n" -"par_id31509642\n" -"help.text" -msgid "{D'YYYY-MM-DD HH:MM:SS'}" -msgstr "{D'AAAA-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 'AAAA-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 "'AAAA-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" @@ -2429,8 +2037,8 @@ 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.)" -msgstr "Todas las expresiones de fecha (literales) deben entrecomillarse con comillas simples. (Para más detalles, consulte la documentación de la base de datos y conector específicos que esté utilizando.)" +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 msgctxt "" @@ -2661,32 +2269,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 "En $[officename] no es necesario tener conocimientos de SQL para crear la mayor parte de consultas, ya que no es necesario escribir el código SQL. Si crea una consulta en Diseño de consulta, $[officename] convierte automáticamente las instrucciones a la sintaxis SQL correspondiente. Si utiliza el botón <emph>Activar o desactivar la vista Diseño</emph> para cambiar la vista SQL, se pueden ver los comandos correspondientes a una consulta creada con anterioridad." +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 "La consulta se puede formular directamente en código SQL. Sin embargo, debe tenerse en cuenta que la sintaxis especial depende del sistema de base de datos que se utilice." +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 "Al introducir el código SQL de forma manual es posible crear consultas específicas en SQL que no sean compatibles con las superficies gráficas del <emph>Diseño de consulta</emph>. Estas consultas deben ejecutarse en el modo SQL nativo." +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 "Si pulsa el símbolo <link href=\"text/shared/02/14030000.xhp\" name=\"Run SQL command directly\"><emph>Ejecutar directamente la orden SQL</emph></link> en la vista SQL podrá formular una consulta no procesada por $[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 "" @@ -2773,8 +2381,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\">Especifica de qué tipo es el enlace seleccionado.</ahelp> Algunas bases de datos solo admiten algunos de los tipos posibles." +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 "" @@ -2789,8 +2397,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\">En el caso de la unión interna, la tabla de resultados contiene únicamente los registros en los que el contenido de los campos enlazados es el mismo.</ahelp> En el SQL de $[officename] este tipo de enlace se crea mediante la cláusula WHERE correspondiente." +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 "" @@ -2805,8 +2413,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\">En la unión izquierda, la tabla de resultados contiene todos los campos de la tabla izquierda y sólo los campos de la tabla derecha en los cuales el contenido de los campos vinculados es el mismo.</ahelp> En $[officename] SQL, este tipo de vínculo corresponde al comando 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 "" @@ -2821,8 +2429,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\">En la unión derecha, la tabla de resultados contiene todos los campos de la tabla derecha y sólo los campos de la tabla izquierda en los cuales el contenido de los campos vinculados es el mismo.</ahelp> En $[officename] SQL, este tipo de unión corresponde al comando 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 "" @@ -2837,8 +2445,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\">En las uniones completas, la tabla de resultados contiene todos los campos de las tablas izquierda y derecha.</ahelp> En $[officename] SQL, este tipo de vínculo corresponde al comando 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 "" @@ -2853,8 +2461,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=\".\">Inserta la palabra clave NATURAL en la instrucción SQL que define la relación. La relación une todas las columnas que tienen el mismo nombre de columna en ambas tablas. La tabla unida resultante sólo contiene una columna para cada par de columnas con el mismo nombre.</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 "" @@ -2909,8 +2517,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 "En la barra de herramientas Controles de formulario hay opciones para crear un formulario en un documento de texto, tabla, dibujo o presentación." +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 "" @@ -2997,32 +2605,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 "Durante el diseño del formulario se pueden <link href=\"text/shared/02/01170000.xhp\" name=\"incluir controles\">incluir controles</link>, <link href=\"text/shared/02/01170100.xhp\" name=\"aplicar propiedades\">aplicarles propiedades</link>, definir <link href=\"text/shared/02/01170200.xhp\" name=\"propiedades de formulario\">propiedades de formulario</link> y <link href=\"text/shared/02/01170203.xhp\" name=\"definir subformularios\">definir subformularios</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 "El icono del <emph>Navegador de formularios</emph> <image id=\"img_id3156002\" src=\"cmd/sc_showfmexplorer.png\" width=\"4.23mm\" height=\"4.23mm\"><alt id=\"alt_id3156002\">Icono</alt></image> en la barra Diseño de formularios abre el <link href=\"text/shared/02/01170600.xhp\" name=\"Navegador de formularios\"><emph>Navegador de formularios</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 "El icono <link href=\"text/shared/02/01171000.xhp\" name=\"Open in Design Mode\"><emph>Abrir en modo diseño</emph></link> <image id=\"img_id1871395\" src=\"cmd/sc_openreadonly.png\" width=\"5.59mm\" height=\"5.59mm\"><alt id=\"alt_id1871395\">Icono</alt></image> permite guardar un documento de formulario para poderlo abrir siempre en modo de edición." +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 "Si hay un error durante la asignación de propiedades a los objetos del formulario (por ejemplo, al asignar una tabla de base de datos inexistente a un objeto) se mostrará el mensaje de error correspondiente. Dicho mensaje de error puede contener el botón <emph>Opciones</emph>. <ahelp hid=\"dummy\">Si hace clic en el botón <emph>Más</emph>, se abre un diálogo con más información acerca del problema actual.</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 "" @@ -3045,8 +2653,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 "Las tablas de fuentes de datos permiten ver los datos línea a línea. También permiten introducir datos y borrarlos." +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 "" @@ -3101,16 +2709,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 contenedor de tablas ofrece diversas funciones que hacen referencia a todas las tablas de la base de datos. Para editar una tabla específica dentro de una base de datos, seleccione la tabla correspondiente y abra su 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 "En función del contexto, es posible que los menús contextuales no contengan todas las funciones de la base de datos actual. Por ejemplo, la orden <emph>Relaciones</emph> para la definición de relaciones entre diversas tablas sólo está disponible en bases de datos relacionales." +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 "" @@ -3149,8 +2757,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 "Permite escribir y confirmar una contraseña nueva o modificada. Si ha definido un usuario nuevo, escriba el nombre de éste en el diálogo." +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 "" @@ -3181,8 +2789,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\">Escriba la contraseña anterior.</ahelp> Este campo es visible si abrió la ventana mediante <emph>Cambiar contraseña</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 "" @@ -3237,8 +2845,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 "La ventana <emph>Diseño de tabla</emph> le permite definir nuevas tablas o editar la estructura de una existente." +msgid "In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table." +msgstr "" #: 05010000.xhp msgctxt "" @@ -3277,8 +2885,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\">Especifica el nombre del campo de datos. Observe las restricciones de la base de datos, como la longitud del nombre, los caracteres especiales y los espacios.</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 "" @@ -3293,8 +2901,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\">Especifica el tipo de campo.</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 "" @@ -3309,8 +2917,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\">Especifica una descripción opcional.</ahelp>" +msgid "<ahelp hid=\"HID_TABDESIGN_COMMENTCELL\">Specifies an optional description for each field.</ahelp>" +msgstr "" #: 05010000.xhp msgctxt "" @@ -3397,8 +3005,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\">Inserta una nueva fila vacía encima de la fila actual, si la tabla no se ha guardado. Inserta una nueva fila vacía al final de tabla si la tabla se ha guardado.</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 "" @@ -3413,8 +3021,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 este comando tiene una marca de comprobación, el campo de datos de esta línea es una clave principal.</ahelp> Si hace clic en el comando se activará o desactivará el estado. El comando sólo está visible si el origen de datos admite las claves principales." +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 "" @@ -3445,8 +3053,8 @@ msgctxt "" "05010000.xhp\n" "par_id3144761\n" "help.text" -msgid "Specifies the length of the data field." -msgstr "Especifique la longitud del campo de datos." +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 "" @@ -3493,8 +3101,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\">Muestra el código de formato que puede seleccionar con el botón<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 "" @@ -3525,8 +3133,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\">Muestra los textos de ayuda.</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 "" @@ -3549,8 +3157,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álogo <emph> Diseñador de Indices </emph>permite editar los índices para la tabla 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 "" @@ -3565,8 +3173,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\">Muestra los índices disponibles. Para editarlo seleccione un índice de la lista. Los detalles del índice elegido se muestran en el diálogo.</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 "" @@ -3661,8 +3269,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 "Tan pronto como cambie una características del índice actual y seleccione otro índice, el cambio se transfiere inmediatamente al origen de datos. Puede salir del diálogo, o seleccionar otro índice, si el cambio ha sido aceptado exitosamente por el origen de datos. Sin embargo, puede deshacer el cambio presionando el ícono <emph>Restablecer el índice 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 "" @@ -3725,8 +3333,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\">Define el tipo de ordenamiento.</ahelp>" +msgid "<ahelp hid=\"HID_DLGINDEX_INDEXDETAILS_SORTORDER\">Determines the sort order of the indexes.</ahelp>" +msgstr "" #: 05010100.xhp msgctxt "" @@ -3797,8 +3405,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 "Si selecciona <emph>Herramientas - Relaciones</emph>, en pantalla se muestra una ventana con todas las relaciones entre las tablas de la base de datos activa. Si no hay definidas relaciones o si desea interrelacionar otras tablas de la base de datos, haga clic en el icono <emph>Agregar tablas</emph>. Se abre el diálogo <link href=\"text/shared/02/14020100.xhp\" name=\"Add Tables\">Agregar tablas</link> para poder seleccionar las tablas pertinentes." +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 "" @@ -3813,8 +3421,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 "Las tablas seleccionadas se presentan en el área superior de la vista de diseño. Para eliminar de nuevo una ventana de una tabla utilice el menú contextual o con 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 "" @@ -3829,16 +3437,16 @@ msgctxt "" "05020000.xhp\n" "hd_id3148922\n" "help.text" -msgid "Primary key and other key" -msgstr "Llave primaria y otra llave" +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 desea definir una relación entre las distintas tablas, deberá introducir una <link href=\"text/shared/00/00000005.xhp#primaerschluessel\" name=\"primary key\">llave primaria</link> que identifique claramente un campo de datos de la tabla existente. Para poder acceder a los datos de esta tabla desde otras tablas se puede hacer referencia a dicha llave primaria. Todos los campos de datos que hagan referencia a esta llave primaria se identificarán como llaves externas." +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 "" @@ -3869,8 +3477,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 "Las relaciones existentes se muestran en la ventana de relaciones mediante una línea que conecta la llave primaria y otros campos de llaves. Se puede añadir una relación arrastrando un campo de una tabla y soltándolo sobre el campo de la otra tabla. Para suprimir una relación, selecciónela y pulse 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 "" @@ -3885,8 +3493,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 utiliza $[officename] como interfaz de usuario de una base de datos relacional, $[officename] no almacena las operaciones de creación y borrado de relaciones en una memoria intermedia, sino que las remite directamente a la base de datos 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 "" @@ -11016,6 +10624,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 "Puede pulsar sobre un campo de fecha u hora para arrastrarlo a otra posición dentro de la misma área o editar sus propiedades en la ventana Propiedades." +#: 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" @@ -11277,48 +11037,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 "La ventana Agregar campo se abre automáticamente y muestra los campos de la tabla seleccionada." - -#: rep_main.xhp -msgctxt "" -"rep_main.xhp\n" -"par_id5927304\n" -"help.text" -msgid "To insert fields into the report" -msgstr "Para insertar campos en el 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 ventana Añadir campo permite insertar en el informe los datos de la tabla. Pulse en el icono Añadir campo de la barra de herramientas para abrir la ventana homónima." - -#: 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 "Seleccione los campos uno a uno de la ventana Agregar campo y ubíquelos en el área de detalle del informe como desee. Use los iconos de la barra de herramientas para alinearlos." - -#: 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 posible sobreponer los campos. Si inserta un campo de tabla en el área de Detalle, se insertará también una etiqueta y un cuadro de texto." - -#: 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 "También puede insertar texto que deba repetirse en todas las páginas del informe. Pulse en el icono Campo de etiqueta <image id=\"img_id5605334\" src=\"cmd/sc_label.png\" width=\"0.566cm\" height=\"0.566cm\" localize=\"true\"><alt id=\"alt_id5605334\">Icono</alt></image> y, a continuación, arrastre un rectángulo al área Cabecera de página o Pie de página. Edite la propiedad Etiqueta para mostrar el texto que desee." +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 "" @@ -12029,8 +11749,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 ventana Añadir campo se muestra automáticamente cuando selecciona una tabla en el cuadro Contenido y sale de él. Puede pulsar en el icono Añadir campo de la barra de herramientas, o bien seleccionar <item type=\"menuitem\">Ver ▸ Añadir campo</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 "" |