Open SQL能够动态定义WHERE条件。如下:
[For Example]
DATA: WHERE_TAB TYPE TABLE OF EDPLINE.
DATA: DT_SCUSTOM LIKE STANDARD TABLE OF SCUSTOM WITH HEADER LINE.
APPEND ' ID = 11279 ' TO WHERE_TAB. "添加条件
APPEND ' OR ' TO WHERE_TAB.
APPEND ' ID = 36 ' TO WHERE_TAB.
*DATA COND TYPE STRING.
*LOOP AT WHERE_TAB INTO COND. "无HEADER LINE内表LOOP...INTO FIELD
"WRITE: / COND.
*ENDLOOP.
SELECT ID NAME FROM SCUSTOM INTO CORRESPONDING FIELDS OF DT_SCUSTOM WHERE (WHERE_TAB).
WRITE:/ DT_SCUSTOM.
ENDSELECT.
*运行结果如下:
SELECT * FROM SCUSTOM INTO DT_SCUSTOM WHERE (WHERE_TAB).
WRITE:/ DT_SCUSTOM.
ENDSELECT.
*运行结果如下:
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步