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 findandmark()
    Short Marks a selection
    Syntax FINDANDMARK(db : INTEGER; Selektion : STRING [;Multiexpression : STRING]) : INTEGER
    Parameter db : table handle from OpenDB
    Selection : selection as STRING
    Multiexpression : String, that includes any expressions (sererated by ";")
    Return <0 error
    >=0 number of the marked records
    See also:
    Description In the marking list of the table handle all record numbers are included that match with the selection.
    Multiexpression is a string in the form "expression; expression; ...".
    The single expressions are calculated for every found record. As well in the selection as in the multiexpression the field notation [table_name.]field can be used.

    Example:

    VAR x : REAL
    FINDANDMARK(db,'income<250000','x:=MEAN(income)')

    Thereby a table (with the handle db) is searched for all records where the field 'income' has an higher value than 250000. After executing the function the searched records are in the marking list and x is the avarage value of the field 'income' of these records.

    The return value of the function is negative if an error has occured (in the selection or in a multiexpression). Otherwise the number of found records is returned (so NMARKS(db)).

    User comments:
    FindAndMark nach einer Filter Anweisung führt zu Endlosschleife
    User: Hermann Götz / TDB SupportDate: #4592
    Wird vor dem FindAndMark eine setFilter Anweisung ausgeführt, so hat die Auswirkungen auf das Ergebnis der Suche. Im WorstCase Fall führt eine setFilter Anweisung ohne Treffermenge dazu, dass sich der Prozess aufhängt. Lösung: Heben Sie daher sicherheitshalber die setFilter Anweisung auf oder setzen Sie mit Access den Index neu.
    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"}