Hi,
I created a table with a numeric non null field. Afterwards I
realized that it could be a calculated field, so I dropped the field and
recreated it accordingly.
Before:
NETO CURRENCY NOT NULL,
IVA CURRENCY NOT NULL,
TOTAL CURRENCY NOT NULL
After:
NETO CURRENCY NOT NULL,
IVA CURRENCY NOT NULL,
TOTAL COMPUTED BY (NETO + IVA)
( Being CURRENCY a domain NUMERIC(18,2) )
Then I tried to insert a record in the table using a stored procedure,
but the insertion failed giving the following strange message :
"validation error for column *** unknown ***, value "*** null ***"
Then I tried to insert the record directly in the table, using no stored
procedure, but I got the same result.
I guess that the "unknown" column has to do with the dropped and
recreated TOTAL field, and something remainend in memory related to its
non null constraint.
I dropped and recreated the stored procedure, and then error
dissapeared. I can insert records with no problem now.
For security, I restarted Firebird and checked the database using gfix
validate. No errors were shown.
Does anyone have any idea of what produced such a strange error ?
Thanks in advance,
Aldo Caruso
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
