Data sources in $[officename]

diff --git a/source/text/shared/explorer/database/11000002.xhp b/source/text/shared/explorer/database/11000002.xhp deleted file mode 100644 index c5e91dd6ca..0000000000 --- a/source/text/shared/explorer/database/11000002.xhp +++ /dev/null @@ -1,51 +0,0 @@ - - - - - - - - -Data sources in $[officename] -/text/shared/explorer/database/11000002.xhp - - -Sun Microsystems, Inc. - - - -databases;drag and drop (Base) -mw added "(Base)" -Data sources in $[officename] -

-Selecting the Address Book -

-To select the address book that you want to use, choose Tools - Address Book Source. -

-Opening a Data Source - - -To open the data source view, press CommandCtrl+Shift+F4 in a text, spreadsheet or form document. - - -To view the contents of a database, click the plus sign (+) in front of the name in the data source view. - - - - diff --git a/source/text/shared/explorer/database/11020000.xhp b/source/text/shared/explorer/database/11020000.xhp deleted file mode 100644 index 642783c674..0000000000 --- a/source/text/shared/explorer/database/11020000.xhp +++ /dev/null @@ -1,73 +0,0 @@ - - - - - - - - - - -ODBC -/text/shared/explorer/database/11020000.xhp - - - -

-ODBCstill some Help IDs in this file. Else it can be removed -Specifies the settings for ODBC databases. This includes your user access data, driver settings, and font definitions. -

-User Name -Type the user name for accessing the database. -

-Password required -Prevents an unauthorized user from accessing the database. You only need to enter the password once per session. -

-Driver Settings -Use this text field to enter additional optional driver settings if this is necessary. -

-Character Set -Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database. 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. -

-General -Retrieve generated values -Enables $[officename] support of auto-incremented data fields for the current ODBC or JDBC data source. 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. -Auto-increment statement -Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field. For example, a typical SQL statement to create a data field is: -CREATE TABLE "table1" ("id" INTEGER) -To auto-increment the "id" data field in a MySQL database, change the statement to: -CREATE TABLE "table1" ("id" INTEGER AUTO_INCREMENT) -In other words, enter AUTO_INCREMENT into Auto-increment statement box. -Query of generated values -Enter an SQL statement that returns the last auto-incremented value for the primary key data field. For example: -SELECT LAST_INSERT_D(); -

-Use SQL92 naming constraints -Only allows names that use characters that conform to the SQL92 naming constraints in the data source. All other characters are rejected. Each name must begin with a lower or upper case letter, or an underline ( _ ). The remaining characters can be ASCII letters, underlines, and numbers. -

-Use Catalog for file-based databases -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. - - diff --git a/source/text/shared/explorer/database/11030000.xhp b/source/text/shared/explorer/database/11030000.xhp deleted file mode 100644 index 5b2fc6bc66..0000000000 --- a/source/text/shared/explorer/database/11030000.xhp +++ /dev/null @@ -1,52 +0,0 @@ - - - - - - - - -dBASE -/text/shared/explorer/database/11030000.xhp - - - -

ufi: removed remaining two index entriesmw added "(Base)" to all 4 entries and transferred 2 entries to shared/explorer/database/dabawiz02dbase.xhp -dBASEstill two Help IDs in this file. Else file can be removed -Specify the settings for a dBASE database. -

-To be able to define relations between tables, use JDBC or ODBC from within $[officename]. - -Display inactive records -Displays all the records in a file, including those marked as deleted. If you select this check box, you cannot delete records. -In dBASE format, deleted records remain in the file. -To view any changes that you make to the database, close the connection to the database, and then reconnect the database. -UFI: deleted note about case sensitivity. Should be not other than for all other files. - -Select the code conversion that you want to use to view the database in $[officename]. This does not affect the database. -

- -Indexes -Opens the Indexes dialog, where you can organize the table indexes in the current dBASE database. - - diff --git a/source/text/shared/explorer/database/11030100.xhp b/source/text/shared/explorer/database/11030100.xhp deleted file mode 100644 index 11e6378fd8..0000000000 --- a/source/text/shared/explorer/database/11030100.xhp +++ /dev/null @@ -1,53 +0,0 @@ - - - - - - - - - - -Indexes -/text/shared/explorer/database/11030100.xhp - - - - -Indexes -Lets you organize dBASE database indexes. 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 Indexes tab page. -

-Table -Select the database table that you want to index. -Table Indexes -Lists the current indexes for the selected database table. To remove an index from the list, click the index, and then click the right arrow. -Free Indexes -Lists the available indexes that you can assign to a table. To assign an index to a selected table, click the left arrow icon. The left double arrow assigns all available indexes. -< -Moves the selected index to the Table Indexes list. -<< -Moves all of the free indexes to the Table Indexes list. -> -Moves the selected table indexes to the Free Indexes list. ->> -Moves all of the table indexes to the Free Indexes list. - - diff --git a/source/text/shared/explorer/database/11080000.xhp b/source/text/shared/explorer/database/11080000.xhp deleted file mode 100644 index 51fdbfced8..0000000000 --- a/source/text/shared/explorer/database/11080000.xhp +++ /dev/null @@ -1,57 +0,0 @@ - - - - - - - - - - -Execute SQL statement -/text/shared/explorer/database/11080000.xhp - - - -SQL; executing SQL statements (Base) -databases; administration through SQL (Base) - -Execute SQL statement -Opens a dialog where you can enter an SQL command for administering a database. - -

-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. -To run an SQL query for filtering data in the database, use the Query Design View. -Command to execute -Enter the SQL administration command that you want to run. -For example, for a "Bibliography" data source, you can enter the following SQL command: -SELECT "Address" FROM "biblio" "biblio" -For more information on SQL commands, please consult the documentation that came with the database. -Previous commands -Lists the previously executed SQL commands. To run a command again, click the command, and then click Run. -Status -Displays the results, including errors, of the SQL command that you ran. -Run -Runs the command that you entered in the Command to execute box. -

- - diff --git a/source/text/shared/explorer/database/11090000.xhp b/source/text/shared/explorer/database/11090000.xhp deleted file mode 100644 index 6b21741bfd..0000000000 --- a/source/text/shared/explorer/database/11090000.xhp +++ /dev/null @@ -1,39 +0,0 @@ - - - - - - - - - - -Table Filter -/text/shared/explorer/database/11090000.xhp - - - -

-Table FilterUFI: file remains as a help id container - no browsing

-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. - -Sort Ascendingin View - Sort menu -Sorts the list of table names in ascending order starting at the beginning of the alphabet. - - -- cgit