topic Re: database updation in Application Development and Automation Discussions

database updation

Former Member — Tue, 18 Nov 2008 12:53:17 GMT

i need to update the database from the internal table , my internal table contains only few fields refering to the database table fields , so when i am using stmt,

insert dbase values workarea.

it is saying workarea is not long enough.

Re: database updation

MarcinPciak — Tue, 18 Nov 2008 13:21:29 GMT

Do like this:


"Define strucutre of your dbtable
TABLES: dbtable.

"Now move all corresponding fields of your work area to this structure
MOVE-CORRESPONDING workarea TO your_table.

"now you are able to insert the entry to dbtable from this db strucutre
insert dbtable from dbtable.

Re: database updation

former_member206439 — Wed, 19 Nov 2008 04:55:51 GMT

for data base updates you can do one thing

Use MODIFTY table from ITAB.

it will update the record values if that record already exsists and if not it will insert that record in to the data base

Re: database updation

abdul_hakim — Wed, 19 Nov 2008 05:20:09 GMT

First Clearly explain you want to Insert into database table or Update a Database table.

If you want to update a particular field of database table use the below statement.

UPDATE <dbtab> SET field1 = value1 field2 = value2 WHERE field3 = value3.

Incase if you want to insert then.

DATA <workarea> LIKE <dbtab>.

*Fill the work area with the required fields and the use the below statement.

INSERT <dbtab> FROM <waarea>.

Cheers,

Hakim