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?


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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.