Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
What are somethings to know to Migrate InterBase 5.5 to 6.0 Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
Migration InterBase 5.5 to 6.0 25-Aug-02
Category
Database Others
Language
Delphi 2.x
Views
58
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Tomas Rutkauskas 

A certain stored procedure caused me to get this error message:

ISC ERROR CODE: 335544321

ISC ERROR MESSAGE:
arithmetic exception, numeric overflow, or string truncation

Answer:

I found that a variable of type char(18) was assigned to another variable of type 
char(10). Since the data was never (?) longer than 8 characters, this worked fine 
up to version 5.5. Seems that IB 6.0 handles strings different. It is likely that a 
delcaration as VARCHAR instead of CHAR would help also. (See part 1 below)

Another necessary change was a type cast where IB 5.5 did an implicit conversion.


// part 1
declare variable v1 char(10);
declare variable v2 char(18);
..
v1 = v2; // generates the error in IB 6.0

// part 2
declare variable vchardate char(18);
declare variable vdatedate date;

vchardate = '1996-Jan-15';
vdatedate = vchardate; // generates error in IB 6.0

vdatedate = cast(vchardate as DATE);

			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC