summaryrefslogtreecommitdiff
path: root/source/zh-TW/helpcontent2/source/text/sdatabase.po
diff options
context:
space:
mode:
Diffstat (limited to 'source/zh-TW/helpcontent2/source/text/sdatabase.po')
-rw-r--r--source/zh-TW/helpcontent2/source/text/sdatabase.po1625
1 files changed, 1618 insertions, 7 deletions
diff --git a/source/zh-TW/helpcontent2/source/text/sdatabase.po b/source/zh-TW/helpcontent2/source/text/sdatabase.po
index db3264362c9..fcb0f0e14b7 100644
--- a/source/zh-TW/helpcontent2/source/text/sdatabase.po
+++ b/source/zh-TW/helpcontent2/source/text/sdatabase.po
@@ -3,7 +3,7 @@ msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n"
-"POT-Creation-Date: 2021-03-29 16:02+0200\n"
+"POT-Creation-Date: 2021-06-11 17:09+0200\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <LL@li.org>\n"
@@ -3505,13 +3505,13 @@ msgctxt ""
msgid "Format example"
msgstr ""
-#. V3i6o
+#. CrqiQ
#: 05010000.xhp
msgctxt ""
"05010000.xhp\n"
"par_id3155131\n"
"help.text"
-msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays the format code to assign to the field value that you can select with the <emph>Format Field</emph> button.</ahelp>"
+msgid "<ahelp hid=\"HID_TAB_ENT_FORMAT_SAMPLE\">Displays a sample of the format code of the field by applying it to the default value. Select the format code with the <emph>Format Field</emph> button.</ahelp>"
msgstr ""
#. A2jGQ
@@ -4009,22 +4009,22 @@ msgctxt ""
msgid "The update and delete options are only available if they are supported by the database used."
msgstr ""
-#. BDC5P
+#. gdhcZ
#: 05020100.xhp
msgctxt ""
"05020100.xhp\n"
"hd_id3155341\n"
"help.text"
-msgid "Tables"
+msgid "Tables involved"
msgstr ""
-#. BAGsd
+#. P78bc
#: 05020100.xhp
msgctxt ""
"05020100.xhp\n"
"par_id3153880\n"
"help.text"
-msgid "<ahelp hid=\"dbaccess/ui/relationdialog/table2\" visibility=\"hidden\">This is where the two related tables are listed.</ahelp> If you create a new relation, you can select one table from each of the combo boxes in the top part of the dialog."
+msgid "<ahelp hid=\"dbaccess/ui/relationdialog/table2\">This is where the two related tables are listed.</ahelp> If you create a new relation, you can select one table from each of the combo boxes in the top part of the dialog."
msgstr ""
#. 4UCC7
@@ -4972,6 +4972,1617 @@ msgctxt ""
msgid "<ahelp hid=\"dbaccess/ui/namematchingpage/none\">Clears all of the check boxes in the list.</ahelp>"
msgstr ""
+#. rxCsN
+#: 05040000.xhp
+msgctxt ""
+"05040000.xhp\n"
+"tit\n"
+"help.text"
+msgid "General"
+msgstr ""
+
+#. DmCQD
+#: 05040000.xhp
+msgctxt ""
+"05040000.xhp\n"
+"hd_id3149031\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05040000.xhp\" name=\"General\">General</link>"
+msgstr ""
+
+#. 7ithV
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"tit\n"
+"help.text"
+msgid "General"
+msgstr ""
+
+#. 5uLP9
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3153255\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05040100.xhp\" name=\"General\">General</link>"
+msgstr ""
+
+#. LsG3R
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3157898\n"
+"help.text"
+msgid "When you create a database table as an administrator, you can use this tab to determine user access, and to edit the data or the table structure."
+msgstr ""
+
+#. CydBA
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"bm_id3152594\n"
+"help.text"
+msgid "<bookmark_value>access rights for database tables (Base)</bookmark_value><bookmark_value>tables in databases; access rights to (Base)</bookmark_value>"
+msgstr ""
+
+#. VFwEY
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3152594\n"
+"help.text"
+msgid "If you are not the administrator, you can use the <emph>General</emph> tab to view your access rights for the selected table."
+msgstr ""
+
+#. ZGqED
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3145669\n"
+"help.text"
+msgid "Table name"
+msgstr ""
+
+#. hfNJd
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3147834\n"
+"help.text"
+msgid "Displays the name of the selected database table."
+msgstr ""
+
+#. mxdWQ
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3156426\n"
+"help.text"
+msgid "Type"
+msgstr ""
+
+#. cGosS
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3154823\n"
+"help.text"
+msgid "Displays the type of database."
+msgstr ""
+
+#. jCSC3
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3149095\n"
+"help.text"
+msgid "Location"
+msgstr ""
+
+#. GjS2M
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3153311\n"
+"help.text"
+msgid "Displays the complete path of the database table."
+msgstr ""
+
+#. gA9FG
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3153528\n"
+"help.text"
+msgid "Read data"
+msgstr ""
+
+#. YB94i
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3163802\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows a user to read the data.</ahelp>"
+msgstr ""
+
+#. MFSk5
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3150355\n"
+"help.text"
+msgid "Insert data"
+msgstr ""
+
+#. XFubg
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3149398\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows a user to insert new data.</ahelp>"
+msgstr ""
+
+#. EW2bD
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3155420\n"
+"help.text"
+msgid "Change data"
+msgstr ""
+
+#. U9WwE
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3158430\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows a user to change data.</ahelp>"
+msgstr ""
+
+#. DqoTz
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3149516\n"
+"help.text"
+msgid "Delete data"
+msgstr ""
+
+#. VRspq
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3155449\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows a user to delete data.</ahelp>"
+msgstr ""
+
+#. WAXNP
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3145674\n"
+"help.text"
+msgid "Change table structure"
+msgstr ""
+
+#. NAwCj
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3153146\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows a user to change the table structure.</ahelp>"
+msgstr ""
+
+#. rTzQj
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3143270\n"
+"help.text"
+msgid "Definition"
+msgstr ""
+
+#. zAByc
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3154897\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows the user to delete the table structure.</ahelp>"
+msgstr ""
+
+#. gFhhG
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"hd_id3153126\n"
+"help.text"
+msgid "Modify references"
+msgstr ""
+
+#. qx3NS
+#: 05040100.xhp
+msgctxt ""
+"05040100.xhp\n"
+"par_id3159399\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows the user to modify the defined references, for example, to enter new relations for the table or to delete existing relations.</ahelp>"
+msgstr ""
+
+#. 2sbVx
+#: 05040200.xhp
+msgctxt ""
+"05040200.xhp\n"
+"tit\n"
+"help.text"
+msgid "Description"
+msgstr ""
+
+#. EwUEa
+#: 05040200.xhp
+msgctxt ""
+"05040200.xhp\n"
+"hd_id3109850\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05040200.xhp\" name=\"Description\">Description</link>"
+msgstr ""
+
+#. h4VES
+#: 05040200.xhp
+msgctxt ""
+"05040200.xhp\n"
+"hd_id3157898\n"
+"help.text"
+msgid "Table description"
+msgstr ""
+
+#. ABb4R
+#: 05040200.xhp
+msgctxt ""
+"05040200.xhp\n"
+"par_id3154422\n"
+"help.text"
+msgid "<ahelp hid=\".\">Displays the description for the selected table.</ahelp>"
+msgstr ""
+
+#. jpgRA
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"tit\n"
+"help.text"
+msgid "Data sources in $[officename]"
+msgstr ""
+
+#. w4Ehh
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"bm_id3155449\n"
+"help.text"
+msgid "<bookmark_value>databases;drag and drop (Base)</bookmark_value>"
+msgstr ""
+
+#. HwcVW
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3151299\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/05040200.xhp\" name=\"Data sources in $[officename]\">Data sources in $[officename]</link>"
+msgstr ""
+
+#. PNBCF
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3150616\n"
+"help.text"
+msgid "Selecting the Address Book"
+msgstr ""
+
+#. GeoEc
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3153049\n"
+"help.text"
+msgid "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>."
+msgstr ""
+
+#. hdhBt
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"hd_id3147275\n"
+"help.text"
+msgid "Opening a Data Source"
+msgstr ""
+
+#. C7ppK
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3154143\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. qiyEE
+#: 11000002.xhp
+msgctxt ""
+"11000002.xhp\n"
+"par_id3154046\n"
+"help.text"
+msgid "To view the contents of a database, click the plus sign (+) in front of the name in the data source view."
+msgstr ""
+
+#. 884eA
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"tit\n"
+"help.text"
+msgid "ODBC"
+msgstr ""
+
+#. GCT7W
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149031\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11020000.xhp\" name=\"ODBC\">ODBC</link>"
+msgstr ""
+
+#. kyqcm
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3150499\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. Dbr2C
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3148642\n"
+"help.text"
+msgid "User Name"
+msgstr ""
+
+#. WBXTJ
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154514\n"
+"help.text"
+msgid "<ahelp hid=\".\">Type the user name for accessing the database.</ahelp>"
+msgstr ""
+
+#. DpZgn
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3153665\n"
+"help.text"
+msgid "Password required"
+msgstr ""
+
+#. HaYKD
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3145119\n"
+"help.text"
+msgid "<ahelp hid=\".\">Prevents an unauthorized user from accessing the database. You only need to enter the password once per session.</ahelp>"
+msgstr ""
+
+#. QWAfC
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3153087\n"
+"help.text"
+msgid "Driver Settings"
+msgstr ""
+
+#. FFBSB
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3143271\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/odbcpage/options\">Use this text field to enter additional optional driver settings if this is necessary.</ahelp>"
+msgstr ""
+
+#. ETNaE
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3152472\n"
+"help.text"
+msgid "Character Set"
+msgstr ""
+
+#. SCzpp
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3151245\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. xBEZv
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149669\n"
+"help.text"
+msgid "General"
+msgstr ""
+
+#. REocx
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3147265\n"
+"help.text"
+msgid "Retrieve generated values"
+msgstr ""
+
+#. ToEkf
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3151054\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. aokLy
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3150400\n"
+"help.text"
+msgid "Auto-increment statement"
+msgstr ""
+
+#. HFuC7
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154366\n"
+"help.text"
+msgid "<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:"
+msgstr ""
+
+#. C5Mvn
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3159149\n"
+"help.text"
+msgid "CREATE TABLE \"table1\" (\"id\" INTEGER)"
+msgstr ""
+
+#. M4YsG
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3147084\n"
+"help.text"
+msgid "To auto-increment the \"id\" data field in a MySQL database, change the statement to:"
+msgstr ""
+
+#. 2pPyd
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3154909\n"
+"help.text"
+msgid "CREATE TABLE \"table1\" (\"id\" INTEGER AUTO_INCREMENT)"
+msgstr ""
+
+#. wyFqp
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3152933\n"
+"help.text"
+msgid "In other words, enter AUTO_INCREMENT into <emph>Auto-increment statement</emph> box."
+msgstr ""
+
+#. cFjbY
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3149765\n"
+"help.text"
+msgid "Query of generated values"
+msgstr ""
+
+#. EnHXJ
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3145171\n"
+"help.text"
+msgid "<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:"
+msgstr ""
+
+#. KdqAK
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3150769\n"
+"help.text"
+msgid "SELECT LAST_INSERT_D();"
+msgstr ""
+
+#. UcUfT
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3157892\n"
+"help.text"
+msgid "Use SQL92 naming constraints"
+msgstr ""
+
+#. nvCRa
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3153368\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. 9BNi4
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"hd_id3154011\n"
+"help.text"
+msgid "Use Catalog for file-based databases"
+msgstr ""
+
+#. BaWgu
+#: 11020000.xhp
+msgctxt ""
+"11020000.xhp\n"
+"par_id3148618\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. RBCN4
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"tit\n"
+"help.text"
+msgid "dBASE"
+msgstr ""
+
+#. jQexT
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3153539\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11030000.xhp\" name=\"dBase\">dBASE</link>"
+msgstr ""
+
+#. EFxxW
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3147088\n"
+"help.text"
+msgid "<ahelp hid=\".\">Specify the settings for a dBASE database.</ahelp>"
+msgstr ""
+
+#. bSnXm
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3151110\n"
+"help.text"
+msgid "To be able to define relations between tables, use JDBC or ODBC from within $[officename]."
+msgstr ""
+
+#. irtxH
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3149233\n"
+"help.text"
+msgid "Display inactive records"
+msgstr ""
+
+#. Y4AnV
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3153823\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. 7vpRc
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3156023\n"
+"help.text"
+msgid "In dBASE format, deleted records remain in the file."
+msgstr ""
+
+#. ZYefW
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3151384\n"
+"help.text"
+msgid "To view any changes that you make to the database, close the connection to the database, and then reconnect the database."
+msgstr ""
+
+#. 5LBSi
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id0904200811094971\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. Gmun9
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"hd_id3149047\n"
+"help.text"
+msgid "Indexes"
+msgstr ""
+
+#. BjWsR
+#: 11030000.xhp
+msgctxt ""
+"11030000.xhp\n"
+"par_id3161656\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. vMA8w
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"tit\n"
+"help.text"
+msgid "Indexes"
+msgstr ""
+
+#. x4TDi
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3148983\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11030100.xhp\" name=\"Indexes\">Indexes</link>"
+msgstr ""
+
+#. DmGsN
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3150247\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. Aj5Uz
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3155339\n"
+"help.text"
+msgid "Table"
+msgstr ""
+
+#. bzzGv
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3152551\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/table\">Select the database table that you want to index.</ahelp>"
+msgstr ""
+
+#. eyouE
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3159233\n"
+"help.text"
+msgid "Table Indexes"
+msgstr ""
+
+#. hyCqp
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3143267\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. scWXw
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3148538\n"
+"help.text"
+msgid "Free Indexes"
+msgstr ""
+
+#. mtGqS
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3151110\n"
+"help.text"
+msgid "<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."
+msgstr ""
+
+#. U4FQh
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3156152\n"
+"help.text"
+msgid "<"
+msgstr ""
+
+#. sxDJi
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3150984\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/add\">Moves the selected index to the <emph>Table Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. FPRFh
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3149416\n"
+"help.text"
+msgid "<<"
+msgstr ""
+
+#. 45Vrm
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3145315\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/addall\">Moves all of the free indexes to the <emph>Table Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. Ba8Z9
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3149579\n"
+"help.text"
+msgid ">"
+msgstr ""
+
+#. EP9GN
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3149795\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/remove\">Moves the selected table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. sAASQ
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"hd_id3155629\n"
+"help.text"
+msgid ">>"
+msgstr ""
+
+#. t2gbA
+#: 11030100.xhp
+msgctxt ""
+"11030100.xhp\n"
+"par_id3151245\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/dbaseindexdialog/removeall\">Moves all of the table indexes to the <emph>Free Indexes</emph> list.</ahelp>"
+msgstr ""
+
+#. LQcMC
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Execute SQL statement"
+msgstr ""
+
+#. GDjji
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"bm_id3148983\n"
+"help.text"
+msgid "<bookmark_value>SQL; executing SQL statements (Base)</bookmark_value><bookmark_value>databases; administration through SQL (Base)</bookmark_value>"
+msgstr ""
+
+#. JsqKF
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3153345\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11080000.xhp\" name=\"Execute SQL statement\">Execute SQL statement</link>"
+msgstr ""
+
+#. BtQ2b
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3154288\n"
+"help.text"
+msgid "<variable id=\"sqltext\"><ahelp hid=\".\">Opens a dialog where you can enter an SQL command for administering a database.</ahelp></variable>"
+msgstr ""
+
+#. jhBMm
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3147275\n"
+"help.text"
+msgid "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."
+msgstr ""
+
+#. JZmCZ
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3154860\n"
+"help.text"
+msgid "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>."
+msgstr ""
+
+#. Ck9G4
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3149514\n"
+"help.text"
+msgid "Command to execute"
+msgstr ""
+
+#. BHLbE
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3147618\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/sql\">Enter the SQL administration command that you want to run.</ahelp>"
+msgstr ""
+
+#. 5DFEP
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3153087\n"
+"help.text"
+msgid "For example, for a \"Bibliography\" data source, you can enter the following SQL command:"
+msgstr ""
+
+#. XDWsR
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3145673\n"
+"help.text"
+msgid "SELECT \"Address\" FROM \"biblio\" \"biblio\""
+msgstr ""
+
+#. LjEvw
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3145611\n"
+"help.text"
+msgid "For more information on SQL commands, please consult the documentation that came with the database."
+msgstr ""
+
+#. BQmT9
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3156024\n"
+"help.text"
+msgid "Previous commands"
+msgstr ""
+
+#. hkxBT
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3149045\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. AvXck
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154348\n"
+"help.text"
+msgid "Status"
+msgstr ""
+
+#. yhCpt
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151054\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/status\">Displays the results, including errors, of the SQL command that you ran.</ahelp>"
+msgstr ""
+
+#. BUpxX
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"hd_id3154071\n"
+"help.text"
+msgid "Run"
+msgstr ""
+
+#. qDYRx
+#: 11080000.xhp
+msgctxt ""
+"11080000.xhp\n"
+"par_id3151210\n"
+"help.text"
+msgid "<ahelp hid=\"dbaccess/ui/directsqldialog/execute\">Runs the command that you entered in the <emph>Command to execute </emph>box.</ahelp>"
+msgstr ""
+
+#. 93Xfs
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"tit\n"
+"help.text"
+msgid "Table Filter"
+msgstr ""
+
+#. bG74E
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"hd_id3150702\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/11090000.xhp\" name=\"Tables\">Table Filter</link>"
+msgstr ""
+
+#. NLCCV
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"par_id3149164\n"
+"help.text"
+msgid "<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>"
+msgstr ""
+
+#. axsoU
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"hd_id3154923\n"
+"help.text"
+msgid "Sort Ascending"
+msgstr ""
+
+#. XFbZd
+#: 11090000.xhp
+msgctxt ""
+"11090000.xhp\n"
+"par_id3147559\n"
+"help.text"
+msgid "<ahelp hid=\".\">Sorts the list of table names in ascending order starting at the beginning of the alphabet.</ahelp>"
+msgstr ""
+
+#. SaBHA
+#: dabaadvprop.xhp
+msgctxt ""
+"dabaadvprop.xhp\n"
+"tit\n"
+"help.text"
+msgid "Advanced Properties"
+msgstr ""
+
+#. xBcXZ
+#: dabaadvprop.xhp
+msgctxt ""
+"dabaadvprop.xhp\n"
+"par_idN10550\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/dabaadvprop.xhp\">Advanced Properties</link>"
+msgstr ""
+
+#. 5dCC5
+#: dabaadvprop.xhp
+msgctxt ""
+"dabaadvprop.xhp\n"
+"par_idN10560\n"
+"help.text"
+msgid "Specifies advanced properties for the database."
+msgstr ""
+
+#. FGvho
+#: dabaadvprop.xhp
+msgctxt ""
+"dabaadvprop.xhp\n"
+"par_id3998840\n"
+"help.text"
+msgid "In a database window, choose <emph>Edit - Database - Properties</emph>, click <emph>Advanced Properties</emph> tab"
+msgstr ""
+
+#. ssTZY
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"tit\n"
+"help.text"
+msgid "Special Settings"
+msgstr ""
+
+#. JBUZ3
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"bm_id81623155177507\n"
+"help.text"
+msgid "<bookmark_value>database;special settings</bookmark_value> <bookmark_value>database settings;SQL92 naming</bookmark_value> <bookmark_value>database settings;keyword AS</bookmark_value> <bookmark_value>database settings;outer join syntax</bookmark_value> <bookmark_value>database settings;special SELECT statements</bookmark_value> <bookmark_value>database settings;ODBC date/time</bookmark_value> <bookmark_value>database settings;support primary keys</bookmark_value> <bookmark_value>database settings;line ends</bookmark_value> <bookmark_value>database settings;version columns</bookmark_value>"
+msgstr ""
+
+#. vCApF
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10556\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/dabaadvpropdat.xhp\">Special Settings</link>"
+msgstr ""
+
+#. nv4Nn
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10566\n"
+"help.text"
+msgid "Specifies the way you can work with data in a database."
+msgstr ""
+
+#. nVTwF
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id7679372\n"
+"help.text"
+msgid "In a database window, choose <emph>Edit - Database - Advanced Settings</emph>"
+msgstr ""
+
+#. mEAfH
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id4572283\n"
+"help.text"
+msgid "The availability of the following controls depends on the type of database:"
+msgstr ""
+
+#. 8pnWD
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10590\n"
+"help.text"
+msgid "Use SQL92 naming constraints"
+msgstr ""
+
+#. CZ3vk
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10594\n"
+"help.text"
+msgid "<ahelp hid=\".\">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</ahelp>"
+msgstr ""
+
+#. wHaBn
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105907\n"
+"help.text"
+msgid "Use keyword AS before table alias names"
+msgstr ""
+
+#. xEpbm
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105947\n"
+"help.text"
+msgid "<ahelp hid=\".\">Some databases use the keyword \"AS\" between a name and its alias, while other databases use a whitespace. Enable this option to insert AS before the alias.</ahelp>"
+msgstr ""
+
+#. NbAt4
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"hd_id3534958\n"
+"help.text"
+msgid "End text lines with CR + LF"
+msgstr ""
+
+#. NKKsC
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id6151921\n"
+"help.text"
+msgid "<ahelp hid=\".\">Select to use the CR + LF code pair to end every text line (preferred for DOS and Windows operating systems).</ahelp>"
+msgstr ""
+
+#. UDWZ7
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN1059E\n"
+"help.text"
+msgid "Append the table alias name in SELECT statements"
+msgstr ""
+
+#. v2ZEZ
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105A2\n"
+"help.text"
+msgid "<ahelp hid=\".\">Appends the alias to the table name in SELECT statements.</ahelp>"
+msgstr ""
+
+#. 6kz2C
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105A5\n"
+"help.text"
+msgid "Use Outer Join syntax '{OJ }'"
+msgstr ""
+
+#. 9PDve
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105A9\n"
+"help.text"
+msgid "<ahelp hid=\".\">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}</ahelp>"
+msgstr ""
+
+#. xahKj
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105BE\n"
+"help.text"
+msgid "Example:"
+msgstr ""
+
+#. 8rHyA
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105C1\n"
+"help.text"
+msgid "select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}"
+msgstr ""
+
+#. yARgJ
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105C4\n"
+"help.text"
+msgid "Ignore the privileges from the database driver"
+msgstr ""
+
+#. GoiGX
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105C8\n"
+"help.text"
+msgid "<ahelp hid=\".\">Ignores access privileges that are provided by the database driver.</ahelp>"
+msgstr ""
+
+#. CcsGn
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105CB\n"
+"help.text"
+msgid "Replace named parameters with ?"
+msgstr ""
+
+#. finzM
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105CF\n"
+"help.text"
+msgid "<ahelp hid=\".\">Replaces named parameters in a data source with a question mark (?).</ahelp>"
+msgstr ""
+
+#. LypD3
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105D2\n"
+"help.text"
+msgid "Display version columns (when available)"
+msgstr ""
+
+#. gJR4a
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105D6\n"
+"help.text"
+msgid "Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid=\"dbaccess/ui/specialsettingspage/displayver\">Displays the internal version number of the record in the database table.</ahelp>"
+msgstr ""
+
+#. HLoGa
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105FA\n"
+"help.text"
+msgid "Use the catalog name in SELECT statements"
+msgstr ""
+
+#. uqBBN
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN105FE\n"
+"help.text"
+msgid "<ahelp hid=\".\">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBASE driver.</ahelp>"
+msgstr ""
+
+#. uTnnA
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10613\n"
+"help.text"
+msgid "Use the schema name in SELECT statements"
+msgstr ""
+
+#. EVDZk
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10617\n"
+"help.text"
+msgid "<ahelp hid=\".\">Allows you to use the schema name in SELECT statements.</ahelp>"
+msgstr ""
+
+#. JgvBE
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN1061A\n"
+"help.text"
+msgid "Create index with ASC or DESC statement"
+msgstr ""
+
+#. BgkNz
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN1061E\n"
+"help.text"
+msgid "<ahelp hid=\".\">Creates an index with ASC or DESC statements.</ahelp>"
+msgstr ""
+
+#. BzVqp
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10621\n"
+"help.text"
+msgid "Comparison of Boolean values"
+msgstr ""
+
+#. rgzfK
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_idN10625\n"
+"help.text"
+msgid "<ahelp hid=\".\">Select the type of Boolean comparison that you want to use.</ahelp>"
+msgstr ""
+
+#. X2cuQ
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"hd_id1101718\n"
+"help.text"
+msgid "Form data input checks for required fields"
+msgstr ""
+
+#. 8FD9D
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id3783989\n"
+"help.text"
+msgid "<ahelp hid=\".\">When you enter a new record or update an existing record in a form, and you leave a field empty which is bound to a database column which requires input, then you will see a message complaining about the empty field.</ahelp>"
+msgstr ""
+
+#. LPJKD
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id6684163\n"
+"help.text"
+msgid "If this control box is not enabled, then the forms in the current database will not be checked for required fields."
+msgstr ""
+
+#. fZAwm
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id3837397\n"
+"help.text"
+msgid "The control box is available for all data source types which support write access to their data. The control box does not exist for spreadsheets, text, csv, and the various read-only address books."
+msgstr ""
+
+#. T9wrt
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"hd_id0909200811170166\n"
+"help.text"
+msgid "Ignore currency field information"
+msgstr ""
+
+#. MWpZD
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id0909200811170221\n"
+"help.text"
+msgid "<ahelp hid=\".\">Only for Oracle JDBC connections. When enabled it specifies that no column is treated as a currency field. The field type returned from the database driver is discarded.</ahelp>"
+msgstr ""
+
+#. ykjaM
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"hd_id040920092139524\n"
+"help.text"
+msgid "Use ODBC conformant date/time literals"
+msgstr ""
+
+#. AFvyx
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id040920092139526\n"
+"help.text"
+msgid "<ahelp hid=\".\">Use date/time literals that conform to ODBC standard.</ahelp>"
+msgstr ""
+
+#. 9PTAJ
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"hd_id04092009442139524\n"
+"help.text"
+msgid "Supports primary keys"
+msgstr ""
+
+#. BVmAU
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id04096620092139526\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enable to overrule Base's heuristics used to detect whether the database supports primary keys.</ahelp>"
+msgstr ""
+
+#. WCkDd
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id66841631\n"
+"help.text"
+msgid "When connecting to a database using a generic API like ODBC, JDBC, or ADO, Base currently applies heuristics to determine whether this database supports primary keys. None of those APIs has dedicated support to retrieve this information."
+msgstr ""
+
+#. U5ssy
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id66841632\n"
+"help.text"
+msgid "The heuristics sometimes fails. This tri-state check box by default is set to the undetermined state, which means \"apply the heuristics\". If the check box is enabled, primary key support is assumed. If the check box is disabled, no primary key support is assumed."
+msgstr ""
+
+#. vdH4q
+#: dabaadvpropdat.xhp
+msgctxt ""
+"dabaadvpropdat.xhp\n"
+"par_id66841633\n"
+"help.text"
+msgid "Note that if this option is just for overruling the heuristics. If you enable the check box for a database which actually does not support primary keys, you will see some errors."
+msgstr ""
+
+#. EYaFK
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"tit\n"
+"help.text"
+msgid "Generated Values"
+msgstr ""
+
+#. kGZBa
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"bm_id521623154765032\n"
+"help.text"
+msgid "<bookmark_value>database advanced properties;autoincrement values</bookmark_value> <bookmark_value>database advanced properties;automatic generated values</bookmark_value> <bookmark_value>database advanced properties;retrieve generated values</bookmark_value> <bookmark_value>database advanced properties;query generated values</bookmark_value>"
+msgstr ""
+
+#. kqFCk
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10553\n"
+"help.text"
+msgid "<link href=\"text/sdatabase/dabaadvpropgen.xhp\">Generated Values</link>"
+msgstr ""
+
+#. x7uc3
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10563\n"
+"help.text"
+msgid "Specifies the options for automatically generated values for new data records."
+msgstr ""
+
+#. Dpncz
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_id7684560\n"
+"help.text"
+msgid "The availability of the following controls depends on the type of database:"
+msgstr ""
+
+#. moLhP
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN1058C\n"
+"help.text"
+msgid "Retrieve generated values"
+msgstr ""
+
+#. KGEf3
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10590\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enables $[officename] support for auto-incremented data fields in the current ODBC or JDBC data source. Select this option if the auto-increment feature in the SDBCX layer of the database is not supported. In general, the auto-increment is selected for the primary key field.</ahelp>"
+msgstr ""
+
+#. x4VQL
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10593\n"
+"help.text"
+msgid "Auto-increment statement"
+msgstr ""
+
+#. Hskow
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10597\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enter the SQL command specifier that instructs the data source to auto-increment a specified Integer data field.</ahelp> For example, the following MySQL statement used the AUTO_INCREMENT statement to increase the \"id\" field each time the statement creates a data field:"
+msgstr ""
+
+#. Vi6CV
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN105A0\n"
+"help.text"
+msgid "CREATE TABLE \"table1\" (\"id\" INTEGER AUTO_INCREMENT)"
+msgstr ""
+
+#. rDQtm
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10634\n"
+"help.text"
+msgid "For this example, you must enter AUTO_INCREMENT into the <emph>Auto-increment statement</emph> box."
+msgstr ""
+
+#. GSfGJ
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN105AA\n"
+"help.text"
+msgid "Query of generated values"
+msgstr ""
+
+#. gCRhF
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN10645\n"
+"help.text"
+msgid "<ahelp hid=\".\">Enter an SQL statement that returns the last auto-incremented value for the primary key data field.</ahelp> For example:"
+msgstr ""
+
+#. BzyHv
+#: dabaadvpropgen.xhp
+msgctxt ""
+"dabaadvpropgen.xhp\n"
+"par_idN105B1\n"
+"help.text"
+msgid "SELECT LAST_INSERT_D();"
+msgstr ""
+
#. cLmBi
#: main.xhp
msgctxt ""