ABAP Tips #2 : count(*) is not good

For the same reason as previous post

USE

SELECT *
 INTO TABLE lt_reserve
 FROM /sie/lib_reserve
 WHERE uname = sy-uname AND date_return = 0.

LOOP AT lt_reserve INTO lw_reserve .
 lv_num_borrowing = lv_num_borrowing + 1.
ENDLOOP.

DON?T USE

SELECT COUNT(*)
 FROM /sie/lib_reserve
 INTO lv_num_borrowing
 WHERE uname = sy-uname AND date_return = 0.

Leave a reply:

Your email address will not be published.