__ __ __ __ _____ _ _ _____ _ _ _ | \/ | \ \ / / | __ \ (_) | | / ____| | | | | | \ / |_ __\ V / | |__) | __ ___ ____ _| |_ ___ | (___ | |__ ___| | | | |\/| | '__|> < | ___/ '__| \ \ / / _` | __/ _ \ \___ \| '_ \ / _ \ | | | | | | |_ / . \ | | | | | |\ V / (_| | || __/ ____) | | | | __/ | | |_| |_|_(_)_/ \_\ |_| |_| |_| \_/ \__,_|\__\___| |_____/|_| |_|\___V 2.1 if you need WebShell for Seo everyday contact me on Telegram Telegram Address : @jackleetFor_More_Tools:
<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Barra Diseño de consulta</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="es/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="es/bookmarks.js" defer></script><script type="text/javascript" src="es/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="es/text/shared/05/new_help.html"><div></div></a><a class="logo" href="es/text/shared/05/new_help.html"><p dir="auto">Ayuda de LibreOffice 25.2</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Módulo</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contenido</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Buscar en los marcadores de todos los módulos" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<noscript><div id="WarnJS"><h1 dir="auto">Active JavaScript en el navegador para mostrar las páginas de ayuda de LibreOffice.</h1></div></noscript>
<a id="sql"></a>
<h1 id="hd_id3159176" dir="auto">Barra Diseño de consulta</h1>
<p id="par_id3150085" class="paragraph" dir="auto"><span class="avis">Al crear o editar una consulta SQL, utilice los iconos de la barra <span class="emph">Diseño de consultas</span> para controlar la visualización de datos.</span></p>
<p id="par_id3150276" class="paragraph" dir="auto">Según haya creado la consulta o vista en la pestaña <span class="emph">Diseño</span> o en <span class="emph">SQL</span> se mostrarán los símbolos siguientes:</p>
<div class="embedded">
<a id="run_query"></a>
<h2 id="hd_id3156183" dir="auto"><a target="_top" href="es/text/shared/02/14010000.html">Ejecutar</a></h2>
<p id="par_id3109850" class="paragraph" dir="auto"><span class="avis">Ejecuta la consulta SQL y muestra su resultado.</span> La función <span class="emph">Ejecutar</span> no guarda la consulta.</p>
</div>
<div class="embedded">
<a id="syrun_query"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3155941" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_sbaexecutesql.svg" class="iconimage" alt="Run Query Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3153684" class="paragraphintable" dir="auto">Ejecutar</p>
</div>
</div>
</div>
<div class="embedded">
<a id="clear_query"></a>
<h2 id="hd_id3146946" dir="auto"><a target="_top" href="es/text/shared/02/14020000.html">Borrar consulta</a></h2>
<p id="par_id3155934" class="paragraph" dir="auto"><span class="avis">Borra la consulta y quita todas las tablas de la ventana de diseño.</span></p>
</div>
<div class="embedded">
<a id="syclear_query"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3154422" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbclearquery.svg" class="iconimage" alt="Clear Query Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3150789" class="paragraphintable" dir="auto">Borrar la consulta</p>
</div>
</div>
</div>
<div class="embedded">
<a id="design_view"></a>
<h2 id="hd_id3159411" dir="auto"><a target="_top" href="es/text/shared/02/14020200.html">Switch Design View On/Off</a></h2>
<p id="par_id3149495" class="paragraph" dir="auto"><span class="avis">Muestra la vista de Diseño o SQL de la consulta.</span></p>
</div>
<div class="embedded">
<a id="sydesign_view"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3149140" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbchangedesignmode.svg" class="iconimage" alt=" Switch Design View On/Off Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3147399" class="paragraphintable" dir="auto">Switch Design View On/Off</p>
</div>
</div>
</div>
<h2 id="hd_id3151384" dir="auto"><a target="_top" href="es/text/shared/02/14020100.html">Agregar tablas</a></h2>
<div class="embedded"><p class="embedded" dir="auto">Specifies the tables to be inserted into the design window. In the <span class="emph">Add Tables</span> dialog, select the tables you need for your current task.</p></div>
<div class="embedded">
<a id="syinsert_table"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3151245" class="paragraphintable" dir="auto"> <img src="media/icon-themes/cmd/sc_dbnewtable.svg" class="iconimage" alt="Icono Añadir tabla" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3153896" class="paragraphintable" dir="auto">Insertar tablas</p>
</div>
</div>
</div>
<div class="embedded">
<a id="functions"></a>
<h2 id="hd_id3153514" dir="auto"><a target="_top" href="es/text/shared/02/14040000.html">Funciones</a></h2>
<p id="par_id3159224" class="paragraph" dir="auto"><span class="avis">Displays the <span class="emph">Function</span> row in the lower part of the design view of the <a target="_top" href="es/text/sdatabase/02010100.html"><span class="emph">Query Design</span></a> window.</span></p>
</div>
<div class="embedded">
<a id="syfunctions"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3149205" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbviewfunctions.svg" class="iconimage" alt="Functions Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3145669" class="paragraphintable" dir="auto">Funciones</p>
</div>
</div>
</div>
<div class="embedded">
<a id="table_name"></a>
<h2 id="hd_id3149991" dir="auto"><a target="_top" href="es/text/shared/02/14050000.html">Nombre de la tabla</a></h2>
<p id="par_id3154232" class="paragraph" dir="auto"><span class="avis">Displays the <span class="emph">Table</span> row in the lower part of the <a target="_top" href="es/text/sdatabase/02010100.html"><span class="emph">Query Design</span></a>.</span></p>
</div>
<div class="embedded">
<a id="sytable_name"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3154116" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbviewtablenames.svg" class="iconimage" alt="Table Name Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3157896" class="paragraphintable" dir="auto">Nombre de la tabla</p>
</div>
</div>
</div>
<div class="embedded">
<a id="aliasname"></a>
<h2 id="hd_id3150758" dir="auto"><a target="_top" href="es/text/shared/02/14060000.html">Alias</a></h2>
<p id="par_id3148731" class="paragraph" dir="auto"><span class="avis">Displays the <span class="emph">Alias</span> row in the lower part of the <a target="_top" href="es/text/sdatabase/02010100.html"><span class="emph">Query Design</span></a>.</span></p>
</div>
<div class="embedded">
<a id="syaliasname"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3150808" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbviewaliases.svg" class="iconimage" alt="Alias Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3151234" class="paragraphintable" dir="auto">Alias</p>
</div>
</div>
</div>
<div class="embedded">
<a id="distinct_values"></a>
<h2 id="hd_id3149991" dir="auto"><a target="_top" href="es/text/shared/02/14070000.html">Valores unívocos</a></h2>
<p id="par_id3154894" class="paragraph" dir="auto"><span class="avis">Expands the created select statement of the <a target="_top" href="es/text/sdatabase/02010100.html"><span class="emph">SQL Query</span></a> in the current column by the parameter <span class="emph">DISTINCT</span>.</span> The consequence is that identical values occurring multiple times are listed only once.</p>
</div>
<div class="embedded">
<a id="sydistinct_values"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3149511" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_dbdistinctvalues.svg" class="iconimage" alt="Distinct Values Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3147226" class="paragraphintable" dir="auto">Valores distintos</p>
</div>
</div>
</div>
<p id="par_id3151041" class="paragraph" dir="auto">En la pestaña <span class="emph">SQL</span> verá el icono siguiente:</p>
<div class="embedded">
<a id="native"></a>
<p id="par_id3149748" class="paragraph" dir="auto"></p>
<h2 id="hd_id3151100" dir="auto"><a target="_top" href="es/text/shared/02/14030000.html">Ejecutar orden SQL directamente</a></h2>
<p id="par_id3155364" class="paragraph" dir="auto"><span class="avis">En el modo <span class="emph">SQL nativo</span> es posible introducir órdenes de SQL que LibreOffice no interpreta, mas transmite directamente al origen de datos.</span> Si no muestra estos cambios en la vista de diseño, no será posible cambiar de vuelta a la vista de diseño.</p>
</div>
<div class="embedded">
<a id="synative"></a>
<div class="icontable">
<div class="iconcell">
<p id="par_id3145136" class="paragraphintable" dir="auto"><img src="media/icon-themes/cmd/sc_sbanativesql.svg" class="iconimage" alt="Run SQL command directly Icon" style="width:38px;height:38px" itemprop="icon" itemscope="true" itemtype="http://schema.org/ImageObject"></p>
</div>
<div class="iconcell">
<p id="par_id3155893" class="paragraphintable" dir="auto">Ejecutar orden SQL directamente</p>
</div>
</div>
</div>
</div>
<div id="DonationFrame"></div>
<footer><h2 style="text-align: center;"><a href="https://books.libreoffice.org" target="_blank">Libros de LibreOffice</a></h2>
<div class="noteicon" dir="auto" style="display:flex;justify-content:center;flex-wrap:wrap;row-gap:15px;">
<img src="media/navigation/libo-writer.svg" alt="Writer Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-calc.svg" alt="Calc Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-impress.svg" alt="Impress Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-draw.svg" alt="Draw Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-base.svg" alt="Base Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-math.svg" alt="Math Icon" style="width:60px;height:60px;"><img src="media/navigation/libo-symbol-black.svg" alt="Getting Started Icon" style="width:60px;height:60px;">
</div>
<div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/shared/main0214.xhp" target="_blank">/text/shared/main0214.xhp</a></p>
<p dir="auto">Title is: Barra Diseño de consulta</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| 00 | Folder | 0755 |
|
|
| 01 | Folder | 0755 |
|
|
| 02 | Folder | 0755 |
|
|
| 04 | Folder | 0755 |
|
|
| 05 | Folder | 0755 |
|
|
| 06 | Folder | 0755 |
|
|
| 07 | Folder | 0755 |
|
|
| autokorr | Folder | 0755 |
|
|
| autopi | Folder | 0755 |
|
|
| guide | Folder | 0755 |
|
|
| help | Folder | 0755 |
|
|
| menu | Folder | 0755 |
|
|
| optionen | Folder | 0755 |
|
|
| main0103.html | File | 44.35 KB | 0644 |
|
| main0104.html | File | 36.92 KB | 0644 |
|
| main0107.html | File | 5.49 KB | 0644 |
|
| main0108.html | File | 12.35 KB | 0644 |
|
| main0201.html | File | 46.21 KB | 0644 |
|
| main0204.html | File | 19.58 KB | 0644 |
|
| main0208.html | File | 5.95 KB | 0644 |
|
| main0212.html | File | 19.6 KB | 0644 |
|
| main0213.html | File | 23 KB | 0644 |
|
| main0214.html | File | 12.6 KB | 0644 |
|
| main0226.html | File | 21.65 KB | 0644 |
|
| main0227.html | File | 15.9 KB | 0644 |
|
| main0400.html | File | 13.14 KB | 0644 |
|
| main0500.html | File | 4.81 KB | 0644 |
|
| main0650.html | File | 7.2 KB | 0644 |
|
| main0800.html | File | 4.34 KB | 0644 |
|
| main_tools.html | File | 24.53 KB | 0644 |
|
| need_help.html | File | 4.28 KB | 0644 |
|