I could be wrong Ed, but i think the reason is that :Newname is more
then 100 characters



Do you also get this error when you assign a small string to :Newname
parameter?



Franky



_____

Van: Ed Dressel [mailto:Dressel@...]
Verzonden: vrijdag 24 september 2004 0:39
Aan: IBObjects@yahoogroups.com
Onderwerp: [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 Sponsor

ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1294vnlm3/M=295196.4901138.6071305.3001176/
D=groups/S=1705007183:HM/EXP=1096065558/A=2128215/R=0/SIG=10se96mf6/*htt
p:/companion.yahoo.com>


<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=475653494>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .



[Non-text portions of this message have been removed]