topic inserting in DB in Application Development and Automation Discussions

inserting in DB

Former Member — Tue, 22 Apr 2008 13:27:44 GMT

Hi,

I have five tables..From the screen i was gathering the values for this 5 tables.There is a key value which is common for all the tables..

I was using select max( key_field) from table and getting the maximum value and incrementing tht value to generate dynamic key value..

Ita working fine..Now when 4-5 members try to give submit at the same time means its throwing problem..becoz of id generation..

So is there any other way like syncronzation in SAP..any way there means plz tell me

Former Member — Tue, 22 Apr 2008 13:30:40 GMT

hi,

I would use number range object (using transaction SNRO) to create a number range.

in programm I would use Funktion


NUMBER_GET_NEXT

to get the next free number from object

regards

Matthias