topic Re: Set field in Application Development and Automation Discussions

Set field

Former Member — Mon, 02 Jun 2008 04:39:00 GMT

Hi all,

I am creating an RFC.which has to fetch the content from Database table.depending upon flag.

lets say If flag is initial.

Fetch the content.

After fetching the content i have to set that flag to "0" r "1".

Any suggetsions.

Thanks,

Kalyan.

Re: Set field

Former Member — Mon, 02 Jun 2008 06:12:21 GMT

Hi all,

I have to update a single column in dBtable after fetching the data.

i have used

the statement as

update <dbtable>set fieldname eq 1 where (condition).

but giving error.

any suggetsons.

thanx.

Re: Set field

ritesh_dugad2 — Mon, 02 Jun 2008 07:06:50 GMT

Update will work only if the fields that you pass in the where condition match with atleast one record in the database table. Check for sy-subrc value after update. It should be 0 meaning the update was successful.

Re: Set field

Former Member — Mon, 02 Jun 2008 07:45:48 GMT

Hi,

I am getting an

error

that instead Flag use itab or filed..

therefore the single record in question maynot be unique.

Thanx,

Re: Set field

Former Member — Mon, 02 Jun 2008 07:59:40 GMT

Hi,

Try to use the below code...

update <dbtable>set <fieldname> eq 1 where (condition).

Field name should be your field which you want to pass 1 to the database table. Use exactly field in the DB table.

Rgds,

Bujji