Sets a filter on a cursor.

Syntax

---

edb_setfilter(<CursorHandle>, <Filter>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<Filter> = Any valid Boolean SQL expression

Returns

---

TRUE if successful, or FALSE if there are any errors

Usage

---

The edb_setfilter function sets a filter on the specified cursor. A filter may be any valid SQL expression that can normally be used in a SELECT statement's WHERE clause, which is any valid SQL expression that evaluates to a Boolean true or false.


A filter can be cleared by using the edb_clearfilter function.

<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, and sets a filter using the
// edb_setfilter() function

$con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+
                   "uid=Administrator;pwd=EDBDefault;database=Test");
if (!$con)
  {
  die("Could not connect: " . edb_errmsg());
  }

$cmd = edb_prepare($con,"customer",EDB_COMMAND_TABLE);
$cursor = edb_execute($cmd);

edb_setfilter($cursor,"State='FL'");

edb_disconnect($con);
?>