当参数标记为函数参数时,不能导出参数信息
select (SELECT cx_admin_users.name
FROM cx_admin_users
WHERE u_no = cxy_no) as name,count(cx_contact.contact_no) as count1 FROM cx_contact where state in('1','2','3') and delete_flag=0 and CONVERT(varchar(10), record_in_date, 120) between :date_start and :date_end group by cxy_no HAVING (COUNT(*) >= :fazhi1)
分别定义了三个参数string date_start,date_end Number fazhi1
在窗口调用时语句
string date_start1,date_end1
date_start1 = string(today()) date_end1 = string(RelativeDate(today(), - 3))
dw_1.settransobject(sqlca)
dw_1.retrieve(date_end1,date_start1,fazhi)
但提示“当参数标记为函数参数时,不能导出参数信息”
谢谢！
[解决办法]
看不出什么毛病
CONVERT(varchar(10), record_in_date, 120) between :date_start and :date_end 加个括号试试
