泛微E8调整字段的小数位数-数据库篇

在 Oracle 环境下新建了一个2位小数的字段，而后想扩展成5位小数。先直接把数据库中的真正字段改了长度，表单界面还是显示2位。摸索了半天，还有这两个地方要改：

如果需要查询各表单中字段的配置信息，可以参考下面的语句。

select base.id, base.workflowname as "工作流名称", bill.tablename as "对应主表名", 
       detail.tablename as "对应明细表名" , field.fieldname as "字段名称", 
       field.id as "字段ID", field.viewtype as "是否明细字段(1则为明细)" ,
       lbl.fieldlable as "表单显示文字"
from workflow_bill bill
left join workflow_base base 
on bill.id = base.formid
left join workflow_billdetailtable detail
on detail.billid = base.formid
left join workflow_billfield field
on field.billid = bill.id
left join workflow_fieldlable lbl
on lbl.formid = detail.id
where 
-- base.id = '前端对应工作流id'
-- and detail.tablename = '表单对应明细表的名字'
-- and 
base.workflowname = '路径名称'
order by detail.tablename asc

还有其他情况的，后面陆续整理吧。

（完）