Deutsch English Alphabetical index Array functions CGI functions Data types Date functions Debugging Fulltext functions Language elements Numerical functions Operators Other functions Ramtext functions Selecting Socket functions Statistical functions Stream functions String functions System functions Table functions access() andmarks() autofield() autorecno() blobsize() blobtype() cleardat() closedb() copyblob() copymemo() dbdir() dbname() dbno() dbrights() deldb() delindex() delmark() delmarkedrecords() delmarks() delrec() editoff() editon() embedblob() exists() fields() filemode() fileno() filesize() findandmark() findauto() findrec() firstmark() firstrec() flushdb() fsum() genindex() getcode() getdef() getfield() getmarks() getmode() getpw() getrec() getrfield() getstructure() gettype() incrfield() inddef() indname() indno() ismark() label() labelno() lastrec() link() linkblob() linkinfo() lock() makedb() markdoubles() markindex() markpattern() maxfile() maxlabel() memolen() memostr() newtable() nextmark() nextrec() nmarks() opendb() prevrec() primfile() primtable() putmarks() putrec() readmemo() readrec() recno() recno() recnr() regenall() regenind() relation() rendb() reopendb() revmarks() setalias() setauto() setfield() setfields() setfilter() setmark() setmarks() setrecord() setrfield() sortmark() treeinfo() unlock() writerec() Text functions	Home    Overview    Search    Impressum    Contact    Members Topic complex Table functions Function findrec() Short Searches a record via an index Syntax FindRec(db : INTEGER; SearchStr : STRING [;Index[;Mode : INTEGER]]) : INTEGER Parameter db : table handle from OpenDB SearchStr : searched information index : index name or index number(>=0) Mode : 0 (default) -> search for entry >= SearchStr; 1 -> search for entry = SearchStr Return 0 -> no record found, else recno(db) See also: firstrec() nextrec() lastrec() prevrec() Description SearchStr has to be build adequate to the index description. Includes the component a comma it has to be clasped. Examples: index-desciption ="Name,Forename,Town" SearchStr = "Schwalm,Till,Munich", "Lichtenberg,Franz,(Munich,Moosach)" Are all information fetched by the user a parenthesis of all components is useful: SearchStr:='('+s_Name+'),('+s_Forename+'),('+s_Town+')' Is no index specified it is searched in the actual (via access justified) index . Points the access not to an index (but to a a number or mark) the error message "Illegal access" happens. With mode 0 the smallest entry (with reference to the index order) is searched which is equal or bigger than the searched one. Is there no entry the biggest entry is searched which is equal or smaller than the searched one. Thus in this mode 0 is only returned if the table is completely empty. However in mode 1 a value unequal 0 is only returned if an entry is found which accords in all components with the search. User comments: Write a comment: Name EMail Subject Text (Switch mode) Choose between the normal and the advanced editor. The advanced editor runs in IE 5+ and Mozilla 1.4+ only SPAM-Protection Please enter tdbengine in this field.
tdbengine chat irc.tdbengine.org #tdbengine	Copyright © 2003-2004 tdb Software Service GmbH    Alle rechte vorbehalten. / All rights reserved    Last changed: 21.10.2004	{Fehler für :execmacro{execmacro="sessionspy"}