Database Triggers (merged) [message #346444] |
Mon, 08 September 2008 10:32  |
sridharvv
Messages: 3 Registered: September 2008
|
Junior Member |
|
|
Hi
I need help to create DB trigger. I need to maintain different versions when I update records through database.
For each financial year I will be having 12 records. If I update one or more than one record for that particular year then the updated records as well as non updated records should go into audit table and the sequence for those 12 records should be unique.
Thanks
|
|
|
|
|
DB Triggers [message #346453 is a reply to message #346444] |
Mon, 08 September 2008 10:49   |
sridharvv
Messages: 3 Registered: September 2008
|
Junior Member |
|
|
Hi
I need help to create DB trigger. I need to maintain different versions when I update records through database.
For each financial year I will be having 12 records. If I update one or more than one record for that particular year then the updated records as well as non updated records should go into audit table and the sequence for those 12 records should have same number.
Thanks
|
|
|
|
Re: DB Triggers [message #346455 is a reply to message #346453] |
Mon, 08 September 2008 10:56  |
sridharvv
Messages: 3 Registered: September 2008
|
Junior Member |
|
|
In my first post I mentioned seq should be unqique. In fact should have same seq for that 12 records.
exampe
2008 1 1
2008 2 1
2008 3 1
2008 4 1
2008 5 1
2008 6 1
........
2008 12 1
2008 1 2
2008 2 2
2008 3 2
2008 4 2
2008 5 2
2008 6 2
........
2008 12 2
|
|
|