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

Re: [firebird-support] What regular maintenance actions does Firebird need in order to function properly?

So, these are the maintenance actions that I am going to perform every night(I have a gap between 1am and 7 am):  - In the main server - Backup using gbak.  - Restart o of the database to get rid of long transactions - Sweep. - In the backup server - Restore of