0

Hi,

Actually I don't know if my question belongs in this topic or in the VB.net topic.
But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application.

I have a table with reservations and a table with consumptions. So when a reservation is paid, the trigger has to delete all the consumption from that reservations automaticly.

Can someone help me with this?

Thanks

2
Contributors
1
Reply
4
Views
6 Years
Discussion Span
Last Post by pritaeas
0

A trigger is something that works at the server side. If you write an update trigger to detect when a reservation is paid (for example setting a paid flag), then it will do what you tell it to. There is no need to call something from your code.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.