Sets a range on a cursor, using the active index.

Syntax

---

edb_setrange(<CursorHandle>,
            <BeginRangeValues>,
            <EndRangeValues>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<BeginRangeValues> = Simple array of values, corresponding
to the indexed columns in the active index

<EndRangeValues> = Simple array of values, corresponding
to the indexed columns in the active index

Returns

---

TRUE if successful, or FALSE if there are any errors

Usage

---

The edb_setrange function sets a range on the specified cursor, using the active index. A range is simply a pair of beginning and ending key values that limit the rows in a cursor to those whose index key values match fall within them (inclusive).


A range can be cleared by using the edb_clearrange function.

<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, sets a range using the
// edb_setrange() function, and then displays
// the row count

$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_setrange($cursor,array(1000,3000));

echo edb_rowcount($cursor);

edb_disconnect($con);
?>