I bump into this every so often.
Trace your triggers, etc.

Jason Wharton

-----Original Message-----
From: Ed Dressel [mailto:Dressel@...]
Sent: Thursday, September 23, 2004 3:39 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] update... gives exception


A pretty simple update:

(Generic) DB 1% Crediting, with catch-up

Update PensionPlans set PlanName = :NewName where PensionPlan_ID
= :ID

where I assign teh two params and get the following exception:

---------------------------
ISC ERROR CODE:335544321
ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation
STATEMENT:
TIBOInternalDataset: "<TIBOQuery>.<TIBOInternalDataset>."
---------------------------

the PlanName field is varchar(100) so it should be fine. Any
suggestions?

Thanks
Ed Dressel