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
  • AB
  • ÄHNLICH
  • ALLES
  • AND
  • BIS
  • COMPLETE
  • ENTHÄLT
  • esgibt()
  • FROM
  • GRÖßER
  • HAS
  • HAT
  • IN
  • IST
  • KLEINER
  • LIKE
  • NICHT
  • NOT
  • ODER
  • OR
  • sel()
  • testsel()
  • TO
  • UND
  • WIE
    Socket functions
    Statistical functions
    Stream functions
    String functions
    System functions
    Table functions
    Text functions
    Home    Overview    Search    Impressum    Contact    Members
    Topic complex Selecting
    Function esgibt()
    Short Operator of existence (out of time for EXISTS)
    Syntax ESGIBT(Selektion)
    Parameter selection : logical expression
    Return 0 : is not true
    1 : is true
    See also:
    exists() sel()
    Description At present this function only works with direct field accesses (e.g. at FINDANDMARK). It checkes if a statement (selection) is grentable for the actual record of the primary table.

    Example:

    There are two tables, BILL and ITEMS whereas the ITEMS are linked to the BILLS via a pair of keys.

    FindAndMark(BILL,'esgibt($items.total>1000)') finds all records in BILL for which at least one linked record in ITEMS exists where the field 'total' has a bigger value than 1000.

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