Icon edb_setindex

Sets the active index for a cursor.

Syntax
edb_getindex(<CursorHandle>, <IndexName>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<IndexName> = Name of index to make the active index order

Returns
TRUE if successful, or FALSE if there are any errors

Usage
The edb_setindex function sets the active index for a cursor. This function can only be used with cursors on directly-opened tables. Please see the edb_prepare function for more information on opening tables directly.

Warning If the cursor state, retrievable via the edb_state function, is an insert state (EDB_INSERT_STATE) or update state (EDB_UPDATE_STATE), then this function will cause an automatic call to the edb_post function in order to force the cursor into a browse state (EDB_BROWSE_STATE).

Examples
<?php

// The following script connects to an ElevateDB
// Server and database, prepares a direct table
// open, sets the active index using the edb_setindex()
// function, and then displays the active index

$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_setindex($cursor,"ByCompany");
echo edb_getindex($cursor);

edb_disconnect($con);
?>
Image