Posts an active insert or update for a cursor, completing the insert or update.

Syntax

---

edb_post(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns

---

TRUE if successful, and FALSE if there are any errors

Usage

---

The edb_post function posts an active insert or update for a cursor. If there are no errors, such as constraint errors, then the insert or update is considered complete, any pessimistic row locks are released, and the cursor is returned to the browse state (EDB_BROWSE_STATE). If the cursor's parent connection is using optimistic row locking, then the current row will not be locked until this function executes.

<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, puts the cursor into an
// insert state, sets the row values, and then
// completes the insert with the edb_post() 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_insert($cursor);
edb_setcol($cursor,"CustNo",1000);
edb_setcol($cursor,"Company","My Company");
if (!edb_post($cursor))
  {
  $msg = edb_errmsg();
  die("Error adding customer: " . $msg);
  }

edb_disconnect($con);
?>