KSOA之商品卡片特殊颜色-526互联

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'

卡片