summaryrefslogtreecommitdiff
path: root/source/text/sdatabase
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2021-05-02 08:49:46 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2021-05-03 15:58:58 +0200
commitf8bb58500148b126c2730977d566e7fa315439b0 (patch)
tree4fd2c7035f99ec5c76461f066743caa29fa0155c /source/text/sdatabase
parent6b24e1b46b633ccbbf65159f858c9a496479e426 (diff)
Refactor more database help files
Change-Id: I1384c2d3d0090ce15fc5088bff4bfdb07fa7cdbf Reviewed-on: https://gerrit.libreoffice.org/c/help/+/114995 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/sdatabase')
-rw-r--r--source/text/sdatabase/11000002.xhp48
-rw-r--r--source/text/sdatabase/11020000.xhp68
-rw-r--r--source/text/sdatabase/11030000.xhp52
-rw-r--r--source/text/sdatabase/11030100.xhp48
-rw-r--r--source/text/sdatabase/11080000.xhp52
-rw-r--r--source/text/sdatabase/11090000.xhp34
6 files changed, 302 insertions, 0 deletions
diff --git a/source/text/sdatabase/11000002.xhp b/source/text/sdatabase/11000002.xhp
new file mode 100644
index 0000000000..43107a4a2f
--- /dev/null
+++ b/source/text/sdatabase/11000002.xhp
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabase11000002xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Data sources in $[officename]</title>
+<filename>/text/sdatabase/05040200.xhp</filename>
+</topic>
+<history>
+<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
+</history>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3155449"><bookmark_value>databases;drag and drop (Base)</bookmark_value>
+</bookmark><comment>mw added "(Base)"</comment>
+<h1 id="hd_id3151299"><link href="text/sdatabase/05040200.xhp" name="Data sources in $[officename]">Data sources in $[officename]</link></h1>
+<section id="address_book">
+<h2 id="hd_id3150616">Selecting the Address Book</h2>
+<embed href="text/shared/guide/data_addressbook.xhp#address_book"/>
+<paragraph role="paragraph" id="par_id3153049" xml-lang="en-US">To select the address book that you want to use, choose <link href="text/shared/01/01110101.xhp" name="Tools - Address Book Source"><emph>Tools - Address Book Source</emph></link>.</paragraph>
+</section>
+<h2 id="hd_id3147275">Opening a Data Source</h2>
+<list type="unordered">
+<listitem>
+<paragraph role="paragraph" id="par_id3154143" xml-lang="en-US">To open the data source view, press <switchinline select="sys"><caseinline select="MAC"><keycode>Command</keycode></caseinline><defaultinline><keycode>Ctrl</keycode></defaultinline></switchinline><keycode>+Shift+F4</keycode> in a text, spreadsheet or form document.</paragraph>
+</listitem>
+<listitem>
+<paragraph role="paragraph" id="par_id3154046" xml-lang="en-US">To view the contents of a database, click the plus sign (+) in front of the name in the data source view.</paragraph>
+</listitem>
+</list>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/11020000.xhp b/source/text/sdatabase/11020000.xhp
new file mode 100644
index 0000000000..8e1f9484b2
--- /dev/null
+++ b/source/text/sdatabase/11020000.xhp
@@ -0,0 +1,68 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabase11020000xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">ODBC</title>
+<filename>/text/sdatabase/11020000.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="odbc">
+<h1 id="hd_id3149031"><link href="text/sdatabase/11020000.xhp" name="ODBC">ODBC</link><comment>still some Help IDs in this file. Else it can be removed</comment></h1>
+<paragraph role="paragraph" id="par_id3150499" xml-lang="en-US"><ahelp hid=".">Specifies the settings for <link href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases. This includes your user access data, driver settings, and font definitions.</ahelp></paragraph>
+</section>
+<section id="username">
+<h2 id="hd_id3148642">User Name</h2>
+<paragraph role="paragraph" id="par_id3154514" xml-lang="en-US"><ahelp hid=".">Type the user name for accessing the database.</ahelp></paragraph>
+</section>
+<section id="password">
+<h2 id="hd_id3153665">Password required</h2>
+<paragraph role="paragraph" id="par_id3145119" xml-lang="en-US"><ahelp hid=".">Prevents an unauthorized user from accessing the database. You only need to enter the password once per session.</ahelp></paragraph>
+</section>
+<section id="driver settings">
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/odbcpage/options" id="bm_id3148473" localize="false"/><h2 id="hd_id3153087">Driver Settings</h2>
+<paragraph role="paragraph" id="par_id3143271" xml-lang="en-US"><ahelp hid="dbaccess/ui/odbcpage/options">Use this text field to enter additional optional driver settings if this is necessary.</ahelp></paragraph>
+</section>
+<section id="character_set">
+<!-- removed HID HID_DSADMIN_CHARSET_ODBC --><h2 id="hd_id3152472">Character Set</h2>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp hid="HID_DSADMIN_CHARSET_ODBC">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp> Choose "System" to use the default character set of your operating system. Text and dBASE databases are restricted to character sets with a fixed-size character length, where all characters are encoded with the same number of bytes.</paragraph>
+</section>
+<section id="retrieve">
+<h2 id="hd_id3149669">General</h2>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/autoretrieve" id="bm_id3161657" localize="false"/><h3 id="hd_id3147265">Retrieve generated values</h3>
+<paragraph role="paragraph" id="par_id3151054" xml-lang="en-US"><ahelp hid="dbaccess/ui/generatedvaluespage/autoretrieve">Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source.</ahelp> Select this check box if the database does not support the auto-increment feature in its SDBCX layer. In general, the auto-increment is selected for the primary key field.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/statement" id="bm_id3150792" localize="false"/><h3 id="hd_id3150400">Auto-increment statement</h3>
+<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US"><ahelp hid="dbaccess/ui/generatedvaluespage/statement">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, a typical SQL statement to create a data field is: </paragraph>
+<paragraph role="paragraph" id="par_id3159149" xml-lang="en-US">CREATE TABLE "table1" ("id" INTEGER)</paragraph>
+<paragraph role="paragraph" id="par_id3147084" xml-lang="en-US">To auto-increment the "id" data field in a MySQL database, change the statement to:</paragraph>
+<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US">CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT)</paragraph>
+<paragraph role="paragraph" id="par_id3152933" xml-lang="en-US">In other words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph> box.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/query" id="bm_id3153195" localize="false"/><h3 id="hd_id3149765">Query of generated values</h3>
+<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"><ahelp hid="dbaccess/ui/generatedvaluespage/query">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:</paragraph>
+<paragraph role="paragraph" id="par_id3150769" xml-lang="en-US">SELECT LAST_INSERT_D();</paragraph>
+</section>
+<section id="sql92">
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/specialsettingspage/usesql92" id="bm_id3147289" localize="false"/><h3 id="hd_id3157892">Use SQL92 naming constraints</h3>
+<paragraph role="paragraph" id="par_id3153368" xml-lang="en-US"><ahelp hid="dbaccess/ui/specialsettingspage/usesql92">Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected.</ahelp> Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers.</paragraph>
+</section>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_USECATALOG" id="bm_id3146148" localize="false"/><h3 id="hd_id3154011">Use Catalog for file-based databases</h3>
+<paragraph role="paragraph" id="par_id3148618" xml-lang="en-US"><ahelp hid="HID_DSADMIN_USECATALOG">Uses the current data source of the Catalog. This is useful when the ODBC data source is a database server. If the ODBC data source is a dBASE driver, leave this check box clear.</ahelp></paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/11030000.xhp b/source/text/sdatabase/11030000.xhp
new file mode 100644
index 0000000000..ab8555a4c3
--- /dev/null
+++ b/source/text/sdatabase/11030000.xhp
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+
+
+<meta>
+<topic id="textsharedexplorerdatabase11030000xml" indexer="exclude">
+<title id="tit" xml-lang="en-US">dBASE</title>
+<filename>/text/sdatabase/11030000.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="dbase"><comment>ufi: removed remaining two index entries</comment><comment>mw added "(Base)" to all 4 entries and transferred 2 entries to shared/explorer/database/dabawiz02dbase.xhp</comment>
+<h1 id="hd_id3153539"><link href="text/sdatabase/11030000.xhp" name="dBase">dBASE</link><comment>still two Help IDs in this file. Else file can be removed</comment></h1>
+<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US"><ahelp hid=".">Specify the settings for a dBASE database.</ahelp></paragraph>
+</section>
+<section id="howtoget">
+<embed href="text/shared/00/00000450.xhp#dBase"/>
+</section>
+<paragraph role="paragraph" id="par_id3151110" xml-lang="en-US">To be able to define relations between tables, use JDBC or ODBC from within $[officename].</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbasepage/showDelRowsCheckbutton" id="bm_id3154142" localize="false"/>
+<h2 id="hd_id3149233">Display inactive records</h2>
+<paragraph role="paragraph" id="par_id3153823" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbasepage/showDelRowsCheckbutton">Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3156023" xml-lang="en-US">In dBASE format, deleted records remain in the file. </paragraph>
+<paragraph role="paragraph" id="par_id3151384" xml-lang="en-US">To view any changes that you make to the database, close the connection to the database, and then reconnect the database.</paragraph>
+<paragraph role="paragraph" id="par_id6051820" xml-lang="en-US" localize="false"><comment>UFI: deleted note about case sensitivity. Should be not other than for all other files.</comment></paragraph>
+<!-- removed HID HID_DSADMIN_CHARSET_DBASE -->
+<paragraph role="paragraph" id="par_id0904200811094971" xml-lang="en-US"><ahelp hid="." visibility="hidden">Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database.</ahelp></paragraph>
+<embed href="text/sdatabase/11020000.xhp#character_set"/>
+<embed href="text/sdatabase/11020000.xhp#sql92"/>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbasepage/indiciesButton" id="bm_id3151056" localize="false"/>
+<h2 id="hd_id3149047">Indexes</h2>
+<paragraph role="paragraph" id="par_id3161656" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbasepage/indiciesButton">Opens the <link href="text/sdatabase/11030100.xhp" name="Indexes"><emph>Indexes</emph></link> dialog, where you can organize the table indexes in the current dBASE database.</ahelp></paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/11030100.xhp b/source/text/sdatabase/11030100.xhp
new file mode 100644
index 0000000000..9eb5a8a73a
--- /dev/null
+++ b/source/text/sdatabase/11030100.xhp
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabase11030100xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Indexes</title>
+<filename>/text/sdatabase/11030100.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/DBaseIndexDialog" id="bm_id3146959" localize="false"/>
+<h1 id="hd_id3148983"><link href="text/sdatabase/11030100.xhp" name="Indexes">Indexes</link></h1>
+<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US"><ahelp hid=".">Lets you organize dBASE database indexes.</ahelp> An index allows you to access a database quickly, provided that you query the data in the selection that was defined through the index. When you design a table, you can define the indexes on the <emph>Indexes </emph>tab page.</paragraph>
+<section id="howtoget">
+ <embed href="text/shared/00/00000450.xhp#dBasein"/>
+</section>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/table" id="bm_id3146958" localize="false"/><h2 id="hd_id3155339">Table</h2>
+<paragraph role="paragraph" id="par_id3152551" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/table">Select the database table that you want to index.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/tableindex" id="bm_id3153312" localize="false"/><h2 id="hd_id3159233">Table Indexes</h2>
+<paragraph role="paragraph" id="par_id3143267" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/tableindex">Lists the current indexes for the selected database table.</ahelp> To remove an index from the list, click the index, and then click the right arrow.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/freeindex" id="bm_id3147276" localize="false"/><h2 id="hd_id3148538">Free Indexes</h2>
+<paragraph role="paragraph" id="par_id3151110" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/freeindex">Lists the available indexes that you can assign to a table.</ahelp> To assign an index to a selected table, click the left arrow icon. The left double arrow assigns all available indexes.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/add" id="bm_id3146949" localize="false"/><h2 id="hd_id3156152">&lt;</h2>
+<paragraph role="paragraph" id="par_id3150984" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/add">Moves the selected index to the <emph>Table Indexes</emph> list.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/addall" id="bm_id3153147" localize="false"/><h2 id="hd_id3149416">&lt;&lt;</h2>
+<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/addall">Moves all of the free indexes to the <emph>Table Indexes</emph> list.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/remove" id="bm_id3147619" localize="false"/><h2 id="hd_id3149579">&gt;</h2>
+<paragraph role="paragraph" id="par_id3149795" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/remove">Moves the selected table indexes to the <emph>Free Indexes</emph> list.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/removeall" id="bm_id3154515" localize="false"/><h2 id="hd_id3155629">&gt;&gt;</h2>
+<paragraph role="paragraph" id="par_id3151245" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbaseindexdialog/removeall">Moves all of the table indexes to the <emph>Free Indexes</emph> list.</ahelp></paragraph>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/11080000.xhp b/source/text/sdatabase/11080000.xhp
new file mode 100644
index 0000000000..c61aebd199
--- /dev/null
+++ b/source/text/sdatabase/11080000.xhp
@@ -0,0 +1,52 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabase11080000xml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Execute SQL statement</title>
+<filename>/text/sdatabase/11080000.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148983"><bookmark_value>SQL; executing SQL statements (Base)</bookmark_value>
+<bookmark_value>databases; administration through SQL (Base)</bookmark_value>
+</bookmark><bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/DirectSQLDialog" id="bm_id3150773" localize="false"/><paragraph role="paragraph" id="par_id3148983" xml-lang="en-US" localize="false"/>
+<h1 id="hd_id3153345"><link href="text/sdatabase/11080000.xhp" name="Execute SQL statement">Execute SQL statement</link></h1>
+<paragraph role="paragraph" id="par_id3154288" xml-lang="en-US"><variable id="sqltext"><ahelp hid=".">Opens a dialog where you can enter an SQL command for administering a database.</ahelp>
+</variable></paragraph>
+<section id="howtoget">
+ <embed href="text/shared/00/00000450.xhp#SQLStatement"/>
+</section>
+<embed href="text/shared/guide/data_enter_sql.xhp#data_enter_sql"/>
+<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US">You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBASE can only run some of the SQL commands list here.</paragraph>
+<note id="par_id3154860">To run an SQL query for filtering data in the database, use the <link href="text/sdatabase/02010100.xhp" name="Query Design">Query Design View</link>.</note>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sql" id="bm_id3150772" localize="false"/><h2 id="hd_id3149514">Command to execute</h2>
+<paragraph role="paragraph" id="par_id3147618" xml-lang="en-US"><ahelp hid="dbaccess/ui/directsqldialog/sql">Enter the SQL administration command that you want to run.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3153087" xml-lang="en-US">For example, for a "Bibliography" data source, you can enter the following SQL command:</paragraph>
+<paragraph role="paragraph" id="par_id3145673" xml-lang="en-US">SELECT "Address" FROM "biblio" "biblio"</paragraph>
+<paragraph role="paragraph" id="par_id3145611" xml-lang="en-US">For more information on SQL commands, please consult the documentation that came with the database.</paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sqlhistory" id="bm_id3154923" localize="false"/><h2 id="hd_id3156024">Previous commands</h2>
+<paragraph role="paragraph" id="par_id3149045" xml-lang="en-US"><ahelp hid="dbaccess/ui/directsqldialog/sqlhistory">Lists the previously executed SQL commands. To run a command again, click the command, and then click <emph>Run</emph>.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/status" id="bm_id3161656" localize="false"/><h2 id="hd_id3154348">Status</h2>
+<paragraph role="paragraph" id="par_id3151054" xml-lang="en-US"><ahelp hid="dbaccess/ui/directsqldialog/status">Displays the results, including errors, of the SQL command that you ran.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/execute" id="bm_id3148798" localize="false"/><h2 id="hd_id3154071">Run</h2>
+<paragraph role="paragraph" id="par_id3151210" xml-lang="en-US"><ahelp hid="dbaccess/ui/directsqldialog/execute">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp></paragraph>
+<embed href="text/shared/00/00000001.xhp#close2"/>
+</body>
+</helpdocument>
diff --git a/source/text/sdatabase/11090000.xhp b/source/text/sdatabase/11090000.xhp
new file mode 100644
index 0000000000..e3b1db5602
--- /dev/null
+++ b/source/text/sdatabase/11090000.xhp
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * except in compliance with the License. You may obtain a copy of
+ * the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ -->
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabase11090000xml" indexer="exclude" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Table Filter</title>
+<filename>/text/sdatabase/11090000.xhp</filename>
+</topic>
+</meta>
+<body>
+<section id="table_filter">
+<h1 id="hd_id3150702"><link href="text/sdatabase/11090000.xhp" name="Tables">Table Filter</link></h1><comment>UFI: file remains as a help id container - no browsing</comment></section>
+<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DSADMIN_SUPPRESS_VERSIONCL" id="bm_id3154046" localize="false"/><paragraph role="paragraph" id="par_id3149164" xml-lang="en-US"><ahelp hid="." visibility="hidden">Some databases track changes to each record by assigning version number to fields that are changed. This number is incremented by 1 each time the field is changed. Displays the internal version number of the record in the database table.</ahelp></paragraph>
+<bookmark xml-lang="en-US" branch="hid/.uno:Sortup" id="bm_id5955967" localize="false"/>
+<h2 id="hd_id3154923">Sort Ascending<comment>in View - Sort menu</comment></h2>
+<paragraph role="paragraph" id="par_id3147559" xml-lang="en-US"><ahelp hid=".">Sorts the list of table names in ascending order starting at the beginning of the alphabet.</ahelp></paragraph>
+</body>
+</helpdocument>
generated by cgit (git 2.34.1) at 2025-02-02 08:59:28 +0000