Skip to Content
0
Former Member
Oct 12, 2006 at 09:31 AM

updating particular field

18 Views

Hai,

my requirement in a table totally 20 records are there, the table like this

Table: ZGT1C

SNO TYPE LOCATION YEAR COUNTER

1 IN CH 2006 0

2 IN BG 2006 0

3 OUT CH 2006 0

4 OUT BG 2006 O

UP TO YEAR 2010 LIKE THIS WAY.

IF SNO = 1 AND TYPE = IN AND YEAR = 2006

I INCREMENT THAT COUNTER ONLY

If IT IS SNO = 3 AND TYPE = OUT AND YEAR = 2006

I INCREMENT THAT COUNTER ONLY .

PLZ SEND THIS LOGIC AS ERALY AS POSSIBLE.

regrads,

satyapalli