Sets the column values for the current row in a cursor using an associative array.

Syntax

---

edb_setrow(<CursorHandle>, <Values>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

<Values> = Associative array of column names and values

Returns

---

TRUE if successful, or FALSE if there are any errors

Usage

---

The edb_setrow function sets the column values for the current row in a cursor using an associative array of column names (as the keys) along with the column values.


Examples

---

<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, updates the first row, sets
// the column value using the edb_setrow()
// function, and then posts the updates

$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_update($cursor);
edb_setrow($cursor,array("State"=>"NY"));
edb_post($cursor);

edb_disconnect($con);
?>