Icon edb_refresh

Refreshes the cursor and, if changes are found, the current row.

Syntax
edb_refresh(<CursorHandle>)

<CursorHandle> =

Handle of cursor returned by edb_execute function

Returns
TRUE if any changes are found to the underlying
dataset, or FALSE if there are no changes (or if there are
any errors

Usage
The edb_refresh function performs a refresh of the cursor and, if changes have been made to the underlying dataset since the cursor last accessed the underlying dataset, the current row is also refreshed and the function returns TRUE.

Warning 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, and then performs a refresh
// using the edb_refresh() function, displaying
// the result

$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_refresh($cursor))
{
  echo "Changes were found";
}
else
{
  echo "No changes were found";
}

edb_disconnect($con);
?>
Image