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"}