ALTER TABLE zilfld ADD __input char(2) ---允许输入
ALTER TABLE zilfld ADD __color char(20) ---颜色 字段对应的标签(Clred,clblue)
ALTER TABLE zilfld ADD __noedit char(2) ---不允许编辑
select * from zilfld where tbname='spkfk'
update zilfld set __input='否',__color='Clred',__noedit ='是' where tbname='spkfk' and fdname='spmch'
update zilfld set __input='否',__color='Clred',__noedit ='是' where tbname='spkfk' and fdname='shpgg'
update zilfld set __input='否',__color='Clred',__noedit ='是' where tbname='spkfk' and fdname='dw'
update zilfld set __input='否',__color='Clred',__noedit ='是' where tbname='spkfk' and fdname='shpchd'
update zilfld set __input='否',__color='Clred',__noedit ='是' where tbname='spkfk' and fdname='pizhwh'