topic Re: Problem with INSERT in Application Development and Automation Discussions

Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:46:50 GMT

Hi,

I am inserting records from an internal table to a Z table, in my report.

Its working fine in development server but in production it goes to short dump and gives error discription as record already exists with the same key.

But when I check the table entries, there are no records in that Z table.

Please help me solve the problem.

Thanks,

Sai.

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:48:44 GMT

Use MODIFY instead of INSERT.

Regards

Kannaiah

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:49:42 GMT

do check the table attributes in the other server..weather the table maintanace is allowed or not..if not chenge that to allowed and that solves your problem.

regards,

babu

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:49:56 GMT

Hi,

goto SE14 save and adjust the z table and again try to insert..

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:50:58 GMT

it is better to use the UPDATE for this

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:53:00 GMT

Hi babu,

I have checked the table attributes, here the display maintanance is allowed.

Thanks,

Sai.

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 08:54:40 GMT

Use MODIFY ..

or if UR using Insert use .. the addition

ACCEPTING DUPLICATE KEYS..

Re: Problem with INSERT

former_member8532 — Fri, 11 Jul 2008 08:55:42 GMT

Hi ,

check the field that you are updating set as primary key in your table.

if it is a primary key just remove that primary key on field.

i got the same problem .

Edited by: Punit Pawar on Jul 11, 2008 11:01 AM

Re: Problem with INSERT

Former Member — Fri, 11 Jul 2008 09:02:12 GMT

I have adjusted the object, but still I get above problem.