1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file 9 * to you under the Apache License, Version 2.0 (the 10 * "License"); you may not use this file except in compliance 11 * with the License. You may obtain a copy of the License at 12 * 13 * http://www.apache.org/licenses/LICENSE-2.0 14 * 15 * Unless required by applicable law or agreed to in writing, 16 * software distributed under the License is distributed on an 17 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18 * KIND, either express or implied. See the License for the 19 * specific language governing permissions and limitations 20 * under the License. 21 * 22 ***********************************************************--> 23 24<helpdocument version="1.0"> 25<meta> 26<topic id="textsharedexplorerdatabase05010100xml" indexer="include" status="PUBLISH"> 27<title id="tit" xml-lang="en-US">Index design</title> 28<filename>/text/shared/explorer/database/05010100.xhp</filename> 29</topic> 30</meta> 31<body> 32<section id="indexentwurf"> 33<bookmark xml-lang="en-US" branch="hid/dbaccess:ModalDialog:DLG_INDEXDESIGN" id="bm_id3156410" localize="false"/> 34<bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/> 35<paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05010100.xhp" name="Index design">Index design</link></paragraph> 36<paragraph role="paragraph" id="par_id3166460" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design</emph> dialog allows you edit the indexes for the current table.</ahelp></paragraph> 37</section> 38<section id="howtoget"> 39<embed href="text/shared/00/00000450.xhp#indexentwurf"/> 40</section> 41<embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/> 42<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_INDEXLIST" id="bm_id3148473" localize="false"/> 43<paragraph role="heading" id="hd_id3149578" xml-lang="en-US" level="2" l10n="U" oldref="3">Index list</paragraph> 44<paragraph role="paragraph" id="par_id3155342" xml-lang="en-US" l10n="CHG" oldref="4"><ahelp hid="HID_DLGIDX_INDEXLIST">Displays the available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph> 45<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_NEWINDEX" id="bm_id3158430" localize="false"/> 46<paragraph role="heading" id="hd_id3149795" xml-lang="en-US" level="3" l10n="U" oldref="5">New Index</paragraph> 47<paragraph role="paragraph" id="par_id3150085" xml-lang="en-US" l10n="U" oldref="6"><ahelp hid="HID_DLGIDX_NEWINDEX">Creates a new index.</ahelp></paragraph> 48<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_DROPINDEX" id="bm_id3148642" localize="false"/> 49<paragraph role="heading" id="hd_id3145317" xml-lang="en-US" level="3" l10n="U" oldref="7">Delete Current Index</paragraph> 50<paragraph role="paragraph" id="par_id3154860" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="HID_DLGIDX_DROPINDEX">Deletes the current index.</ahelp></paragraph> 51<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_RENAMEINDEX" id="bm_id3154285" localize="false"/> 52<paragraph role="heading" id="hd_id3150986" xml-lang="en-US" level="3" l10n="U" oldref="9">Rename Current Index</paragraph> 53<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="HID_DLGIDX_RENAMEINDEX">Renames the current index.</ahelp></paragraph> 54<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_SAVEINDEX" id="bm_id3151245" localize="false"/> 55<paragraph role="heading" id="hd_id3153628" xml-lang="en-US" level="3" l10n="U" oldref="11">Save Current Index</paragraph> 56<paragraph role="paragraph" id="par_id3148563" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_DLGIDX_SAVEINDEX">Saves the current index in the data source.</ahelp></paragraph> 57<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGIDX_RESETINDEX" id="bm_id3147265" localize="false"/> 58<paragraph role="heading" id="hd_id3154924" xml-lang="en-US" level="3" l10n="U" oldref="13">Reset Current Index</paragraph> 59<paragraph role="paragraph" id="par_id3154758" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="HID_DLGIDX_RESETINDEX">Resets the current index to the setting that it had when the dialog was started.</ahelp></paragraph> 60<paragraph role="heading" id="hd_id3152812" xml-lang="en-US" level="2" l10n="U" oldref="15">Index details</paragraph> 61<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US" l10n="U" oldref="16">As soon as you change a detail of the current index and then select another index, the change is immediately passed to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index</emph> icon.</paragraph> 62<bookmark xml-lang="en-US" branch="hid/dbaccess:CheckBox:DLG_INDEXDESIGN:CB_UNIQUE" id="bm_id3145171" localize="false"/> 63<paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="3" l10n="U" oldref="17">Unique</paragraph> 64<paragraph role="paragraph" id="par_id3156282" xml-lang="en-US" l10n="U" oldref="18"><ahelp hid="DBACCESS_CHECKBOX_DLG_INDEXDESIGN_CB_UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique</emph> option prevents duplicate data from being entered in the field and ensures data integrity.</paragraph> 65<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="3" l10n="U" oldref="19">Fields</paragraph> 66<paragraph role="paragraph" id="par_id3147085" xml-lang="en-US" l10n="U" oldref="20">The <emph>Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.</paragraph> 67<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/> 68<paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3" l10n="U" oldref="21">Index field</paragraph> 69<paragraph role="paragraph" id="par_id3158408" xml-lang="en-US" l10n="CHG" oldref="22"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp><comment>i73718</comment></paragraph> 70<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/> 71<paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="3" l10n="U" oldref="23">Sort order</paragraph> 72<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order.</ahelp></paragraph> 73<bookmark xml-lang="en-US" branch="hid/dbaccess:PushButton:DLG_INDEXDESIGN:PB_CLOSE" id="bm_id3145785" localize="false"/> 74<paragraph role="heading" id="hd_id3155132" xml-lang="en-US" level="2" l10n="U" oldref="25">Close</paragraph> 75<paragraph role="paragraph" id="par_id3154190" xml-lang="en-US" l10n="U" oldref="26"><ahelp hid="DBACCESS_PUSHBUTTON_DLG_INDEXDESIGN_PB_CLOSE">Closes the dialog.</ahelp></paragraph> 76</body> 77</helpdocument> 78