回答:是扩展出来的?还是固定死的?看看这个吧https://help.fanruan.com/finereport/doc-view-352.html#7e9e23ff0029b59c
回答:实际值用字符串截取MID(aa,FIND("-",aa)+1,LEN(aa)-FIND("-",aa))
回答:原因应该是in包含null值不会查询出null的结果。可以百度看看原因或参考https://blog.csdn.net/weixin_39742065/article/details/116539668 如果是null值的原因建议fine_username判断提前and organization in (select distinct organization from m where 1=1 ${if(or(len(fine_username) == 0,fine_username = “A”),””,”and login = '" + fine_username + "'")})改成and ${if(or(len(fine_username) == 0,fine_username = "A"),"1=1","organization in (select distinct organization from m where 1=1 and login = '" + fine_username + "')"}当然这样依旧有问题,当fine_username是其他值但是对应的organization 也是null时,应该也是查不出的。
回答:mysql中TO_DAYS()函数:给定一个日期date, 返回一个从年份0开始计算的天数,你可以自己输出看看。TO_DAYS(NOW())用DATE(NOW()) 或CURDATE()
回答:改了看下,应该是select字段是子查询的问题吧。还有个问题就是GL_DOCFREE1都没有用到字段left join 它干嘛?SELECT A.ACCOUNTCODE,A.PERIODV,A.NOV,A.YEARV,A.LOCALCREDITAMOUNT,A.LOCALDEBITAMOUNT,A.EXPLANATION,A.PK_VOUCHERTYPEV,A.ASSID,A.PK_DETAIL,A.PK_ACCOUNTINGBOOK,A.PK_ORG,A.PK_ACCASOA, B.NAME AS 财务组织, C.NAME AS 凭证类别, D.FILE_ID AS 数据交换平台传递编号FROM GL_DETAIL ALEFT JOIN (SELECT B.PK_CORP,B.NAME FROM ORG_CORP B WHERE B.NAME='A公司')B ON B.PK_CORP=A.PK_ORGLEFT JOIN (SELECT C.PK_VOUCHERTYPE,C.NAME from BD_VOUCHERTYPE C )C ON C.PK_VOUCHERTYPE=A.PK_VOUCHERTYPEVLEFT JOIN (SELECT D.PK_DETAIL,D.FILE_ID from V_GL_DETAIL D)D ON D.PK_DETAIL= A.PK_DETAILLEFT JOIN GL_DOCFREE1 E WHERE A.ASSID=E.ASSID
回答:在tab块里加绝对画布块,再在绝对画布块里摆放图表
回答:https://blog.csdn.net/xkdlzy/article/details/123918971 直接CREATE PROCEDURE test_if_pro(in sal DOUBLE)BEGIN if sal < 3000 then delete from employees where salary = sal;elseif sal <=5000 then UPDATE employees set salary=salary + 1000 where salary = sal;else update employees set salary = salary + 500 where salary = sal;END if;END 如果是在Navicat或其他工具执行的话不需要delimiter // //delimiter ;
回答:看看logDB里是否有你需要的https://help.fanruan.com/finereport/doc-view-891.htmlhttps://help.fanruan.com/finereport/doc-view-3742.html#19
回答:可能是第3行冻结第4行没冻结的问题,这两行设置成一样看看
回答:PL/SQL developer是32位的,使用32位oci.dll。如果安装的是32位的客户端,则不用设置了。安装64位oracle客户端时oci.dll是64位的,所以需要在PL/SQL中指定oci的位置,以非登录状态下进入PL/SQL developer(登录时不输入用户名和密码,直接点取消),进入首选项,在connection中设置OCI Library.32位的oci.dll可以去官网下载Oracle InstantClient或者从其它安装32位客户端的机器上复制
136
136
2
10