M
M
mihzas2014-04-09 18:18:28
SQL
mihzas, 2014-04-09 18:18:28

How to fix an error in an InterBase query?

insert into employee (emp_no,first_name,last_name,phone_ext,hire_date,dept_no,job_code,job_grade,job_country,salary)
values ​​(2,'sasha', 'tkachenko', '0070', '11/25/1993', '600', 'as',4,'asd',28000)
This query throws "Operation violates CHECK constraint INTEG_30 on view or table EMPLOYEE"
Data entered correctly.
What could be wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Vershinin, 2014-04-10
@mihzas

Some value is outside the INTEG_30 domain, if I understand correctly.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question