topic Re: Update problem in Application Development and Automation Discussions

Update problem

Former Member — Thu, 22 Nov 2007 09:55:29 GMT

Hi guys,

I am trying to do a mass update on database table from an internal table. the syntax i have used is......

update db_tab from table it_tab.

The problem is it is just updating the 1st row of the database table whereas in the internal table there are 100 entries.

Do help me out on this.

Thanks and regards,

frank.

Re: Update problem

former_member404244 — Thu, 22 Nov 2007 09:58:51 GMT

Hi,

check that both the database table and the internal are of same structure...

also use commit work after the update statement.

Regards,

Nagaraj

Re: Update problem

Former Member — Thu, 22 Nov 2007 10:01:50 GMT

both structure should be same. primary key should be specified.

enquee

update dbname TABLE itab.

commit work.

dequee

null

Re: Update problem

Former Member — Thu, 22 Nov 2007 10:03:26 GMT

1) Check if the type and values of key fields in the DBTAB and ITAB are same.

2) Use Modify instead of update.

3) If the table is client dependant use client specified.

Hope it helps.

Lokesh

Re: Update problem

former_member194152 — Thu, 22 Nov 2007 10:05:46 GMT

hi,

check weather u are using work area for inserting record into dbtab if u are working with work area and not in loof of itab then it will update only one record in data base check it out.

Regards

Gagan

Re: Update problem

Former Member — Thu, 22 Nov 2007 10:17:21 GMT

<b>The statement to Insert Records from ITAB to DBtable is

INSERT <DBTABLE> FROM TABLE <ITAB> ACCEPTING DUPLICATE ROWS.

The statement to Insert single Record from WA to DBtable is

INSERT <DBTABLE> FROM <wa> .

Check out which of these is two is correct for ur scenario.

And also check the content of the ITAB or Wa in the debugging</b>