edb_unlock(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

TRUE if successful, and FALSE if there are any errors

 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).

<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, locks the current row in the
// cursor, updates the current row, and then unlocks
// the current row in the cursor using the edb_unlock()
// 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);

if (edb_find($cursor,array(1000)))
{
  if (edb_lock($cursor))
    {
    edb_update($cursor);
    edb_setcol($cursor,"Company","My Company 2 - Electric Boogaloo");
    if (!edb_post($cursor))
      {
      $msg = edb_errmsg();
      die("Error updating customer: " . $msg);
      }
    edb_unlock($cursor);
    }
}

edb_disconnect($con);
?>