topic Re: problem with deleteing a record froma database table. in Application Development and Automation Discussions

problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:28:30 GMT

HI,

iam facing a proble with the delete statement.

iam getting sy-subrc value = 4.

code

LOOP AT t_tab INTO w_tab.

IF w_tab-check = 'X' AND

w_tab-flag = 'X'.

DELETE t_tab . " deleting the value in the internal table

move-corresponding w_tab to ztest_tab.

delete ztest_tab.

ENDIF.

ENDLOOP.

ztest_tab is the database table name.

can any one help me.

regards

priyanka

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:31:25 GMT

HI,

If u want to delete the same row from database table use

DELETE <dbtable> from <workarea>

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:31:54 GMT

iam getting sy-subrc value = 4.

Where ur checking sy-subrc value .

In which statement ur geting that value...

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:33:31 GMT

Have you declared "ztest_tab" using the tables declaration? If not try doing that.

TABLES:

ZTEST_TAB.

Re: problem with deleteing a record froma database table.

BH2408 — Mon, 09 Feb 2009 13:33:53 GMT

Hi ,

try use the

delete from <table > where condition.

Regards,

Bharani

Re: problem with deleteing a record froma database table.

viquar_iqbal — Mon, 09 Feb 2009 13:35:45 GMT

You need to use delete t_tab from w_tab ( or use refresh or FREE statement to delete internal table )

Thanks

Viquar Iqbal

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:36:53 GMT

hi,

Can you be more specific about the deletion you are trying to do ?

Moreover

move-corresponding w_tab to ztest_tab.

This statement has no effect on the database.

Thanks

Sharath

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:38:42 GMT

For Deleteing record from Database specify the where condtion.

DELETE FROM ztest_tab

WHERE field1 = w_tab-field1 AND

field2 = w_tab-field2 .

To delete multiple records.

DELETE ztest_tab FROM TABLE t_tab.

To delete single record.

DELETE ztest_tab FROM w_tab.

Regards,

Raghu

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:40:48 GMT

i have declared the tables satatement

ie :

tables :

ztest_tab.

after the delete statement is executed the operation is being failed.

ie : iam getting the sy-subrc value = 0.

Regards

Priyanka.

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:49:10 GMT

Use Commit statment after delete command.

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:50:21 GMT

Hi Priyanka,

Do like this


LOOP AT t_tab INTO w_tab.
IF w_tab-check = 'X' AND
w_tab-flag = 'X'.
"DELETE t_tab .  deleting the value in the internal table  Dont use this
move-corresponding w_tab to ztest_tab. " no need for this
delete ztest_tab FORM w_tab.
ENDIF.
ENDLOOP.
DELETE t_tab WHERE check = 'X' and flag = 'X'. "if u need to delete such records

Re: problem with deleteing a record froma database table.

awin_prabhu — Mon, 09 Feb 2009 13:50:47 GMT

Hi friend,

Check the data type and length of fields declared in program and

fields in database table(ztest_tab) are same.

Thanks.....

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:51:05 GMT

hi,

Declare another internal table of structure similar to the earlier one.

Append the records to this 2nd table which satisfy the IF condition you have mentioned inside the loop.

loop at itab1 into w_itab1.

if------

ie. append ztest_tab to itab2.

endif.-----

endloop.

Use Delete DBTAB from table itab2.

This way you can achieve your required functionality, its working as per requirement

Regards

Sharath

Re: problem with deleteing a record froma database table.

Former Member — Mon, 09 Feb 2009 13:54:42 GMT

hi,

PS. Never perform any database operations such as select, delete..etc inside loops (DO, loop...etc).

This kind of coding creates a severe performance overhead on your system.

Better assemble records of your choice for deletion into a internal table and delete using the table as a reference

Regards

Sharath