> > Does IBO support the new IB2007 "Batched Updates"?
>
> I don't know because I have not tested it yet.

Then probably not -- this is from the docs:

The InterBase client library now contains two additional functions to
support
batch updates: One function is used for immediate batch execution. The
second
function is used for execution of prepared SQL statements containing
parameters.
With both prepared and non-prepared batch updates, the client application
must
explicitly commit or rollback changes caused by the batched SQL statements.
Batch updates will not work if auto commit mode is on.

The isc_dsql_batch_execute_immed Function
The new isc_dsql_batch_execute_immed function is used to execute a group of
INSERT,
UPDATE, DELETE or DDL commands. Its signature is:
ISC_STATUS isc_dsql_batch_execute_immed(ISC_STATUS *status_vector,
isc_db_handle *db_handle, isc_tr_handle *tr_handle, int dialect,
ULONG number_of_sql, char[] *sql, ULONG *rows_affected);


The isc_dsql_batch_execute Function
The new isc_dsql_batch_execute function supports batch updates for prepared
SQL
statements. This function allows you to batch the data used in a
parameterized
SQL statement. The signature of the function is:
ISC_STATUS isc_dsql_batch_execute(ISC_STATUS *status_vector,
isc_db_handle *db_handle, isc_tr_handle *tr_handle,
isc_stmt_handle stmt_handle, int dialect, USHORT number_of_rows,
XSQLDA *insqlda, XSQLVAR[] *batch_vars, ULONT *rows_affected);


Time to hit the books Jason ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com