topic Re: update table in Application Development and Automation Discussions

update table

Former Member — Tue, 06 Jun 2006 04:32:28 GMT

I need to uplaod existing records in my custom table.

Iam using update keyword .but its not working can any one guide me.

Former Member — Tue, 06 Jun 2006 04:38:38 GMT

Priya,

Can you post the code here and let us know what is the error you are facing?

I hope you have COMMIT WORK statement after UPDATE.

Regards,

Ravi

Former Member — Tue, 06 Jun 2006 04:39:35 GMT

Hai

Use BDC Call Transaction or Session Method

it will directly insert/update the records into your database

Thanks & regards

Sreenivasulu P

Former Member — Tue, 06 Jun 2006 04:41:20 GMT

Hi,

Coz u don't post your code, we can't see your mistake.

But maybe you forget add statement "COMMIT WORK" after "Update" statement.

Regards,

Former Member — Tue, 06 Jun 2006 04:42:37 GMT

Hi,

Do these records already exists in ur custom table..

If no,

then use insert statement or modify statement..

Select f1 f2... from table into itab where <cond>

INSERT ztable FROM TABLE itab.

Also, does your program end properly..

Or else you can use COMMIT WORK..

Regards,

Tanveer.

<b>Please mark helpful answers</b>

Former Member — Tue, 06 Jun 2006 05:15:40 GMT

Hi,

Put COMMIT WORK statement after the statement UPDATE/INSERT/MODIFY (Wjat ever it may be ). It will definitely work.

Regs,

Venkat