topic Re: how can we update data base table in an report program in Application Development and Automation Discussions

how can we update data base table in an report program

Former Member — Mon, 06 Nov 2006 13:13:19 GMT

can any one explain in detail how can we update data base table in an report program

andreas_mann3 — Mon, 06 Nov 2006 13:19:02 GMT

hi,

pls look here:

Former Member — Mon, 06 Nov 2006 13:20:56 GMT

Hi,

it's very simple,

suppose take a dbtable 'SBOOK'

if you want to update CONNID value with some other value where CARRID = 'abc' suppose.

then

tables: sbook.

update sbook set connid = 45 where carrid = 'abc'.

the existing value of connid chages

please assign points if it helps you

Regards,

Sowjanya

Former Member — Mon, 06 Nov 2006 13:22:56 GMT

Raja,

you can insert, modify and delete DB records usign work area as following stmets..

INSERT INTO zppa_idr_payscal VALUES wa_payscal.

MODIFY zppa_idr_curr FROM wa_curr.

DELETE TABLE t_jobs FROM wa_jobs.

-Anu

Former Member — Mon, 06 Nov 2006 13:31:51 GMT

U can use update or modify statement to update database tables.