Subject | problem with Employee database |
---|---|
Author | Ernesto Cullen |
Post date | 2002-08-16T21:12:57Z |
Hi all
I am studying 'Employee' Database which comes with Interbase.
I have trouble when i try to update any record in table Salary_History. I know that this table is updated automatically when employee' salary changes; but i can see no reason to not be able to edit the history directly. It says: 'Validation error for column OLD_SALARY, value "0.00 ". OLD_SALARY is declared as type SALARY, which is Numeric(15,2).
Any ideas?
Ernesto Cullen
Parana - Entre Rios - Argentina
http://mcgilbert.netfirms.com
[Non-text portions of this message have been removed]
I am studying 'Employee' Database which comes with Interbase.
I have trouble when i try to update any record in table Salary_History. I know that this table is updated automatically when employee' salary changes; but i can see no reason to not be able to edit the history directly. It says: 'Validation error for column OLD_SALARY, value "0.00 ". OLD_SALARY is declared as type SALARY, which is Numeric(15,2).
Any ideas?
Ernesto Cullen
Parana - Entre Rios - Argentina
http://mcgilbert.netfirms.com
[Non-text portions of this message have been removed]