pb如何得到数据窗口的sql语句

2025-02-22 15:19:30
推荐回答(1个)
回答1:

ls_filter_condition 需要从新写的条件

get_leftstring 截取字符函数

dw_1.settransobject( sqlca )
获取 Is_sql = dw_1.getsqlselect( )
Is_sql = get_leftstring (Is_sql,'WHERE')
new_sql =Is_sql+' WHERE '
new_sql = new_sql + ls_filter_condition
从新给数据窗口sql语句 dw_1.setsqlselect(new_sql)