Cancels an active insert or update for a cursor, abandoning the insert or update.

Syntax

---

edb_cancel(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns

---

TRUE if successful, and FALSE if there are any errors

Usage

---

The edb_cancel function cancels an active insert or update for a cursor. Any pessimistic row locks are released, and the cursor is returned to the browse state (EDB_BROWSE_STATE).

<?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
// cancels the insert using the edb_cancel() 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");
edb_cancel($cursor);

edb_disconnect($con);
?>