AnsweredAssumed Answered

Increment record-vise in table

Question asked by santhosh.gandikota1221 on Sep 13, 2016
Latest reply on Sep 13, 2016 by santhosh.gandikota1221

 

Hi All,

 

 

<records>
<record>
<T1_ID>1</T1_ID>
<NAME>
<NAME1>SA1</NAME1>

<NAME1>BA1</NAME1>
</NAME>
</record>
<record>
<T1_ID>2</T1_ID>
<NAME>
<NAME1>GA1</NAME1>

<NAME1>HA1</NAME1>
</NAME>
</record>
<record>
<T1_ID>3</T1_ID>
<NAME>
<NAME1>PA1</NAME1>
</NAME>
</record>
</records>

 

i 'm trying to insert above data to database.In database side increment need to be done at record level.

 

for example: for the 1st record 

i.e, 

<record>
<T1_ID>1</T1_ID>
<NAME>
<NAME1>SA1</NAME1>

<NAME1>BA1</NAME1>
</NAME>
</record>

it need to be 1 and 2 and for the 2nd record

i.e, 

<record>
<T1_ID>2</T1_ID>
<NAME>
<NAME1>GA1</NAME1>

<NAME1>HA1</NAME1>
</NAME>
</record>

it should be 1 and 2 again.i'm using Line Increment function but it is increasing like 1,2,3,4......

 

any suggestion please???

 

Regards,

Santhosh

Outcomes