Hi Jason,

When executing the following statement in a TIBOQuery where
"ParamCheck = True", is this supposed to work?

CREATE OR ALTER TRIGGER TRI_LOG_ON_DISCONNECT
ACTIVE ON DISCONNECT POSITION 32767
AS
DECLARE VARIABLE VAR_ID NUMERIC(18,0);
DECLARE VARIABLE USER_NAME VARCHAR(31);
BEGIN
BEGIN
USER_NAME = USER;
EXECUTE PROCEDURE P_INSERTINTOIBLM$OPERATIONLOG (:USER_NAME,
'IBLM$DATABASE_DISCONNECT', 'DISCON', NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, CURRENT_TRANSACTION, rdb$get_context('SYSTEM',
'CLIENT_ADDRESS'), rdb$get_context('SYSTEM', 'NETWORK_PROTOCOL'),
rdb$get_context('SYSTEM', 'DB_NAME'), rdb$get_context('SYSTEM',
'ISOLATION_LEVEL')) RETURNING_VALUES :VAR_ID;

/* note, there is :VAR_ID in the above line */

WHEN ANY DO
VAR_ID = -1;
END
END

I'm first doing a Prepare. Should IBO try to create params even though
it's a DDL statement?

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