1

عند حذف ملف دوام تظهر رسالة خطأ؟

عند حذف ملف دوام يظهر رسالة خطأ (لا يمكن حذف السجل حيث انه مستعمل بالحقل dbo.EmpAttendanceSysLine.shift في الجدول dbo.EmpAttendanceSysLine)

Eldabbas's avatar
9.1k
Eldabbas
asked 2018-11-27 03:40:47 +0200, updated 2018-11-27 04:27:10 +0200
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

1

لا يتم حذف "EmpAttendanceSysLine" مع حذف سند الراتب، ولكن قم بحذفه من خلال قاعدة البيانات.

Eldabbas's avatar
9.1k
Eldabbas
answered 2018-11-27 03:41:31 +0200
Ahmed Qasid's avatar
5.8k
Ahmed Qasid
updated 2018-11-29 11:17:41 +0200
edit flag offensive 0 remove flag delete link

Comments

delete from SysVacationsBalance WHERE employeeid = (select id from Employee where code = '049') delete en from VacationDetTransferLine en inner join Employee e on e.id = en.employeeid where e.code = '049' delete en from EmpAttendanceSysLine en inner join Employee e on e.id = en.employee_id where e

Ahmed Farouk's avatar Ahmed Farouk (2019-12-29 14:54:02 +0200) edit
add a comment see more comments

Your Answer

Login/Signup to Answer