inserting in DB

[Former Member]

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]

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