Icon edb_state

Indicates whether the state of a cursor.

Syntax
edb_state(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns
Cursor state (INTEGER) if successful, or
FALSE there are any errors

Usage
The edb_state function returns the state of a cursor. The state will be one of the following values (INTEGER):

StateDescription
EDB_BROWSE_STATE (0)The cursor is in a browse state
EDB_INSERT_STATE (1)The cursor is in the insert state. Calling the edb_post function will insert the current row into the underlying table, while the edb_cancel function will cancel the insert and return the cursor to the EDB_BROWSE_STATE.
EDB_UPDATE_STATE (2)The cursor is in the update state. Calling the edb_post function will update the current row in the underlying table, while the edb_cancel function will cancel the update and return the cursor to the EDB_BROWSE_STATE.

The following functions can change the state of a cursor:

edb_setfilter
edb_clearfilter
edb_locate
edb_setindex
edb_find
edb_setrange
edb_clearrange
edb_refresh
edb_insert
edb_update
edb_post
edb_cancel
edb_lock
edb_unlock
edb_unlockall

Examples
<?php

// The following script connects to an ElevateDB
// Server and database, prepares and executes a
// direct table open, begins an insert, and displays
// the state of the cursor using the edb_state() 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);

echo edb_state($cursor);

edb_disconnect($con);
?>
Image