He, Mark, You are reason!!!! (as always *_*)
I've made many changes in the source code, but the result is not changed.
After checking the default values for all the fileds in the table, I've
discovered that many fields of type smallint have a default setted to
'' (char void) rather then 0 (zero)... what a stupid!!!
The error is referred to fields not inserted in the comand line INSERT, for
which Firebird has considered the default '' rather then 0.
Thanks for interest. More attention from me would not have made lose 4 days
to me and precious time to you.
Best regards.
Antonio BIANCA
- - - - - - - - -
Il 04/04/2020 10:57, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] ha scritto:
>
> On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia..com
> [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)
> > ;
> > ----------
> - - - - - - - - - - - - - - - - - -
> 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
>
>
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
