Puts a cursor into the insert state and initializes the current row with any default values.

Syntax

---

edb_insert(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns

---

TRUE if successful, and FALSE if there are any errors

Usage

---

The edb_insert function puts a cursor into an insert state (EDB_INSERT_STATE), and initializes the current row with any default values defined for the underlying dataset.

<?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 using the edb_insert() function,
// sets the row values, and then completes the
// insert

$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);
?>