2.3 sql中调用sql函数 数据集定义那边这么写是可以的 ${sql("FRDemo","select testtext from test where id = 2",1,1)} 里面 where id = 2 换成参数 where id = ${id} 就测不通
赞 0 2021-10-22 10:55
SELECT * FROM 订单 where 1=1 ${if(len(area) == 0,"","and 货主地区 = '" + area + "'")} ${if(len(province) == 0,"","and 货主省份 = '" + province + "'")} ${}内如果是查询语句就需要引号将语句括起来,如果是FR函数则不需要;if(len(area) == 0,"","and 货主地区 = '" + area + "'"):area长度为零,则用空格替换,不为零area=货主地区,后面province同理
赞 0 2021-06-03 09:05
这不好说是文档
赞 1 2021-06-03 08:59
为什么我一页就能显示完的内容,硬是要分页出第二页???
赞 0 2021-04-19 11:26
实际动手设计还是太少了,进展有点慢
赞 0 2021-03-18 17:52
20 评论
2.3 sql中调用sql函数
数据集定义那边这么写是可以的 ${sql("FRDemo","select testtext from test where id = 2",1,1)}
里面 where id = 2 换成参数 where id = ${id} 就测不通
赞 0 2021-10-22 10:55
SELECT * FROM 订单 where 1=1 ${if(len(area) == 0,"","and 货主地区 = '" + area + "'")} ${if(len(province) == 0,"","and 货主省份 = '" + province + "'")}
${}内如果是查询语句就需要引号将语句括起来,如果是FR函数则不需要;if(len(area) == 0,"","and 货主地区 = '" + area + "'"):area长度为零,则用空格替换,不为零area=货主地区,后面province同理
赞 0 2021-06-03 09:05
这不好说是文档
赞 1 2021-06-03 08:59
为什么我一页就能显示完的内容,硬是要分页出第二页???
赞 0 2021-04-19 11:26
实际动手设计还是太少了,进展有点慢
赞 0 2021-03-18 17:52