diff options
| -rw-r--r-- | AllLangHelp_sdatabase.mk | 6 | ||||
| -rw-r--r-- | AllLangHelp_shared.mk | 6 | ||||
| -rw-r--r-- | source/text/sdatabase/11000002.xhp (renamed from source/text/shared/explorer/database/11000002.xhp) | 11 | ||||
| -rw-r--r-- | source/text/sdatabase/11020000.xhp (renamed from source/text/shared/explorer/database/11020000.xhp) | 31 | ||||
| -rw-r--r-- | source/text/sdatabase/11030000.xhp (renamed from source/text/shared/explorer/database/11030000.xhp) | 20 | ||||
| -rw-r--r-- | source/text/sdatabase/11030100.xhp (renamed from source/text/shared/explorer/database/11030100.xhp) | 25 | ||||
| -rw-r--r-- | source/text/sdatabase/11080000.xhp (renamed from source/text/shared/explorer/database/11080000.xhp) | 21 | ||||
| -rw-r--r-- | source/text/sdatabase/11090000.xhp (renamed from source/text/shared/explorer/database/11090000.xhp) | 13 | ||||
| -rw-r--r-- | source/text/shared/02/12010000.xhp | 2 |
9 files changed, 56 insertions, 79 deletions
diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index a1899d7fdc..b2723e0c47 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -39,6 +39,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/05040100 \ helpcontent2/source/text/sdatabase/05040200 \ helpcontent2/source/text/sdatabase/toolbars \ + helpcontent2/source/text/sdatabase/11000002 \ + helpcontent2/source/text/sdatabase/11020000 \ + helpcontent2/source/text/sdatabase/11030000 \ + helpcontent2/source/text/sdatabase/11030100 \ + helpcontent2/source/text/sdatabase/11080000 \ + helpcontent2/source/text/sdatabase/11090000 \ )) # vim: set noet sw=4 ts=4: diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index 5ffdc9d926..65feeac783 100644 --- a/AllLangHelp_shared.mk +++ b/AllLangHelp_shared.mk @@ -861,12 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ )) $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ - helpcontent2/source/text/shared/explorer/database/11000002 \ - helpcontent2/source/text/shared/explorer/database/11020000 \ - helpcontent2/source/text/shared/explorer/database/11030000 \ - helpcontent2/source/text/shared/explorer/database/11030100 \ - helpcontent2/source/text/shared/explorer/database/11080000 \ - helpcontent2/source/text/shared/explorer/database/11090000 \ helpcontent2/source/text/shared/explorer/database/dabaadvprop \ helpcontent2/source/text/shared/explorer/database/dabaadvpropdat \ helpcontent2/source/text/shared/explorer/database/dabaadvpropgen \ diff --git a/source/text/shared/explorer/database/11000002.xhp b/source/text/sdatabase/11000002.xhp index c5e91dd6ca..43107a4a2f 100644 --- a/source/text/shared/explorer/database/11000002.xhp +++ b/source/text/sdatabase/11000002.xhp @@ -1,6 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - <!-- * This file is part of the LibreOffice project. * @@ -18,12 +16,11 @@ * 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/shared/explorer/database/11000002.xhp</filename> +<filename>/text/sdatabase/05040200.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> @@ -32,13 +29,13 @@ <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> -<paragraph role="heading" id="hd_id3151299" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11000002.xhp" name="Data sources in $[officename]">Data sources in $[officename]</link></paragraph> +<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"> -<paragraph role="heading" id="hd_id3150616" xml-lang="en-US" level="2">Selecting the Address Book</paragraph> +<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> -<paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2">Opening a Data Source</paragraph> +<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> diff --git a/source/text/shared/explorer/database/11020000.xhp b/source/text/sdatabase/11020000.xhp index 642783c674..8e1f9484b2 100644 --- a/source/text/shared/explorer/database/11020000.xhp +++ b/source/text/sdatabase/11020000.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,55 +16,53 @@ * 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"> +<helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase11020000xml" indexer="exclude" status="PUBLISH"> <title id="tit" xml-lang="en-US">ODBC</title> -<filename>/text/shared/explorer/database/11020000.xhp</filename> +<filename>/text/sdatabase/11020000.xhp</filename> </topic> </meta> <body> <section id="odbc"> -<paragraph role="heading" id="hd_id3149031" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11020000.xhp" name="ODBC">ODBC</link><comment>still some Help IDs in this file. Else it can be removed</comment></paragraph> +<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"> -<paragraph role="heading" id="hd_id3148642" xml-lang="en-US" level="2">User Name</paragraph> +<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"> -<paragraph role="heading" id="hd_id3153665" xml-lang="en-US" level="2">Password required</paragraph> +<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"/><paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="2">Driver Settings</paragraph> +<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 --><paragraph role="heading" id="hd_id3152472" xml-lang="en-US" level="2">Character Set</paragraph> +<!-- 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"> -<paragraph role="heading" id="hd_id3149669" xml-lang="en-US" level="2">General</paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/generatedvaluespage/autoretrieve" id="bm_id3161657" localize="false"/><paragraph role="heading" id="hd_id3147265" xml-lang="en-US" level="3">Retrieve generated values</paragraph> +<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"/><paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="3">Auto-increment statement</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"/><paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3">Query of generated values</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"/><paragraph role="heading" id="hd_id3157892" xml-lang="en-US" level="3">Use SQL92 naming constraints</paragraph> +<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"/><paragraph role="heading" id="hd_id3154011" xml-lang="en-US" level="3">Use Catalog for file-based databases</paragraph> +<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/shared/explorer/database/11030000.xhp b/source/text/sdatabase/11030000.xhp index 5b2fc6bc66..ab8555a4c3 100644 --- a/source/text/shared/explorer/database/11030000.xhp +++ b/source/text/sdatabase/11030000.xhp @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- * This file is part of the LibreOffice project. * @@ -18,17 +18,17 @@ * 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/shared/explorer/database/11030000.xhp</filename> +<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> -<paragraph role="heading" id="hd_id3153539" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11030000.xhp" name="dBase">dBASE</link><comment>still two Help IDs in this file. Else file can be removed</comment></paragraph> +<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"> @@ -36,17 +36,17 @@ </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"/> -<paragraph role="heading" id="hd_id3149233" xml-lang="en-US" level="2">Display inactive records</paragraph> +<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/shared/explorer/database/11020000.xhp#character_set"/> -<embed href="text/shared/explorer/database/11020000.xhp#sql92"/> +<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"/> -<paragraph role="heading" id="hd_id3149047" xml-lang="en-US" level="2">Indexes</paragraph> -<paragraph role="paragraph" id="par_id3161656" xml-lang="en-US"><ahelp hid="dbaccess/ui/dbasepage/indiciesButton">Opens the <link href="text/shared/explorer/database/11030100.xhp" name="Indexes"><emph>Indexes</emph></link> dialog, where you can organize the table indexes in the current dBASE database.</ahelp></paragraph> +<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/shared/explorer/database/11030100.xhp b/source/text/sdatabase/11030100.xhp index 11e6378fd8..9eb5a8a73a 100644 --- a/source/text/shared/explorer/database/11030100.xhp +++ b/source/text/sdatabase/11030100.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,35 +16,33 @@ * 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"> +<helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase11030100xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Indexes</title> -<filename>/text/shared/explorer/database/11030100.xhp</filename> +<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"/> -<paragraph role="heading" id="hd_id3148983" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11030100.xhp" name="Indexes">Indexes</link></paragraph> +<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"/><paragraph role="heading" id="hd_id3155339" xml-lang="en-US" level="2">Table</paragraph> +<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"/><paragraph role="heading" id="hd_id3159233" xml-lang="en-US" level="2">Table Indexes</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"/><paragraph role="heading" id="hd_id3148538" xml-lang="en-US" level="2">Free Indexes</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"/><paragraph role="heading" id="hd_id3156152" xml-lang="en-US" level="2"><</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/add" id="bm_id3146949" localize="false"/><h2 id="hd_id3156152"><</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"/><paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="2"><<</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/addall" id="bm_id3153147" localize="false"/><h2 id="hd_id3149416"><<</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"/><paragraph role="heading" id="hd_id3149579" xml-lang="en-US" level="2">></paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/remove" id="bm_id3147619" localize="false"/><h2 id="hd_id3149579">></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"/><paragraph role="heading" id="hd_id3155629" xml-lang="en-US" level="2">>></paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/dbaseindexdialog/removeall" id="bm_id3154515" localize="false"/><h2 id="hd_id3155629">>></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/shared/explorer/database/11080000.xhp b/source/text/sdatabase/11080000.xhp index 51fdbfced8..c61aebd199 100644 --- a/source/text/shared/explorer/database/11080000.xhp +++ b/source/text/sdatabase/11080000.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,20 +16,18 @@ * 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"> +<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/shared/explorer/database/11080000.xhp</filename> +<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"/> -<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11080000.xhp" name="Execute SQL statement">Execute SQL statement</link></paragraph> +<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"> @@ -40,17 +35,17 @@ </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> -<paragraph role="note" id="par_id3154860" xml-lang="en-US">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>.</paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/directsqldialog/sql" id="bm_id3150772" localize="false"/><paragraph role="heading" id="hd_id3149514" xml-lang="en-US" level="2">Command to execute</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"/><paragraph role="heading" id="hd_id3156024" xml-lang="en-US" level="2">Previous commands</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"/><paragraph role="heading" id="hd_id3154348" xml-lang="en-US" level="2">Status</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"/><paragraph role="heading" id="hd_id3154071" xml-lang="en-US" level="2">Run</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> diff --git a/source/text/shared/explorer/database/11090000.xhp b/source/text/sdatabase/11090000.xhp index 6b21741bfd..e3b1db5602 100644 --- a/source/text/shared/explorer/database/11090000.xhp +++ b/source/text/sdatabase/11090000.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,21 +16,19 @@ * 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"> +<helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase11090000xml" indexer="exclude" status="PUBLISH"> <title id="tit" xml-lang="en-US">Table Filter</title> -<filename>/text/shared/explorer/database/11090000.xhp</filename> +<filename>/text/sdatabase/11090000.xhp</filename> </topic> </meta> <body> <section id="table_filter"> -<paragraph role="heading" id="hd_id3150702" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/11090000.xhp" name="Tables">Table Filter</link></paragraph><comment>UFI: file remains as a help id container - no browsing</comment></section> +<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"/> -<paragraph role="heading" id="hd_id3154923" xml-lang="en-US" level="2">Sort Ascending<comment>in View - Sort menu</comment></paragraph> +<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> diff --git a/source/text/shared/02/12010000.xhp b/source/text/shared/02/12010000.xhp index a6b02a075a..d2f0454296 100644 --- a/source/text/shared/02/12010000.xhp +++ b/source/text/shared/02/12010000.xhp @@ -26,7 +26,7 @@ <body> <section id="sortascending"> <h1 id="hd_id3152594"><link href="text/shared/02/12010000.xhp" name="Sort Ascending">Sort Ascending</link></h1> -<paragraph role="paragraph" id="par_id3150693" xml-lang="en-US"><ahelp hid="." visibility="hidden">Sorts the data of the selected field in ascending order. </ahelp>Text fields are sorted alphabetically, numerical fields are sorted by number.<comment>UFI: Help ID .uno:Sortup is found in text/shared/explorer/database/11090000.xhp so I deleted it here</comment></paragraph> +<paragraph role="paragraph" id="par_id3150693" xml-lang="en-US"><ahelp hid="." visibility="hidden">Sorts the data of the selected field in ascending order. </ahelp>Text fields are sorted alphabetically, numerical fields are sorted by number.<comment>UFI: Help ID .uno:Sortup is found in text/sdatabase/11090000.xhp so I deleted it here</comment></paragraph> </section> <section id="howtoget"> <switch select="appl"><case select="CALC"> |