topic Re: data base table duplicate keys in Application Development and Automation Discussions

data base table duplicate keys

Former Member — Mon, 07 Aug 2006 06:57:19 GMT

Hi,

What happens when you try to insert duplicate records in a database table:a. One record at a timeb. From an internal table

Re: data base table duplicate keys

Former Member — Mon, 07 Aug 2006 06:58:44 GMT

hi,

Obviously you get a short dump(Runtime error) saying Duplicate entries.

Regards:-

Santosh

Re: data base table duplicate keys

Former Member — Mon, 07 Aug 2006 06:59:54 GMT

Hi sai,

1. The program will give error.

2. First the database gives error,

it reports to the r/3 system,

and then the r/3 system, gives a short dump.

3. As soon as the duplicate record is

being tried to inserted,

the error occurs.

4. Instead of using INSERT command,

we can use MODIFY statement.

5. MODIFY statement will AUTOMATICALLY

insert/update the records

based upon the primary key combination value

found/ not found in database.

regards,

amit m.

Re: data base table duplicate keys

athavanraja — Mon, 07 Aug 2006 07:49:55 GMT

Just to add one more point to Amit's reply.

if you use the addition "ACCEPTING DUPLICATE KEYS" along with INSERT you can avoid the dump. if a duplicate key is found the system will just ignore the entry.

Regards

Raja