Hi Jason,

I'm trying the following:
INSERT INTO CUSTOMERS
(
COMPANY_NAME,
CONTACT_FIRSTNAME,
CONTACT_LASTNAME,
CONTACT_MIDDLENAME
)
VALUES
(
'' /*COMPANY_NAME*/,
'' /*CONTACT_FIRSTNAME*/,
'' /*CONTACT_LASTNAME*/,
'' /*CONTACT_MIDDLENAME*/
)
returning custid

where CUSTID is being filled by a BEFORE INSERT trigger. When I run
this statement (prepare, then run), IBO returns a "parameter" for "custid".

Isn't it supposed to return a resultset with a single row?

For "statement type", IBO returns "ExecProcedure".

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