1*b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?> 2*b1cdbd2cSJim Jagielski<helpdocument version="1.0"> 3*b1cdbd2cSJim Jagielski 4*b1cdbd2cSJim Jagielski<!--*********************************************************** 5*b1cdbd2cSJim Jagielski * 6*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 7*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 8*b1cdbd2cSJim Jagielski * distributed with this work for additional information 9*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 10*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 11*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 12*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 13*b1cdbd2cSJim Jagielski * 14*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 15*b1cdbd2cSJim Jagielski * 16*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 17*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 18*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 20*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 21*b1cdbd2cSJim Jagielski * under the License. 22*b1cdbd2cSJim Jagielski * 23*b1cdbd2cSJim Jagielski ***********************************************************--> 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim Jagielski<meta> 29*b1cdbd2cSJim Jagielski <topic id="textshared0212100200xml" indexer="include"> 30*b1cdbd2cSJim Jagielski <title xml-lang="en-US" id="tit">Find Record</title> 31*b1cdbd2cSJim Jagielski <filename>/text/shared/02/12100200.xhp</filename> 32*b1cdbd2cSJim Jagielski </topic> 33*b1cdbd2cSJim Jagielski </meta> 34*b1cdbd2cSJim Jagielski <body> 35*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="index" id="bm_id3146936"><bookmark_value>tables in databases; searching</bookmark_value> 36*b1cdbd2cSJim Jagielski <bookmark_value>forms; browsing</bookmark_value> 37*b1cdbd2cSJim Jagielski <bookmark_value>records; searching in databases</bookmark_value> 38*b1cdbd2cSJim Jagielski <bookmark_value>searching; databases</bookmark_value> 39*b1cdbd2cSJim Jagielski <bookmark_value>databases; searching records</bookmark_value> 40*b1cdbd2cSJim Jagielski</bookmark><comment>mw changed" database tables;" to "tables in databases;"</comment> 41*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:RecSearch" id="bm_id9750501" localize="false"/> 42*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/.uno:RecSearch" id="bm_id3154812" localize="false"/> 43*b1cdbd2cSJim Jagielski<section id="findrecord"> 44*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3146936" role="heading" level="1" l10n="U" oldref="1"><variable id="datensatzsuche"><link href="text/shared/02/12100200.xhp" name="Find Record">Find Record</link> 45*b1cdbd2cSJim Jagielski</variable></paragraph> 46*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147588" role="paragraph" l10n="U" oldref="2"><variable id="suchentext"><ahelp hid=".uno:RecSearch" visibility="hidden">Searches database tables and forms.</ahelp>In forms or database tables, you can search through data fields, list boxes, and check boxes for specific values. 47*b1cdbd2cSJim Jagielski</variable></paragraph> 48*b1cdbd2cSJim Jagielski </section> 49*b1cdbd2cSJim Jagielski <section id="howtoget"> 50*b1cdbd2cSJim Jagielski <embed href="text/shared/00/00000450.xhp#datensuchen"/> 51*b1cdbd2cSJim Jagielski </section> 52*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149355" role="paragraph" l10n="U" oldref="3">When searching a table, the data fields of the current table are searched. When searching in a form, the data fields of the table linked with the form are searched.</paragraph> 53*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153394" role="tip" l10n="U" oldref="111">The search described here is carried out by <item type="productname">%PRODUCTNAME</item>. If you want to use the SQL server to search in a database, then you should use the <link href="text/shared/02/12110000.xhp" name="Form-based Filters">Form-based Filters</link> icon on the <link href="text/shared/main0213.xhp" name="Form Bar">Form Bar</link>.</paragraph> 54*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149095" role="paragraph" l10n="U" oldref="110">The search function is also available for table controls. When calling the search function from a table control, you can search each column of the table control corresponding to the database columns of the linked database table.</paragraph> 55*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3143267" role="heading" level="2" l10n="U" 56*b1cdbd2cSJim Jagielski oldref="112">Search for</paragraph> 57*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153527" role="paragraph" l10n="U" oldref="113">Specifies the type of search.</paragraph> 58*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_TEXT" id="bm_id3154317" localize="false"/> 59*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:RadioButton:RID_SVXDLG_SEARCHFORM:RB_SEARCHFORTEXT" id="bm_id3147577" localize="false"/> 60*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153683" role="heading" level="2" l10n="U" oldref="6">Text:</paragraph> 61*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154823" role="paragraph" l10n="U" oldref="7"><ahelp hid="SVX_RADIOBUTTON_RID_SVXDLG_SEARCHFORM_RB_SEARCHFORTEXT">Enter the search term in the box or select it from the list.</ahelp> The text under the cursor is already copied into the <emph>Text</emph> combo box. Note that while running a search in a form, tabs and line breaks cannot be processed.</paragraph> 62*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148539" role="paragraph" l10n="U" oldref="8">Your search terms will be saved as long as the table or the formula document is open. If you are running more than one search and you would like to repeat the search term, you can select a previously used search term from the combo box.</paragraph> 63*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:RadioButton:RID_SVXDLG_SEARCHFORM:RB_SEARCHFORNULL" id="bm_id3145316" localize="false"/> 64*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153662" role="heading" level="2" l10n="U" 65*b1cdbd2cSJim Jagielski oldref="114">Field content is NULL</paragraph> 66*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153543" role="paragraph" l10n="U" oldref="115"><ahelp hid="SVX_RADIOBUTTON_RID_SVXDLG_SEARCHFORM_RB_SEARCHFORNULL">Specifies that fields will be found that contain no data.</ahelp></paragraph> 67*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:RadioButton:RID_SVXDLG_SEARCHFORM:RB_SEARCHFORNOTNULL" id="bm_id3155388" localize="false"/> 68*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3153717" role="heading" level="2" l10n="U" 69*b1cdbd2cSJim Jagielski oldref="116">Field content is not NULL</paragraph> 70*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3143270" role="paragraph" l10n="U" oldref="117"><ahelp hid="SVX_RADIOBUTTON_RID_SVXDLG_SEARCHFORM_RB_SEARCHFORNOTNULL">Specifies that fields will be found that contain data.</ahelp></paragraph> 71*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3156153" role="heading" level="2" l10n="U" oldref="9">Where to search</paragraph> 72*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149164" role="paragraph" l10n="U" oldref="10">Specifies the fields for the search.</paragraph> 73*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:ListBox:RID_SVXDLG_SEARCHFORM:LB_FORM" id="bm_id3150670" localize="false"/> 74*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3154564" role="heading" level="2" l10n="U" 75*b1cdbd2cSJim Jagielski oldref="105">Form</paragraph> 76*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159176" role="paragraph" l10n="U" oldref="106"><ahelp hid="SVX_LISTBOX_RID_SVXDLG_SEARCHFORM_LB_FORM">Specifies the logical form in which you want the search to take place.</ahelp></paragraph> 77*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155434" role="note" l10n="U" oldref="107">The<emph> Form </emph>combo box is only visible if the current document is a form document with more than one logical form. It does not appear during a search in tables or queries.</paragraph> 78*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151384" role="paragraph" l10n="U" oldref="108">Form documents may contain multiple logical forms. These are individual form components, which are each linked to a table.</paragraph> 79*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145086" role="paragraph" l10n="U" oldref="109">The <emph>Form</emph> combo box contains the names of all logical forms for which controls exist.</paragraph> 80*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_ALLFIELDS" id="bm_id3149047" localize="false"/> 81*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3159414" role="heading" level="2" l10n="U" 82*b1cdbd2cSJim Jagielski oldref="11">All Fields</paragraph> 83*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153896" role="paragraph" l10n="U" oldref="12"><ahelp hid="HID_SEARCH_ALLFIELDS">Searches through all fields.</ahelp> If you are running a search in a table, all fields in the table will be searched. If you are running a search in a form, all fields of the logical form (entered under <emph>Form</emph>) will be searched. If you are running a search in a table control field, all columns that are linked to a valid database table field will be searched.</paragraph> 84*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151054" role="paragraph" l10n="U" oldref="13">Note that the fields of the current logical form do not have to be identical to the fields of the form document. If the form document contains fields that point to multiple data sources (that is, multiple logical forms), the <emph>All Fields</emph> option will only search for the fields linked to data sources in the form document.</paragraph> 85*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_FIELDSELECTION" id="bm_id3153524" localize="false"/> 86*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/cui:RadioButton:RID_SVXDLG_SEARCHFORM:RB_SINGLEFIELD" id="bm_id3150400" localize="false"/> 87*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3150865" role="heading" level="2" l10n="U" 88*b1cdbd2cSJim Jagielski oldref="15">Single field</paragraph> 89*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153360" role="paragraph" l10n="U" oldref="16"><ahelp hid="SVX_RADIOBUTTON_RID_SVXDLG_SEARCHFORM_RB_SINGLEFIELD">Searches through a specified data field.</ahelp></paragraph> 90*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3154365" role="heading" level="2" l10n="U" 91*b1cdbd2cSJim Jagielski oldref="17">Settings</paragraph> 92*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3158408" role="paragraph" l10n="U" oldref="18">Defines settings to control the search.</paragraph> 93*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_POSITION" id="bm_id3143233" localize="false"/> 94*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3149809" role="heading" level="2" l10n="U" 95*b1cdbd2cSJim Jagielski oldref="19">Position</paragraph> 96*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148673" role="paragraph" l10n="U" oldref="20"><ahelp hid="HID_SEARCH_POSITION">Specifies the relationship of the search term and the field contents.</ahelp> The following options are available:</paragraph> 97*b1cdbd2cSJim Jagielski <table id="tbl_id3155994"> 98*b1cdbd2cSJim Jagielski <tablerow> 99*b1cdbd2cSJim Jagielski <tablecell> 100*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156280" role="tablecontent" l10n="U" oldref="21">anywhere in the field</paragraph> 101*b1cdbd2cSJim Jagielski </tablecell> 102*b1cdbd2cSJim Jagielski <tablecell> 103*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145744" role="tablecontent" l10n="U" oldref="22">Returns all fields containing the search pattern anywhere in the field.</paragraph> 104*b1cdbd2cSJim Jagielski </tablecell> 105*b1cdbd2cSJim Jagielski </tablerow> 106*b1cdbd2cSJim Jagielski <tablerow> 107*b1cdbd2cSJim Jagielski <tablecell> 108*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148451" role="tablecontent" l10n="U" oldref="23">beginning of field</paragraph> 109*b1cdbd2cSJim Jagielski </tablecell> 110*b1cdbd2cSJim Jagielski <tablecell> 111*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155429" role="tablecontent" l10n="U" oldref="24">Returns all fields containing the search pattern at the beginning of the field.</paragraph> 112*b1cdbd2cSJim Jagielski </tablecell> 113*b1cdbd2cSJim Jagielski </tablerow> 114*b1cdbd2cSJim Jagielski <tablerow> 115*b1cdbd2cSJim Jagielski <tablecell> 116*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155131" role="tablecontent" l10n="U" oldref="74">end of field</paragraph> 117*b1cdbd2cSJim Jagielski </tablecell> 118*b1cdbd2cSJim Jagielski <tablecell> 119*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153726" role="tablecontent" l10n="U" oldref="75">Returns all fields containing the search pattern at the end of the field.</paragraph> 120*b1cdbd2cSJim Jagielski </tablecell> 121*b1cdbd2cSJim Jagielski </tablerow> 122*b1cdbd2cSJim Jagielski <tablerow> 123*b1cdbd2cSJim Jagielski <tablecell> 124*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3147317" role="tablecontent" l10n="U" oldref="25">entire field</paragraph> 125*b1cdbd2cSJim Jagielski </tablecell> 126*b1cdbd2cSJim Jagielski <tablecell> 127*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154127" role="tablecontent" l10n="U" oldref="26">Returns all fields containing the search pattern as an exact match to the contents of the field.</paragraph> 128*b1cdbd2cSJim Jagielski </tablecell> 129*b1cdbd2cSJim Jagielski </tablerow> 130*b1cdbd2cSJim Jagielski </table> 131*b1cdbd2cSJim Jagielski 132*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3152886" role="note" l10n="U" oldref="27">If the <emph>Wildcard expression</emph> check box is marked, this function is not available.</paragraph> 133*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_FORMATTER" id="bm_id3154147" localize="false"/> 134*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3149664" role="heading" level="2" l10n="U" 135*b1cdbd2cSJim Jagielski oldref="28">Apply field format</paragraph> 136*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146975" role="paragraph" l10n="U" oldref="29"><ahelp hid="HID_SEARCH_FORMATTER">Specifies that all field formats are considered when searching in the current document.</ahelp> Field formats are all visible formats that are created using the following possibilities:</paragraph> 137*b1cdbd2cSJim Jagielski <list type="ordered"> 138*b1cdbd2cSJim Jagielski <listitem> 139*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150103" role="listitem" l10n="U" oldref="78">in table design mode for field properties,</paragraph> 140*b1cdbd2cSJim Jagielski </listitem> 141*b1cdbd2cSJim Jagielski <listitem> 142*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150488" role="listitem" l10n="U" oldref="79">in data source view on column formatting,</paragraph> 143*b1cdbd2cSJim Jagielski </listitem> 144*b1cdbd2cSJim Jagielski <listitem> 145*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3152941" role="listitem" l10n="U" oldref="80">in forms on control properties.</paragraph> 146*b1cdbd2cSJim Jagielski </listitem> 147*b1cdbd2cSJim Jagielski </list> 148*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156736" role="paragraph" l10n="U" oldref="81">If the <emph>Apply field format</emph> box is marked, the data source view of the table or form is searched using the formatting set there. If the box is not marked, the database is searched using the formatting saved in the database.</paragraph> 149*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151280" role="paragraph" l10n="U" oldref="82">Example:</paragraph> 150*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149959" role="paragraph" l10n="CHG" oldref="83">You have a date field, which is saved in "DD.MM.YY" format in the database (for example, 17.02.65). The format of the entry is changed in the data source view to "DD MMM YYYY" (17 Feb 1965). Following this example, a record containing February 17 is only found when the <emph>Apply field format</emph> option is on:</paragraph> 151*b1cdbd2cSJim Jagielski <table id="tbl_id3151076"> 152*b1cdbd2cSJim Jagielski <tablerow> 153*b1cdbd2cSJim Jagielski <tablecell> 154*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150593" role="tablehead" l10n="U" oldref="84">Apply field format</paragraph> 155*b1cdbd2cSJim Jagielski </tablecell> 156*b1cdbd2cSJim Jagielski <tablecell> 157*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145253" role="tablehead" l10n="U" oldref="85">Search pattern</paragraph> 158*b1cdbd2cSJim Jagielski </tablecell> 159*b1cdbd2cSJim Jagielski </tablerow> 160*b1cdbd2cSJim Jagielski <tablerow> 161*b1cdbd2cSJim Jagielski <tablecell> 162*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3083279" role="tablecontent" l10n="U" oldref="86">on</paragraph> 163*b1cdbd2cSJim Jagielski </tablecell> 164*b1cdbd2cSJim Jagielski <tablecell> 165*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155850" role="tablecontent" l10n="U" oldref="87">"Feb" is returned, but not "2".</paragraph> 166*b1cdbd2cSJim Jagielski </tablecell> 167*b1cdbd2cSJim Jagielski </tablerow> 168*b1cdbd2cSJim Jagielski <tablerow> 169*b1cdbd2cSJim Jagielski <tablecell> 170*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148590" role="tablecontent" l10n="U" oldref="88">off</paragraph> 171*b1cdbd2cSJim Jagielski </tablecell> 172*b1cdbd2cSJim Jagielski <tablecell> 173*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153418" role="tablecontent" l10n="U" oldref="89">"2" is returned, but not "Feb".</paragraph> 174*b1cdbd2cSJim Jagielski </tablecell> 175*b1cdbd2cSJim Jagielski </tablerow> 176*b1cdbd2cSJim Jagielski </table> 177*b1cdbd2cSJim Jagielski 178*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151321" role="paragraph" l10n="U" oldref="90">It is recommended that you always search using field formatting.</paragraph> 179*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149401" role="paragraph" l10n="U" oldref="91">The following examples show possible issues when searching without field formatting. These issues depend on the database used and only occur for certain internal default formatting:</paragraph> 180*b1cdbd2cSJim Jagielski <table id="tbl_id3156320"> 181*b1cdbd2cSJim Jagielski <tablerow> 182*b1cdbd2cSJim Jagielski <tablecell> 183*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3152971" role="tablehead" l10n="U" oldref="92">Search results</paragraph> 184*b1cdbd2cSJim Jagielski </tablecell> 185*b1cdbd2cSJim Jagielski <tablecell> 186*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154273" role="tablehead" l10n="U" oldref="93">Cause</paragraph> 187*b1cdbd2cSJim Jagielski </tablecell> 188*b1cdbd2cSJim Jagielski </tablerow> 189*b1cdbd2cSJim Jagielski <tablerow> 190*b1cdbd2cSJim Jagielski <tablecell> 191*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153836" role="tablecontent" l10n="U" oldref="94">"5" returns "14:00:00" as a time</paragraph> 192*b1cdbd2cSJim Jagielski </tablecell> 193*b1cdbd2cSJim Jagielski <tablecell> 194*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156332" role="tablecontent" l10n="U" oldref="95">Time fields are not defined for dBASE databases and must be simulated. To internally display the time "14:00:00", a 5 is necessary.</paragraph> 195*b1cdbd2cSJim Jagielski </tablecell> 196*b1cdbd2cSJim Jagielski </tablerow> 197*b1cdbd2cSJim Jagielski <tablerow> 198*b1cdbd2cSJim Jagielski <tablecell> 199*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3157965" role="tablecontent" l10n="U" oldref="96">"00:00:00" returns all records of a standard date field</paragraph> 200*b1cdbd2cSJim Jagielski </tablecell> 201*b1cdbd2cSJim Jagielski <tablecell> 202*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146081" role="tablecontent" l10n="U" oldref="97">The database stores a date value internally using a combined date/time field.</paragraph> 203*b1cdbd2cSJim Jagielski </tablecell> 204*b1cdbd2cSJim Jagielski </tablerow> 205*b1cdbd2cSJim Jagielski <tablerow> 206*b1cdbd2cSJim Jagielski <tablecell> 207*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155764" role="tablecontent" l10n="U" oldref="98">"45.79" does not return "45.79" although the <emph>entire field</emph> option is selected under <emph>Position</emph>.</paragraph> 208*b1cdbd2cSJim Jagielski </tablecell> 209*b1cdbd2cSJim Jagielski <tablecell> 210*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155518" role="tablecontent" l10n="U" oldref="99">The view shown does not match what is stored internally. For example, if value 45.789 is stored in the database as a field of type Number/Double and the shown formatting is set to display only two decimals, "45.79" is only returned in searches with field formatting.</paragraph> 211*b1cdbd2cSJim Jagielski </tablecell> 212*b1cdbd2cSJim Jagielski </tablerow> 213*b1cdbd2cSJim Jagielski </table> 214*b1cdbd2cSJim Jagielski 215*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148481" role="paragraph" l10n="U" oldref="100">In this case, standard formatting is formatting that refers to the internally stored data. It is not always visible to the user, especially if it is used for simulating data types (for example, time fields in dBASE databases). This depends on the database used and the individual data type. Searching with field formatting is appropriate if you only want to find what is actually shown. This includes fields of type Date, Time, Date/Time and Number/Double.</paragraph> 216*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154507" role="paragraph" l10n="U" oldref="31">However, searching without <emph>Apply field format </emph>is appropriate for larger databases with no formatting issues, because it is faster.</paragraph> 217*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153355" role="paragraph" l10n="CHG" oldref="118">If you are searching the values of check boxes, and <emph>Apply field format</emph> is on, then you will receive a "1" for marked check boxes, a "0" for unmarked check boxes, and an empty string for undefined (tristate) check boxes. If the search has been carried out with <emph>Apply field format</emph> set to off, you will see the language-dependent default values "TRUE" or "FALSE".</paragraph> 218*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150995" role="paragraph" l10n="U" oldref="119">If you use <emph>Apply field format</emph> when searching in list boxes, you find the text displayed in list boxes. If you do not use <emph>Apply field format,</emph> you will find the contents corresponding to the standard field format.</paragraph> 219*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_CASE" id="bm_id3156717" localize="false"/> 220*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3150387" role="heading" level="2" l10n="U" 221*b1cdbd2cSJim Jagielski oldref="32">Match case</paragraph> 222*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3159267" role="paragraph" l10n="U" oldref="33"><ahelp hid="HID_SEARCH_CASE">Specifies that upper and lower case are taken into consideration during the search.</ahelp></paragraph> 223*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_BACKWARD" id="bm_id3151101" localize="false"/> 224*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3145297" role="heading" level="2" l10n="U" 225*b1cdbd2cSJim Jagielski oldref="34">Search backwards</paragraph> 226*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151249" role="paragraph" l10n="U" oldref="35"><ahelp hid="HID_SEARCH_BACKWARD">Specifies that the search process will run in reverse direction, from the last to the first record.</ahelp></paragraph> 227*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_STARTOVER" id="bm_id3166447" localize="false"/> 228*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3152484" role="heading" level="2" l10n="U" 229*b1cdbd2cSJim Jagielski oldref="36">From top / From bottom</paragraph> 230*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156316" role="paragraph" l10n="U" oldref="37"><ahelp hid="HID_SEARCH_STARTOVER">Restarts the search. A forward search restarts with the first record. A backwards search restarts with the last record.</ahelp></paragraph> 231*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_WILDCARD" id="bm_id3156713" localize="false"/> 232*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3163724" role="heading" level="2" l10n="U" 233*b1cdbd2cSJim Jagielski oldref="38">Wildcard expression</paragraph> 234*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149255" role="paragraph" l10n="U" oldref="64"><ahelp hid="HID_SEARCH_WILDCARD" visibility="hidden">Allows a search with a * or ? wildcard.</ahelp> You can use the following wildcards:</paragraph> 235*b1cdbd2cSJim Jagielski <table id="tbl_id3151187"> 236*b1cdbd2cSJim Jagielski <tablerow> 237*b1cdbd2cSJim Jagielski <tablecell> 238*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146317" role="tablehead" l10n="U" oldref="39">Wildcards</paragraph> 239*b1cdbd2cSJim Jagielski </tablecell> 240*b1cdbd2cSJim Jagielski <tablecell> 241*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150298" role="tablehead" l10n="U" oldref="40">Meaning</paragraph> 242*b1cdbd2cSJim Jagielski </tablecell> 243*b1cdbd2cSJim Jagielski <tablecell> 244*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153919" role="tablehead" l10n="U" oldref="41">Example</paragraph> 245*b1cdbd2cSJim Jagielski </tablecell> 246*b1cdbd2cSJim Jagielski </tablerow> 247*b1cdbd2cSJim Jagielski <tablerow> 248*b1cdbd2cSJim Jagielski <tablecell> 249*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3158411" role="tablecontent" l10n="U" oldref="42">?</paragraph> 250*b1cdbd2cSJim Jagielski </tablecell> 251*b1cdbd2cSJim Jagielski <tablecell> 252*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148874" role="tablecontent" l10n="U" oldref="43">for exactly one arbitrary character</paragraph> 253*b1cdbd2cSJim Jagielski </tablecell> 254*b1cdbd2cSJim Jagielski <tablecell> 255*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150365" role="tablecontent" l10n="U" oldref="44">"?loppy" returns "Floppy"</paragraph> 256*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3166426" role="tablecontent" l10n="U" oldref="65">"M?ller" returns, for example, Miller and Moller</paragraph> 257*b1cdbd2cSJim Jagielski </tablecell> 258*b1cdbd2cSJim Jagielski </tablerow> 259*b1cdbd2cSJim Jagielski <tablerow> 260*b1cdbd2cSJim Jagielski <tablecell> 261*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3148803" role="tablecontent" l10n="U" oldref="45">*</paragraph> 262*b1cdbd2cSJim Jagielski </tablecell> 263*b1cdbd2cSJim Jagielski <tablecell> 264*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156138" role="tablecontent" l10n="U" oldref="46">for 0 or more arbitrary characters</paragraph> 265*b1cdbd2cSJim Jagielski </tablecell> 266*b1cdbd2cSJim Jagielski <tablecell> 267*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3146135" role="tablecontent" l10n="U" oldref="47">"*-*" returns "ZIP-Drive" and "CD-ROM"</paragraph> 268*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3155582" role="tablecontent" l10n="U" oldref="66">"M*er" returns all entries starting with an "M" and ending in "er" (for example, Miller, Moller, Mather)</paragraph> 269*b1cdbd2cSJim Jagielski </tablecell> 270*b1cdbd2cSJim Jagielski </tablerow> 271*b1cdbd2cSJim Jagielski </table> 272*b1cdbd2cSJim Jagielski 273*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3145762" role="paragraph" l10n="U" oldref="48">If you want to search for the actual characters ? or *, preface them with a backslash: "\?" or "\*". However, this is only necessary when <emph>Wildcard expression</emph> is enabled. When the option is not enabled, the wildcard characters are processed like normal characters.</paragraph> 274*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_REGULAR" id="bm_id3150663" localize="false"/> 275*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3147130" role="heading" level="2" l10n="U" 276*b1cdbd2cSJim Jagielski oldref="49">Regular expression</paragraph> 277*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150982" role="paragraph" l10n="U" oldref="50"><ahelp hid="HID_SEARCH_REGULAR">Searches with regular expressions.</ahelp> The same regular expressions that are supported here are also supported in the <item type="productname">%PRODUCTNAME</item> <link href="text/shared/01/02100000.xhp" name="Find & Replace dialog">Find & Replace dialog</link>.</paragraph> 278*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154718" role="paragraph" l10n="U" oldref="67">Searching with regular expressions offers more options than searching with wildcard expressions. If you search with regular expressions, the following characters correspond to those used in searches with wildcards:</paragraph> 279*b1cdbd2cSJim Jagielski <table id="tbl_id3148682"> 280*b1cdbd2cSJim Jagielski <tablerow> 281*b1cdbd2cSJim Jagielski <tablecell> 282*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153705" role="tablehead" l10n="U" oldref="68">Search with wildcard expression</paragraph> 283*b1cdbd2cSJim Jagielski </tablecell> 284*b1cdbd2cSJim Jagielski <tablecell> 285*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3149209" role="tablehead" l10n="U" oldref="69">Search with regular expressions</paragraph> 286*b1cdbd2cSJim Jagielski </tablecell> 287*b1cdbd2cSJim Jagielski </tablerow> 288*b1cdbd2cSJim Jagielski <tablerow> 289*b1cdbd2cSJim Jagielski <tablecell> 290*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151045" role="tablecontent" l10n="U" oldref="70">?</paragraph> 291*b1cdbd2cSJim Jagielski </tablecell> 292*b1cdbd2cSJim Jagielski <tablecell> 293*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150384" role="tablecontent" l10n="U" oldref="71">.</paragraph> 294*b1cdbd2cSJim Jagielski </tablecell> 295*b1cdbd2cSJim Jagielski </tablerow> 296*b1cdbd2cSJim Jagielski <tablerow> 297*b1cdbd2cSJim Jagielski <tablecell> 298*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3153793" role="tablecontent" l10n="U" oldref="72">*</paragraph> 299*b1cdbd2cSJim Jagielski </tablecell> 300*b1cdbd2cSJim Jagielski <tablecell> 301*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3150428" role="tablecontent" l10n="U" oldref="73">.*</paragraph> 302*b1cdbd2cSJim Jagielski </tablecell> 303*b1cdbd2cSJim Jagielski </tablerow> 304*b1cdbd2cSJim Jagielski </table> 305*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100100.xhp#aehnlichkeit"/> 306*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100000.xhp#halbnormaltitel"/> 307*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100000.xhp#halbnormaltext"/> 308*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100000.xhp#aehnlichtitel"/> 309*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100000.xhp#aehnlichtext"/> 310*b1cdbd2cSJim Jagielski <embed href="text/shared/01/02100000.xhp#aehnlichbutton"/> 311*b1cdbd2cSJim Jagielski <embed href="text/shared/optionen/01150200.xhp#asia"/> 312*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="hd_id3150861" role="heading" level="2" l10n="U" 313*b1cdbd2cSJim Jagielski oldref="101">State</paragraph> 314*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154477" role="paragraph" l10n="U" oldref="102">The <emph>State</emph> line shows the records returned by the search. If the search reaches the end (or the beginning) of a table, the search is automatically continued at the other end.</paragraph> 315*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3163720" role="paragraph" l10n="U" oldref="103">In very large databases, finding the record in reverse search order can take some time. In this case, the status bar informs you that the records are still being counted.</paragraph> 316*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_BTN_SEARCH" id="bm_id3149494" localize="false"/> 317*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3147389" role="heading" level="2" l10n="U" 318*b1cdbd2cSJim Jagielski oldref="51">Search / Cancel</paragraph> 319*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3154368" role="paragraph" l10n="U" oldref="52"><ahelp hid="HID_SEARCH_BTN_SEARCH" visibility="hidden">Starts or cancels the search.</ahelp> If the search is successfully completed, the corresponding field in the table is highlighted. You can continue the search by clicking the <emph>Search</emph> button again. You can cancel a search process by clicking the <emph>Cancel</emph> button.</paragraph> 320*b1cdbd2cSJim Jagielski<bookmark xml-lang="en-US" branch="hid/CUI_HID_SEARCH_BTN_CLOSE" id="bm_id3152453" localize="false"/> 321*b1cdbd2cSJim Jagielski<paragraph xml-lang="en-US" id="hd_id3145080" role="heading" level="2" l10n="U" 322*b1cdbd2cSJim Jagielski oldref="53">Close</paragraph> 323*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3156166" role="paragraph" l10n="U" oldref="54"><ahelp hid="HID_SEARCH_BTN_CLOSE">Closes the dialog. The settings of the last search will be saved until you quit <item type="productname">%PRODUCTNAME</item>.</ahelp></paragraph> 324*b1cdbd2cSJim Jagielski <paragraph xml-lang="en-US" id="par_id3151183" role="paragraph" l10n="U" oldref="104">If several tables or forms are open, you can set different search options for each document. When you close the documents only the search options of the document last closed are saved.</paragraph> 325*b1cdbd2cSJim Jagielski </body> 326*b1cdbd2cSJim Jagielski</helpdocument>