PL/SQL compilation syntax error for trigger

I have been trying to find the solution to my error in my sql query for a while and can’t seem to find the cause/don’t understand the error. I’m trying to create a trigger that updates the primary key of a table if one of the main values gets updates (sexe and anneenais(anneenais is year… Read More PL/SQL compilation syntax error for trigger

In C# How can I get a event from MySQL when somebody Insert, Delete or Modify a record?

I am developing a program in WPF.Net, and I need to know when somebody makes a change over any table of the database. The idea is receive a event from the database when it was changed. I was reading a lot of articles but I can’t find a method to resolve my problem. Kind Regards… Read More In C# How can I get a event from MySQL when somebody Insert, Delete or Modify a record?

Trigger not firing for instead of insert sql server

I am trying to create a trigger to convert a value from varchar to varbinary. The creation of the trigger is successful. However it is not firing against an insert query. CODE FOR TRIGGER USE VacationManager; GO CREATE TRIGGER HashPassword ON Users INSTEAD OF INSERT AS BEGIN SET NOCOUNT ON; INSERT INTO Users(Username,[Password],FirstName,LastName,RoleID) SELECT i.Username,… Read More Trigger not firing for instead of insert sql server

How to check if the id of one table is exists in another table using triggers in SQL Server?

I have created this trigger but when I am trying to insert or update the record this code is not working properly.For example, when I am trying to insert record into order table with customer id thats is not exists in customer table, then its showing me message ‘Yes’ instead of ‘No’. Just need you… Read More How to check if the id of one table is exists in another table using triggers in SQL Server?

Trigger fails with ORA-01858: a non-numeric character was found where a numeric was expected

I am trying to create a trigger on a table (TABLE_1) which detects if a column (ENTERED_DATE) has been changed then update another table (TABLE_2) to set the column (ENTRY_DATE) to the newly changed date on TABLE_1. Here’s what I have: create or replace trigger TRG_NAME after insert or update or delete on TABLE_1 for… Read More Trigger fails with ORA-01858: a non-numeric character was found where a numeric was expected