1

Topic: The trigger!!!

. The help is necessary:
I need to write the trigger which forbids removal from financial tables of a database.
It is necessary to forbid removal of records from table Payments which status is equal it (is stated)
I will be very grateful

2

Re: The trigger!!!

romanpierce wrote:

Zdrastvujte. The help is necessary:
I need to write the trigger which forbids removal from financial tables of a database.
It is necessary to forbid removal of records from table Payments which status is equal it (is stated)
I will be very grateful

And what your variant?

3

Re: The trigger!!!

romanpierce;
example B

4

Re: The trigger!!!

alexeyvg;
I not so well understand that such the trigger. To me gave such task. Most not to solve (

5

Re: The trigger!!!

romanpierce wrote:

alexeyvg;
I not so well understand that such the trigger. To me gave such task. Most not to solve (

the Trigger is the procedure launched at performance of a command on which it is assigned. In the trigger it is possible to do any actions as in normal procedure, thus it is possible to get access to changed by a command of the data, using pseudo-tables inserted and deleted.
Sm the link, which to you a distance.
If you do not want or cannot generally that that to make, ask colleagues of students or search for paid services.

6

Re: The trigger!!!

romanpierce wrote:

alexeyvg;
I not so well understand that such the trigger. To me gave such task. Most not to solve (

Section operation in other branch