No problem, found it quite a ways up :)
It excuted the same prepared statement
many times, before it choked.

Hans

====================================================================

PREPARE STATEMENT
TR_HANDLE = 4
STMT_HANDLE = 184

SELECT
M.RDB$RELATION_NAME,
M.RDB$CONSTRAINT_TYPE,
M.RDB$INDEX_NAME,
RC.RDB$CONST_NAME_UQ,
RC.RDB$UPDATE_RULE,
RC.RDB$DELETE_RULE,
(SELECT MAX(CC.RDB$TRIGGER_NAME) FROM RDB$CHECK_CONSTRAINTS CC
WHERE M.RDB$CONSTRAINT_NAME = CC.RDB$CONSTRAINT_NAME)
AS TRIGGERorFIELD_NAME,
RCUQ.RDB$RELATION_NAME AS RDB$RELATION_UQ,
IDXF.RDB$RELATION_NAME AS RDB$FOREIGN_TABLE,
IDX.RDB$FOREIGN_KEY AS RDB$FOREIGN_INDEX
FROM RDB$RELATION_CONSTRAINTS M
LEFT JOIN RDB$REF_CONSTRAINTS RC
ON M.RDB$CONSTRAINT_NAME = RC.RDB$CONSTRAINT_NAME
LEFT JOIN RDB$RELATION_CONSTRAINTS RCUQ
ON RC.RDB$CONST_NAME_UQ = RCUQ.RDB$CONSTRAINT_NAME
LEFT JOIN RDB$INDICES IDX
ON IDX.RDB$INDEX_NAME = M.RDB$INDEX_NAME
LEFT JOIN RDB$INDICES IDXF
ON IDXF.RDB$INDEX_NAME = IDX.RDB$FOREIGN_KEY
WHERE M.RDB$CONSTRAINT_NAME=? /* ENTITY_NAME */

PLAN (CC INDEX (RDB$INDEX_14))
PLAN JOIN (JOIN (JOIN (JOIN (M INDEX (RDB$INDEX_12), RC INDEX
(RDB$INDEX_13)), RCUQ INDEX (RDB$INDEX_12)), IDX INDEX (RDB$INDEX_5)), IDXF
INDEX (RDB$INDEX_5))

FIELDS = [ Version 1 SQLd 10 SQLn 30
RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME = <NIL>
RDB$RELATION_CONSTRAINTS.RDB$CONSTRAINT_TYPE = <NIL>
RDB$RELATION_CONSTRAINTS.RDB$INDEX_NAME = <NIL>
RDB$REF_CONSTRAINTS.RDB$CONST_NAME_UQ = <NIL>
RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE[RDB$UPDATE_RULE] = <NIL>
RDB$REF_CONSTRAINTS.RDB$DELETE_RULE = <NIL>
[TRIGGERORFIELD_NAME] = <NIL>
RDB$RELATION_CONSTRAINTS.RDB$RELATION_NAME[RDB$RELATION_UQ] = <NIL>
RDB$INDICES.RDB$RELATION_NAME[RDB$FOREIGN_TABLE] = <NIL>
RDB$INDICES.RDB$FOREIGN_KEY[RDB$FOREIGN_INDEX] = <NIL> ]
----*/

> Please include the statement handle 184 item when it was last prepared so
> we
> know what actual statement failed.
>
> Jason
>
>>
>> Monitor Output when extracting Meta Data
>> =============================
>>
>> /*---
>> EXECUTE STATEMENT
>> TR_HANDLE = 4
>> STMT_HANDLE = 184
>> PARAMS = [ Version 1 SQLd 1 SQLn 1
>> [ENTITY_NAME] = 'INTEG_6 ' ]
>> ----*/
>> /*---
>> INTERPRET BUFFER =
>> ERRCODE = 60
>> ----*/
>> /*---
>> INTERPRET BUFFER = arithmetic exception, numeric overflow, or string
>> truncation
>> ERRCODE = -1
>> ----*/
>>
>> Table Source
>> =========
>>
>> CREATE TABLE DRIVERS (
>> HOUSE_UNIQUENUM INTEGER NOT NULL
>> <== INTEG_5
>> , DRIVER_UNIQUENUM INTEGER NOT NULL
>> <== INTEG_6
>> ***
>> , DRIVER_NAME VARCHAR( 12 )
>>
>> IB_SQL_IBO_4_7_Beta11a seems to choke on INTEG_6.
>> All the _UNIQUENUM's are filled by a simple generator in
>> before insert
>> trigger.
>>
>> Hans
>