topic Re: delete from database ztable using index in Application Development and Automation Discussions

delete from database ztable using index

Former Member — Fri, 05 Oct 2007 03:37:17 GMT

i want to delte from database table record using index

say for eg i have the index captured in a variable = 8 and i want to delted the 8th record from database

pls suggest how to do it

regards

Nishant

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 03:46:46 GMT

Hi Nishant ,

I dont think you can delete entries from a database table using index , to delete you need to specify the primary key in the where clause.

Regards

Arun

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 03:58:30 GMT

can i modify using index?

or let me know i have data in a table zcust_em and it has only one record which is different from the database table which i want to modify

how to do it?

regards

Nishant

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 04:03:18 GMT

Hi Nishant ,

I dont think there is any operation that can be performed on a data base table uisng index , you will have to use the primary key for it.

I am not sure how you are getting the index of the database table , if you can get it then you can surely also get the primary key fields of the table.

Regards

Arun

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 04:09:57 GMT

i have a database table zmm_aims_opn

with fields

customer number name email

all are primary keys?

i have captured the data in t_modify internal table which contains the data whihc is to be modified

but it is beig inserted not modified as this int table has the modified data hence it is not able to match with the database table and hence it is inserting?

now ther are tow options to use cetain condtion to comapre the record in the d atabase table or use index

index will be better one pls suggest

or let me know if i can use where conditon

or the table zcust_em contains the data which is to be now in the da tabase table how to use this table to update in database?

the modification code is as below

loop at t_aims_opn_modify.

modify zmm_aims_opn from table t_aims_opn_modify ( this is internal table having all records to be modified)

message s001 with 'Data saved'(004).

refresh:t_aims_opn_modify.

endloop.

lse.

message s001 with 'Data already saved'(003).

regards

nishant

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 04:15:35 GMT

Please see my reply to a similar question you have posted,

Regards

Arun

Message was edited by:

Arun R

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 04:18:24 GMT

Hi Nishant,

i think it is the similar thread. Can you please close one thread.

Regards,

Atish

Re: delete from database ztable using index

Former Member — Fri, 05 Oct 2007 05:18:13 GMT

Hi Nishant,

I think this may be ur solution to update a table.

LOOP AT table t_aims_opn_modify .

UPDATE zmm_aims_opn SET email = table t_aims_opn_modify -email

WHERE email EQ table t_aims_opn_modify -email

IF sy-subrc = 0.

COMMIT WORK.

message s001 with 'Data saved'(003

ENDIF.

ENDLOOP.