topic Re: Database Update in Application Development and Automation Discussions

Database Update

Former Member — Wed, 06 Jun 2007 09:38:29 GMT

HI all,

I am updating a databse table in loop using a subroutine in which i

need to update date field of this table with system date, the other fields are

being updated successfully.

In loop it is working fine.

But once I come out of the loop it is showing all zeros instead of sy-datum for date field.

I have used commit work also.

It is urgent, Please help.

Thanks,

Mungala.

Former Member — Wed, 06 Jun 2007 09:40:59 GMT

Hi,

Please make sure that the date field in database table has data element sy-datum.

Thanks

Arun.

Former Member — Wed, 06 Jun 2007 09:42:52 GMT

hi,

when u are using a perform in a loop

you have to send the table to that form

like PERFORM LIST_HEADER TABLES GIT_HEADER

then it will be updated..

reward points if helpful

regards,

venkatesh

Former Member — Wed, 06 Jun 2007 09:43:17 GMT

Better Declare the Internal Table which you are using for Update, similar to the Database table structure and use UPDATE/Insert from ITAB.

it will insert/update all fields

Reward points for useful Answers

Regards

Anji

Former Member — Wed, 06 Jun 2007 09:44:36 GMT

Hello praveena,

check the date format in your table.

sy-datum uses Date field (YYYYMMDD) stored as char(8)

Regards