Re: [firebird-support] Firebird : Arithmetic overflow exception only in execute block statement

yep ! i have noticed that after posting :p sometimes all what you have to do is to take a deep breath and take a closer look on your code ... thanks . 2018-05-05 19:44 GMT+01:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > > > On 2018-05-05

Re: [firebird-support] Firebird : Arithmetic overflow exception only in execute block statement

On 2018-05-05 19:49, Issam Boughanmi amigof...@gmail.com [firebird-support] wrote: > i have this heterogeneous cross database query > > execute block as > DECLARE panum INT; > DECLARE nom varchar(50); > DECLARE prenom varchar(50); > DECLARE dna date; > DECLARE datemodif date; > DECLARE m date; >

[firebird-support] Firebird : Arithmetic overflow exception only in execute block statement

i have this heterogeneous cross database query execute block as DECLARE panum INT; DECLARE nom varchar(50); DECLARE prenom varchar(50); DECLARE dna date; DECLARE datemodif date; DECLARE m date; DECLARE VARIABLE VSQL VARCHAR(100); begin VSQL = 'select panum, nom, prenom, dna, DATEMODIF from