MVSFORUMS.com

[sushil]

Hi,

I want to do the following,
Lets the table entries are as follows:

1A 1 x y z ....
1A 2 x y z ....
1A 3 x y z ....
1A 4 x y z ....
1A 5 x y z ....
2A 1 x y z ....
2A 2 x y z ....
3A 1 x y z ....

If I delete row # 3 then is it posible some way (without updating each row separately) to get following result,

1A 1 x y z ....
1A 2 x y z ....
1A 3 x y z ....
1A 4 x y z ....
2A 1 x y z ....
2A 2 x y z ....
3A 1 x y z ....

Thanks for all your help
_________________
"Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity."

[sushil]

Just to add, 1A 2A 3A are all part of key, whereas x,y , z are any values
_________________
"Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity."

[dbzTHEdinosauer]

use a delete trigger.
_________________
Dick Brenholtz
American living in Varel, Germany