Update problem

[Former Member]

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.

[former_member404244]

Hi,

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

also use commit work after the update statement.

Regards,

Nagaraj

[Former Member]

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

enquee

update dbname TABLE itab.

commit work.

dequee

null

[Former Member]

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

[former_member194152]

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

[Former Member]

<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>