topic Re: Insertin record in table in Application Development and Automation Discussions

Insertin record in table

Former Member — Thu, 03 Aug 2006 04:51:53 GMT

Hi,

I was inserting record in custom table, values of primary key in

work area where already present in table.

so i got short dump for entring duplicate values.

Is their any way to avoid short dump in this case so that program

should not be terminated.

Rgds,

Fattesingh

Re: Insertin record in table

Former Member — Thu, 03 Aug 2006 04:53:51 GMT

Hi fattesingh,

1. MODIFY

2. Use MODIFY statement (instead of INSERT,UPDATE etc)

3. MODIFY

will AUTOMATICALLY

take care of insert/update

based upon the

primary key combination

FOUND / NOT FOUND

in the database table,

based upon the work area fields.

regards,

amit m.

Re: Insertin record in table

ferry_lianto — Thu, 03 Aug 2006 04:54:52 GMT

Hi Fattesigh,

Please use <b>MODIFY</b> statement instead of INSERT.

It will modify the record with new values if the record already exits otherwise it will insert new record.

Hope this will help.

Regards,

Ferry Lianto

Re: Insertin record in table

Former Member — Thu, 03 Aug 2006 04:55:27 GMT

Use MODIFY statement instead of update and insert.

Re: Insertin record in table

Former Member — Thu, 03 Aug 2006 04:59:26 GMT

Hi,

Use MODIFY Statement which acts like 2 Open Sql queries (Insert and Update), if the records already exists it updates else it inserts the new record) and Regarding your case to avoid short dumps, use user-defined messages.

For Ex:

Insert zemployee.
if sy-subrc <> 0.
MESSAGE 'RECORD ALREADY EXISTS' TYPE 'S'.
ELSE.
MESSAGE 'RECORD SUCCESSFULLY CREATED' TYPE 'S'.
ENDIF.

Re: Insertin record in table

Former Member — Thu, 03 Aug 2006 05:17:14 GMT

Hi,

Use MODIFY statment instead of INSERT.

MODIFY stmt will insert the record in table only if it is not present in table else it will just update the record with new values in that workarea.

Rgds,

Prakash

Re: Insertin record in table

Former Member — Thu, 03 Aug 2006 05:24:09 GMT

hi,

I want to know how to do exception handling to avoid short dump.

coz i had checked sy-subrc after the insert

but still short dump was gifted to me.

I know modify command.

Rgds,

Fattesingh

Re: Insertin record in table

Laxmana_Appana_ — Thu, 03 Aug 2006 05:45:16 GMT

Hi,

use 'ACCEPTING DUPLICATE KEYS' with insert statement.

whenever any duplicate primary key record comes , system will modify existing records.

Ex: INSERT ztable FROM TABLE i_tab ACCEPTING DUPLICATE KEYS.

Regards

Appana