Hi,

> I could very well be wrong here since I am not an expert, but I don't

think

> you have a choice.

Why "no choice"?

> I have not been able to make a SP that has output variables operate

without

> "suspend and select" regardless of the number of rows in the output.

A SP without SUSPEND doesn't return rows, it returns output
parameters. With a SUSPEND, the output parameters acts as
"columns" in the output resultset. This resultset may be 0, 1 or more
rows.

> Furthermore, in my own experience any selectable SP cannot perform a
> transaction since it cannot be commited inside a transaction from the
> frontend. VB6+SIBPROVIDER will generate an error when attempted.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com