<!DOCTYPE html>
<html lang="es" dir="ltr">
<head>
<base href="../../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Servicio SFDocuments.Base</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 del módulo elegido" 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="abstract"></a>
<a id="bm_id41582391760252"></a>
<meta itemprop="keywords" content="Base service">
<h1 id="bm_id781582391760253" dir="auto">
<a id="BaseService"></a>Servicio <span class="literal">SFDocuments</span>.<span class="literal">Base</span>
</h1>
<p id="par_id901619031958273" class="paragraph" dir="auto">El servicio <span class="literal">Base</span> proporciona diversos métodos y propiedades que facilitan la gestión y la manipulación de los documentos de LibreOffice Base.</p>
<p id="par_id961619032060880" class="paragraph" dir="auto">Este servicio está estrechamente relacionado con el servicio <span class="literal">Document</span>, que brinda métodos genéricos para manipular documentos de LibreOffice, incluidos los de Base. De ahí que el servicio <span class="literal">Base</span> amplíe <span class="literal">Document</span> y ofrezca métodos adicionales específicos para los documentos de Base, permitiendo a los usuarios:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id241619032289964" class="listitem" dir="auto">Obtener acceso a la base de datos contenida en un documento de Base.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id291619032292829" class="listitem" dir="auto">Abrir los documentos de formulario almacenados en un documento de Base.</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id421619032296454" class="listitem" dir="auto">Comprobar si un formulario de un documento de Base se encuentra cargado.</p>
</li>
</ul>
<div class="tip">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="tip" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id241619032941497" dir="auto">Lea la <a target="_top" href="es/text/sbasic/shared/03/sf_document.html">documentación del servicio <span class="literal">Document</span></a> para aprender más acerca de los métodos y las propiedades que pueden utilizarse para manipular documentos de LibreOffice.</p></div>
</div>
<br>
<h2 id="hd_id581582885621841" dir="auto">Invocación del servicio</h2>
<p id="par_id141609955500101" class="paragraph" dir="auto">Antes de utilizar el servicio <span class="literal">Base</span>, es necesario cargar o importar la biblioteca <span class="literal">ScriptForge</span>:</p>
<div class="embedded">
<a id="importLibs"></a>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id901528999850603" dir="auto">• Para cargar la biblioteca <span class="literal">ScriptForge</span> que necesitan las macros de Basic se debe usar la siguiente declaración:<br><span class="literal">GlobalScope.BasicLibraries.loadLibrary("ScriptForge")</span><br><br>• Los scripts de Python necesitan importar el módulo <span class="literal">scriptforge</span>:<br><span class="literal">from scriptforge import CreateScriptService</span></p></div>
</div>
<br>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<p id="par_id311619033224680" class="paragraph" dir="auto">El servicio Base se puede invocar de varias formas. El fragmento de código siguiente utiliza el método <span class="literal">CreateBaseDocument</span> del servicio <span class="literal">UI</span> para crear un archivo nuevo de Base.</p>
<p id="par_id101619033666470" class="paragraph" dir="auto">Observe que, en todos los ejemplos, el objeto <span class="literal">oDoc</span> es un ejemplar del servicio <span class="literal">Base</span>.</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim ui As Object, oDoc As Object
Set ui = CreateScriptService("UI")
Set oDoc = ui.CreateBaseDocument("C:\Documents\MyFile.odb")
</code></pre></div>
<p id="par_id281619033570656" class="paragraph" dir="auto">The <span class="literal">Base</span> service can also be instantiated while opening an existing Base file, as shown below:</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Set oDoc = ui.OpenBaseDocument("C:\Documents\MyFile.odb")
</code></pre></div>
<p id="par_id331619033713781" class="paragraph" dir="auto">If a Base document is already open, it is possible to instantiate the <span class="literal">Base</span> service directly:</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim oDoc As Object
Set oDoc = CreateScriptService("SFDocuments.Document", "MyFile.odb")
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<p id="par_id871623102536956" class="paragraph" dir="auto">Los ejemplos anteriores pueden expresarse en Python de la siguiente manera:</p>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
from scriptforge import CreateScriptService
ui = CreateScriptService("UI")
doc = ui.CreateBaseDocument(r"C:\Documents\MyFile.odb")
</code></pre></div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc = ui.OpenBaseDocument(r"C:\Documents\MyFile.odb")
</code></pre></div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc = CreateScriptService("SFDocuments.Document", "MyFile.odb")
</code></pre></div>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id281619619980185" dir="auto">El uso de la subcadena <span class="emph">"SFDocuments."</span> en el ejemplo anterior es opcional.</p></div>
</div>
<br>
<a id="methods_toc"></a>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<th rowspan="" colspan="3" class="tableheadcell" dir="auto">
<p id="par_id451619034669263" class="tableheadintable" dir="auto">Lista de métodos en el servicio Base</p>
</th>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_id981619034669263" class="tablecontentintable" dir="auto">
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#CloseFormDocument">CloseFormDocument</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#FormDocuments">FormDocuments</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#Forms">Forms</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#GetDatabase">GetDatabase</a>
</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id721619034669263" class="tablecontentintable" dir="auto">
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#IsLoaded">IsLoaded</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#OpenFormDocument">OpenFormDocument</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#OpenQuery">OpenQuery</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#OpenTable">OpenTable</a>
</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_id711619034669263" class="tablecontentintable" dir="auto">
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#PrintOut">PrintOut</a><br>
<a target="_top" href="es/text/sbasic/shared/03/sf_base.html#SetPrinter">SetPrinter</a><br><br><br>
</p>
</td>
</tr>
</table>
<br>
<a id="CloseFormDocument"></a>
<a id="bm_id341609135528912"></a>
<meta itemprop="keywords" content="Base service,CloseFormDocument">
<h2 id="hd_id61161309632927" dir="auto">CloseFormDocument</h2>
<p id="par_id801916099743199" class="paragraph" dir="auto">Closes the given form document. Returns <span class="literal">True</span> if closure is successful.</p>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id81692554166441" dir="auto">The method <span class="literal">CloseFormDocument</span> is deprecated since LibreOffice 7.6. Although it is still available, it may be removed from the <span class="literal">Base</span> service in a future release. Use the <span class="literal">CloseDocument</span> method from the <span class="literal">FormDocument</span> service instead.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id71613205516650" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.CloseFormDocument(formdocument: str): bool</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id941619079997810" class="paragraph" dir="auto"><span class="emph">formdocument:</span> The name of the <span class="literal">FormDocument</span> to be closed, as a case-sensitive string.</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<p id="par_id351619100723505" class="paragraph" dir="auto">Si los documentos de formulario están organizados en carpetas, es necesario incluir el nombre de la carpeta para especificar el documento de formulario que se abrirá, como se ilustra en los siguientes ejemplos:</p>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
oDoc.CloseFormDocument("Folder1/myFormDocument")
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc.CloseFormDocument('Folder1/myFormDocument')
</code></pre></div>
<a id="FormDocuments"></a>
<a id="bm_id401619035409457"></a>
<meta itemprop="keywords" content="Base service,FormDocuments">
<h2 id="hd_id841619035592745" dir="auto">FormDocuments</h2>
<p id="par_id481619036833610" class="paragraph" dir="auto">Devuelve una matriz con los nombres completos (ruta y nombre) de todos los documentos de formulario en el documento de Base en forma de una matriz de cadenas de base cero.</p>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id401623103182304" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.FormDocuments(): str[0..*]</span>
</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<p id="par_id431619037334440" class="paragraph" dir="auto">El fragmento de código que verá a continuación muestra los nombres de todos los formularios en el documento de Base actual.</p>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim oDoc as Object, myForms as Object, formName as String
Set oDoc = CreateScriptService("Document", ThisDataBaseDocument)
Set myForms = oDoc.FormDocuments()
For Each formName In myForms
MsgBox formName
Next formName
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
bas = CreateScriptService("Basic")
doc = CreateScriptService("Document", bas.ThisDataBaseDocument)
myForms = doc.FormDocuments()
for formName in myForms:
bas.MsgBox(formName)
</code></pre></div>
<div class="tip">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="tip" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id921619036922844" dir="auto">To learn more about form documents, refer to <a target="_top" href="es/text/sbasic/shared/03/sf_formdocument.html"><span class="literal">ScriptForge.FormDocument</span> service</a> help page.</p></div>
</div>
<br>
<a id="Forms"></a>
<a id="bm_id861619035438484"></a>
<meta itemprop="keywords" content="Base service,Forms">
<h2 id="hd_id291619035603979" dir="auto">Forms</h2>
<p id="par_id191619037523467" class="paragraph" dir="auto">En función de los parámetros provistos, este método devolverá:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id781619037575043" class="listitem" dir="auto">A zero-based Array with the names of all the forms contained in a form document (if the <span class="literal">Form</span> argument is absent)</p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id111619037577804" class="listitem" dir="auto">Un objeto <span class="literal">SFDocuments.Form</span> que representa el formulario especificado en el argumento <span class="literal">Form</span>.</p>
</li>
</ul>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id81692554166191" dir="auto">The method <span class="literal">Forms</span> is deprecated since LibreOffice 7.6. Although it is still available, it may be removed from the <span class="literal">Base</span> service in a future release. Use the <span class="literal">Forms</span> method from the <span class="literal">FormDocument</span> service instead.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id851623104561457" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.Forms(formdocument: str): str[0..*]</span>
</p>
<p id="par_id851623104560857" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.Forms(formdocument: str, form: str = ''): svc</span>
</p>
<p id="par_id851623104562213" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.Forms(formdocument: str, form: int): svc</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id861619037838260" class="paragraph" dir="auto"><span class="emph">formdocument:</span> el nombre de un documento de formulario válido, expresado como cadena que distingue mayúsculas y minúsculas.</p>
<p id="par_id281619037857187" class="paragraph" dir="auto"><span class="emph">form:</span> The name or index number of the form stored in the form document. If this argument is absent, the method will return a list with the names of all forms available in the form document.</p>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id921619437863617" dir="auto">Although it is possible to use index numbers to refer to forms, this is only recommended when there is just one form in the form document. If there are two or more forms, it is preferable to use the form name instead.</p></div>
</div>
<br>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<p id="par_id21623104676805" class="paragraph" dir="auto">The first line of the example below returns a list of all forms in the form document "myFormDocument". The second line returns an instance of the Form service representing the form "myForm".</p>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim formsList as Object : formsList = oDoc.Forms("myFormDocument")
Dim oForm as Object : oForm = oDoc.Forms("myFormDocument", "myForm")
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
formsList = doc.Forms("myFormDocument")
form = doc.Forms("myFormDocument", "myForm")
</code></pre></div>
<a id="GetDatabase"></a>
<a id="bm_id301619035470065"></a>
<meta itemprop="keywords" content="Base service,GetDatabase">
<h2 id="hd_id111619035612996" dir="auto">GetDatabase</h2>
<p id="par_id371619098340303" class="paragraph" dir="auto">Returns an instance of the <a target="_top" href="es/text/sbasic/shared/03/sf_database.html"><span class="literal">Database</span> service</a> that allows the execution of SQL commands on the database defined and/or stored in the current Base document</p>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id431623105245851" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.GetDatabase(user: str = '', password: str = ''): svc</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id731619098073221" class="paragraph" dir="auto"><span class="emph">user, password:</span> Optional login parameters as strings. The default value for both parameters is an empty string "".</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim myDoc As Object, myDatabase As Object, ui As Object
Set ui = CreateScriptService("UI")
Set myDoc = ui.OpenBaseDocument("C:\Documents\myDb.odb")
' A continuación se proporcionan el usuario y la contraseña, si hicieran falta
Set myDatabase = myDoc.GetDatabase()
' … Ejecute consultas, instrucciones SQL, etc.
myDatabase.CloseDatabase()
myDoc.CloseDocument()
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
ui = CreateScriptService("UI")
myDoc = ui.OpenBaseDocument(r"C:\Documents\myDb.odb")
myDatabase = myDoc.GetDatabase()
# … Ejecute consultas o instrucciones SQL…
myDatabase.CloseDatabase()
myDoc.CloseDocument()
</code></pre></div>
<a id="IsLoaded"></a>
<a id="bm_id351619035498660"></a>
<meta itemprop="keywords" content="Base service,IsLoaded">
<h2 id="hd_id621619035622085" dir="auto">IsLoaded</h2>
<p id="par_id871619098478513" class="paragraph" dir="auto">Devuelve <span class="literal">True</span> si el <span class="literal">FormDocument</span> especificado está abierto actualmente.</p>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id831623105309694" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.IsLoaded(formdocument: str): bool</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id981619098545701" class="paragraph" dir="auto"><span class="emph">formdocument:</span> el nombre de un <span class="literal">FormDocument</span> que se debe comprobar, expresado como cadena que distingue entre mayúsculas y minúsculas.</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
If Not oDoc.IsLoaded("myFormDocument") Then
oDoc.OpenFormDocument("myFormDocument")
End If
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
if not doc.IsLoaded("myFormDocument"):
doc.OpenFormDocument("myFormDocument")
</code></pre></div>
<a id="OpenFormDocument"></a>
<a id="bm_id341619035528912"></a>
<meta itemprop="keywords" content="Base service,OpenFormDocument">
<h2 id="hd_id611619035632927" dir="auto">OpenFormDocument</h2>
<p id="par_id801619099743199" class="paragraph" dir="auto">Opens the specified <span class="literal">FormDocument</span> either in normal or in design mode. This method returns a <span class="literal">FormDocument</span> service instance corresponding to the specified form document.</p>
<p id="par_id451619100075330" class="paragraph" dir="auto">If the form document is already open, it is activated without changing its mode.</p>
<p id="par_id651692554712005" class="paragraph" dir="auto">If the specified form document does not exist, then <span class="literal">Nothing</span> is returned.</p>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id71623105516650" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.OpenFormDocument(formdocument: str, designmode: bool = False): svc</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id941619099797810" class="paragraph" dir="auto"><span class="emph">formDocument:</span> The name of the <span class="literal">FormDocument</span> to be opened, as a case-sensitive string.</p>
<p id="par_id981619099816849" class="paragraph" dir="auto"><span class="emph">designmode:</span> If this argument is <span class="literal">True</span> the <span class="literal">FormDocument</span> will be opened in design mode.</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<p id="par_id251619100191992" class="paragraph" dir="auto">La mayor parte de los formularios se almacenan en la raíz del documento de Base y pueden abrirse simplemente utilizando sus nombres, como en el ejemplo siguiente:</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
Dim oFormDoc As Object
oFormDoc = oDoc.OpenFormDocument("myFormDocument")
</code></pre></div>
<p id="par_id351619100327505" class="paragraph" dir="auto">Si los documentos de formulario se organizan en carpetas, se vuelve necesario incluir el nombre de la carpeta para especificar el documento que se debe abrir, como se ilustra en el ejemplo siguiente:</p>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
oFormDoc = oDoc.OpenFormDocument("myFolder/myFormDocument")
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
formDoc = doc.OpenFormDocument("myFormDocument")
</code></pre></div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
formDoc = doc.OpenFormDocument("myFolder/myFormDocument")
</code></pre></div>
<a id="OpenQuery"></a>
<a id="bm_id781599490609222"></a>
<meta itemprop="keywords" content="Base Service,OpenQuery">
<h2 id="hd_id80159949060014" dir="auto">OpenQuery</h2>
<p id="par_id31599490604484" class="paragraph" dir="auto">Opens the Data View window of the specified query and returns an instance of the <span class="literal">Datasheet</span> service.</p>
<p id="par_id281671113374329" class="paragraph" dir="auto">La consulta puede abrirse tanto en modo normal como en modo de diseño.</p>
<p id="par_id801671111609985" class="paragraph" dir="auto">If the query is already open, its Data View window will be made active.</p>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id521671113436716" dir="auto">Closing the Base document will cause the Data View window to be closed as well.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id421625701780171" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.OpenQuery(queryname: str, designmode: bool = False): obj</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id701599490609511" class="paragraph" dir="auto"><span class="emph">queryname</span>: The name of an existing query as a case-sensitive String.</p>
<p id="par_id461671113939669" class="paragraph" dir="auto"><span class="emph">designmode</span>: If this argument is set to <span class="literal">True</span> the query is opened in design mode. Otherwise it is opened in normal mode (Default = <span class="literal">False</span>).</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
oDoc.OpenQuery("MyQuery", DesignMode := True)
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc.OpenQuery("MyQuery", designmode=True)
</code></pre></div>
<a id="OpenTable"></a>
<a id="bm_id78159949060145"></a>
<meta itemprop="keywords" content="Base Service,OpenTable">
<h2 id="hd_id80159949063922" dir="auto">OpenTable</h2>
<p id="par_id31599490604787" class="paragraph" dir="auto">Opens the Data View window of the specified table and returns an instance of the <span class="literal">Datasheet</span> service.</p>
<p id="par_id281671113374441" class="paragraph" dir="auto">The table can be opened either in normal or design mode.</p>
<p id="par_id801671111609395" class="paragraph" dir="auto">If the table is already open, its Data View window will be made active.</p>
<div class="note">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/note.svg" alt="note" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id521671113436658" dir="auto">Closing the Base document will cause the Data View window to be closed as well.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id421625701751251" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.OpenTable(tablename: str, designmode: bool = False): obj</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id701599490609099" class="paragraph" dir="auto"><span class="emph">tablename</span>: The name of an existing table as a case-sensitive String.</p>
<p id="par_id461671113939471" class="paragraph" dir="auto"><span class="emph">designmode</span>: If this argument is set to <span class="literal">True</span> the table is opened in design mode. Otherwise it is opened in normal mode (Default = <span class="literal">False</span>).</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
oDoc.OpenTable("MyTable", DesignMode = False)
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc.OpenTable("MyTable", designmode=False)
</code></pre></div>
<a id="PrintOut"></a>
<a id="bm_id721985200121249"></a>
<meta itemprop="keywords" content="Base service,PrintOut">
<h2 id="hd_id261589202101415" dir="auto">PrintOut</h2>
<p id="par_id156589200121138" class="paragraph" dir="auto">This method sends the content of the given form document to a default printer or a printer defined by the <span class="literal">SetPrinter()</span> method.</p>
<p id="par_id981611169416934" class="paragraph" dir="auto">Returns <span class="literal">True</span> if the document was successfully printed.</p>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id81692554166367" dir="auto">The method <span class="literal">PrintOut</span> is deprecated since LibreOffice 7.6. Although it is still available, it may be removed from the <span class="literal">Base</span> service in a future release. Use the <span class="literal">PrintOut</span> method from the <span class="literal">FormDocument</span> service instead.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id1001622827822169" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.PrintOut(opt formdocument: str, pages: str = "", copies: num = 1): bool</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id368519200121646" class="paragraph" dir="auto"><span class="emph">formdocument</span>: A valid document form name as a case-sensitive string. The form document must be open. It is activated by the method.</p>
<p id="par_id211635436910093" class="paragraph" dir="auto"><span class="emph">pages</span>: The pages to print as a string, like in the user interface. Example: "1-4;10;15-18". Default is all pages.</p>
<p id="par_id141635436912146" class="paragraph" dir="auto"><span class="emph">copies</span>: The number of copies. Default is 1.</p>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
If oDoc.PrintOut("myForm", "1-4;10;15-18", Copies := 2) Then
' ...
End If
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
if doc.PrintOut('myForm', copies=3, pages='45-88'):
# ...
</code></pre></div>
<a id="SetPrinter"></a>
<a id="bm_id71158921504765"></a>
<meta itemprop="keywords" content="Base service,SetPrinter">
<h2 id="hd_id811589502147824" dir="auto">SetPrinter</h2>
<p id="par_id911298505147502" class="paragraph" dir="auto">Define the printer options for a form document. The form document must be open.</p>
<p id="par_id381651114800685" class="paragraph" dir="auto">Returns <span class="literal">True</span> when successful.</p>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id81692554166449" dir="auto">The method <span class="literal">SetPrinter</span> is deprecated since LibreOffice 7.6. Although it is still available, it may be removed from the <span class="literal">Base</span> service in a future release. Use the <span class="literal">SetPrinter</span> method from the <span class="literal">Document</span> service instead.</p></div>
</div>
<br>
<div class="embedded">
<a id="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Sintaxis:</h3>
</div>
<p id="par_id261652828596855" class="paragraph" dir="auto">
<span class="input" data-tooltip="Pulse en el texto para copiarlo en el portapapeles">svc.SetPrinter(opt formdocument: str, opt printer: str, opt orientation: str, paperformat: str): bool</span>
</p>
<div class="embedded">
<a id="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parámetros:</h3>
</div>
<p id="par_id961635950394507" class="paragraph" dir="auto"><span class="emph">formdocument</span>: A valid document form name as a case-sensitive string.</p>
<div class="embedded">
<a id="setPrinterArgs"></a>
<p id="par_id301589205741697" class="paragraph" dir="auto"><span class="emph">printer</span>: The name of the printer queue where to print to. When absent, the default printer is set.</p>
<p id="par_id851985205147348" class="paragraph" dir="auto"><span class="emph">orientation</span>: Either <span class="literal">PORTRAIT</span> or <span class="literal">LANDSCAPE</span>. When absent, left unchanged with respect to the printer settings.</p>
<p id="par_id821985205147330" class="paragraph" dir="auto"><span class="emph">paperformat</span>: Specifies the paper format as a string value that can be either <span class="literal">A3</span>, <span class="literal">A4</span>, <span class="literal">A5</span>, <span class="literal">LETTER</span>, <span class="literal">LEGAL</span> or <span class="literal">TABLOID</span>. Left unchanged when absent.</p>
</div>
<div class="embedded">
<a id="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Ejemplo:</h3>
</div>
<div class="embedded">
<a id="In_Basic"></a>
<h5 id="hd_id191620312698501" dir="auto">En BASIC</h5>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-visual-basic line-numbers">
oDoc.SetPrinter("myForm", Orientation := "PORTRAIT")
</code></pre></div>
<div class="embedded">
<a id="In_Python"></a>
<h5 id="hd_id831620312769993" dir="auto">En Python</h5>
</div>
<div class="pycode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Pulse en el texto para copiarlo en el portapapeles"><pre dir="auto"><code class="language-python line-numbers">
doc.SetPrinter('myForm', paperformat='TABLOID')
</code></pre></div>
<div class="embedded">
<a id="SF_InternalUse"></a>
<div class="warning">
<div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/warning.svg" alt="warning" style="width:40px;height:40px;"></div>
<div class="notetext"><p id="par_id851506659675843" dir="auto">Todas las rutinas o identificadores BASIC de <span class="literal">ScriptForge</span> precedidas por guion bajo «_» están reservadas para uso interno. No deben utilizarse en macros BASIC o secuencias Python.</p></div>
</div>
<br>
</div>
<a id="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions" dir="auto"><a id="related"></a><span class="emph">Temas relacionados</span></p>
<div class="relatedbody" itemprop="mentions">
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/sbasic/shared/03/sf_database.html"><span class="literal">SFDatabases</span>.<span class="literal">Database</span> service</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/sbasic/shared/03/sf_document.html">Servicio <span class="literal">SFDocuments</span>.<span class="literal">Document</span></a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/sbasic/shared/03/sf_form.html"><span class="literal">SFDocuments</span>.<span class="literal">Form</span> service</a></p></div>
<div class="embedded"><p class="embedded" dir="auto"><a target="_top" href="es/text/sbasic/shared/03/sf_ui.html">Servicio <span class="literal">ScriptForge</span>.<span class="literal">UI</span></a></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/sbasic/shared/03/sf_base.xhp" target="_blank">/text/sbasic/shared/03/sf_base.xhp</a></p>
<p dir="auto">Title is: Servicio SFDocuments.Base</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>