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 setfilter()
    Short Sets a filter to an active index
    Syntax SetFilter(db : INTEGER; von [, bis] : STRING[; mark : INTEGER]) : INTEGER
    Parameter db : table handle from OpenDB
    from, to : index information according to index description
    Return always 0
    See also:
    genindex() access() firstrec() nextrec()
    Description SetFilter is only effective if the access has been set to an index, so only after access(db,...).

    A filter is active until

    it is unmade with SetFilter(db,''), or
    the primary table is changed.

    If a filter is active, FirstRec executes a FindRec(db,from), but returns only a value if the found record is greater or equal to the content of "from". LastRec works the same way. NextRec resp PrevRec only returns results if the found values are in the stretched area. Also SUB returns only records from this area.

    Der Parameter bis kann nur weggelassen werden, wenn die zugehörige Indexbeschreibung ausschließlich String-Felder enthält:
    The parameter "to" can only be left, if he according index description includes exclusively string fields:

    SetFilter(db,from) is an abbreviation for SetFilter(db,from,from+chr(255)).

    With an hierarchic index not defined components at "from" are filled with the smallest possible value, at "to" with the largest one.

    User comments:
    schnelle Markierunktion mit SetFitler
    User: hgtdbDate: 13.03.2007 08:01#2649

    PROCEDURE mark_filter(db : INTEGER; suchbegriff, index : STRING) : INTEGER
    VAR x : INTEGER; m : TBITS[]
    access(db,index)
    setfilter(db,suchbegriff)
    InitArray(m[FileSIze(db)])
    x:=firstrec(db)
    WHILE x DO
    m[x]:=1
    x:=nextrec(db)
    END
    PutMarks(db,m)
    RETURN nmarks(db)
    EndProc
    PROCEDURE mark_filter mit Übergabeparameter cBis erweitern
    User: Lars HübnerDate: 22.03.2007 14:30#2652
    Der Procedure mark_filter fehlt noch ein Parameter cBis.
    Wenn man in Integer-Indexen sucht, benötigt der Befehl setfielter noch den cBis Parameter.

    mfg Lars Hübner
    AChtung: Setfilter kann jetzt optional soofrt markieren!
    User: hgDate: 18.04.2008 08:59#2668
    damit entfällt das SetMArk in einer Schleife
    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"}