DelphiFAQ Home Search:

Migration InterBase 5.5 to 6.0

 

comments3 comments. Current rating: 4 stars (1 votes). Leave comments and/ or rate it.

Question:
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:

  1. 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)

  2. 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);
You don't like the formatting? Check out SourceCoder then!

Comments:

2008-03-19, 05:18:09
anonymous from Lebanon  



Keywords:
2009-05-04, 16:11:30
[hidden] from Brazil  
rating



Keywords:
2017-01-10, 14:46:49
anonymous from Indonesia  
JIKA ANDA BUTUH ANGKA TOGEL GAIB (_SGP,HKG,MLYS,SYD,THLND,TAIWAN_)
YANG DI JAMIN 100% TEMBUS SILAHKAN
Call/Sms Di No_o82_319_2o8_865_ AKI NUGROHO
Insya Allah Beliau Akan Siap Membantu Menyelesaikan Smua Masalah Anda,.
(_..KUNCI KESUKSESAN..._)
1. Pikiran Yang Positif,
2. Keyakinan Yang Bulat
3. Percaya Bahwa Kita Akan Berhasil
.

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: