topic Re: duplicate keys in Application Development and Automation Discussions

duplicate keys

Former Member — Sat, 03 Feb 2007 06:22:56 GMT

hai all,

i have the intarnal table which has duplicate entries .

after that by using sort function and delete duplicate entries i deleted duplicate entries

then i am usinh insert to insert the records. now it's going to short dump, its saying that they are duplicate entris..

i was unable to solve this issue.

please give me some suggessions to under stand the scenario.

how to handle duplicate entries . if possiable please send the code

thanks

laxmi

Former Member — Sat, 03 Feb 2007 06:24:41 GMT

Hi,

How did you declare your internal table..

Is it a hash table??

Please post your internal table declaration..

Thanks,

Naren

Former Member — Sat, 03 Feb 2007 06:24:57 GMT

in your insert just add accepting duplicate keys

it will not give any error but update only one value.

regards

shiba dutta

Former Member — Sat, 03 Feb 2007 06:26:05 GMT

Hi laxmi,

r u again trying to insert the already existing records into the table,plz check...

SantoshKallem — Sat, 03 Feb 2007 06:39:58 GMT

before inserting check with the key (if there is already existing)

based on that, insert the records.

Former Member — Sat, 03 Feb 2007 06:41:20 GMT

Hi,

If you are inserting the records to the database table..

Use MODIFY..If the record if there it will modify otherwise it will INSERT..

Example

DATA: T_ZTABLE TYPE TABLE OF ZTABLE.

MODIFY ZTABLE FROM TABLE T_ZTABLE.

Thanks,

Naren