any triggers in place on this table?
what is the length of the parameter? do you check it before assigning it?
Alan

> -----Original Message-----
> From: Ed Dressel [mailto:Dressel@...]
> Sent: Friday, September 24, 2004 8:39 AM
> 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
>
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Yahoo! Groups Links
>
>
>
>
>
>
>