2007 Mar 19 3:42 AM
hi experts,
i m inserting the data into my customized database table with the help of table control.for deletion purpose i m using sino field in my database table..what i want is without inserting sino in the table control (o/p screen) the database table will automatically
take the sino depending upon the row insertion.what logic sud i use in pbo or pai to get the sino in database table..plz help me .its urgent.if possible plz send me the code related to this scenario.
thnx in advance.
2007 Mar 19 3:52 AM
Hi Ravi
You can use number range for automatically generation of sequence no.
The transcation is SNRO.
I don't know whether it is the answer to ur question.
Naresh
hi experts,
i m inserting the data into my customized database table with the help of table control.for deletion purpose i m using sino field in my database table..what i want is without inserting sino in the table control (o/p screen) the database table will automatically
take the sino depending upon the row insertion.what logic sud i use in pbo or pai to get the sino in database table..plz help me .its urgent.if possible plz send me the code related to this scenario.
thnx in advance.
2007 Mar 19 3:52 AM
Hi Ravi
You can use number range for automatically generation of sequence no.
The transcation is SNRO.
I don't know whether it is the answer to ur question.
Naresh
2007 Mar 19 3:59 AM
2007 Mar 19 4:19 AM
Using SNRO , you can create a number range object and define the range for your number range
then you can use function NUMBER_GET_NEXT
it will get you the next number and that you can display in your table control
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |