No, there is not a trigger. You say than the error is referred to another part (with mistaken value) of the entire script... but the compiler reports me the part that (maybe) run ok?!? How this is possible?
Ok, print the script and study it. Antonio Bianca Il 04/04/2020 10:57, Mark Rotteveel [email protected] [firebird-support] ha scritto: > > On 04-04-2020 10:49, 'Stellarancia.com' [email protected] > [firebird-support] wrote: > > He, > > I've an error that I don't undestrand. > > I use Delphi 7 environment to create my applications, Zeos components > > for connections and Firebird 2.5 Superserver for database management. > > To register the data, my App uses the processor component; the > > Connection.Autocommit parameter is set to False. > > My App inserts numerous lines of data to be recorded in the Process > > component (with Process.Script.Add('...') -> 'UPDATE XY SET...'; INSERT > > INTO ZXD...'; UPDATE FGH SET ...'; and so on); > > at the end, it adds the command "COMMIT;", then call "PARSE", and > "EXECUTE". > > The lines 4 and 5 of the processor script contains the data mistaken, > > but I don't undestand where is the eror. > > The exception raised by the server is: > > ----------- > > > > SQL Error: conversion error from string "". Error Code: -413. Overflow > > occurred during data type conversion. > > The SQL: INSERT INTO ANA_DIPE_PRESORD (COD_REC, MATR, DATORE, POSIZ, > > MESE, ANNO) > > VALUES (30030003004601, 3, 46, 1, 03, 2020) > > ; > > > > ---------- > > This is the table declaration: > > ---------- > Do you have a trigger on the table? Given the STATO column has a default > of '', maybe a trigger tries to convert that to a number somewhere? > > Also, are you absolutely sure this is the statement that causes the > problem. Your trying to execute a script, which Firebird itself does not > support, so your component is doing some transformations, which might > mean that the error is not on the line that you think it is. Try > executing a single statement instead of a script. > > I'd recommend trying to reproduce it in ISQL, and if possible provide us > with a minimum reproducible example > > Mark > -- > Mark Rotteveel > >
