From Ingres Community Wiki

Introduction

Unbuffered query execution allows a developer to execute a query without its rows being buffered. Typically used for INSERT/UPDATE/DELETE statements where there is no row-set to return. It can also be used with SELECT statements, however only a single statement can be open at a time. This function is similar to the way the Ingres PHP driver use to work prior having support for multiple-result sets.

Feature ideas

Batch Parameters

One possible feature is the ability to supply a batch of parameters (nested array in PHP terms) for submission. Which would convert this:

$params = array(1,'Grant', 'Croker');
$rc = ingres_unbuffered_query($link, $query, $params);
$params = array(2,'Matt', 'Berg');
$rc = ingres_unbuffered_query($link, $query, $params);

into

//Generate a nested array
$params[] = array(1,'Grant', 'Croker');
$params[] = array(2,'Matt', 'Berg');
$params[] = array(3,'The', 'Librarian');
$params[] = array(4,'Ponder', 'Stibbons');
$rc = ingres_unbuffered_query($link, $query, $params);

or could take a set of values returned by ingres_fetch_row() or ingres_fetch_array().

Project Profile