|
数据集中的sql语句如下:
select guid,tid,tname,ttype,tstatus,'XTL' as parentID from hrm_setting where ttype='T'
union all (select guid,tid,tname,ttype,tstatus,'FXTL' as parentID from hrm_setting where ttype='F')
union all (select 'XTL' as guid,'XTL' as tid,'系统类' as tname,'E' as ttype,'T' as tstatus,'-1' as parentID from dual)
union all (select 'FXTL' as guid,'FXTL' as tid,'非系统类' as tname,'E' as ttype,'T' as tstatus,'-1' as parentID from dual)
如果不用union的话,是可以编辑的,所以排除设置了字段只读,用了union就肯定说字段只读,不能编辑。
我生产了sql语句后,可以新增了,但是就是不能编辑。请问怎么可以让其能编辑其中一个字段的值 |
|