2007 Jun 12 2:20 AM
Hi all,
may i know if this delete statement can delete the records in table
where the processed = 'X'?
let say 4 records where processed = 'X', can 4 records be deleted with this statement instead of using loop.
DATA: it_report TYPE STANDARD TABLE OF linex,
wa_report TYPE linex. " Working area
DELETE it_report WHERE processed = 'X'.
thanks
2007 Jun 12 2:22 AM
Yes, it will work .
DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.
Regards,
Ravi
Yes, it will work .
DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.
Regards,
Ravi
2007 Jun 12 2:22 AM
Yes, it will work .
DELETE it_report WHERE processed = 'X'. will delete the records that have an 'X' for the field processed.
Regards,
Ravi
2007 Jun 12 2:24 AM
you need to specify like this :
i have one internal table
data i_makt like makt occurs 0 with header line.
start-of-selection.
select * from makt into table i_makt
where condition.
delete makt from <b>table i_makt</b> where cond.
Message was edited by:
Seshu Maramreddy
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |