想实现这样的功能,当table1 更新的时候,如果table1 中的字段field1等于1的话,field6=北京,如果field2等于1的话field6=field6+上海,以此类推,请问下面的为什么不行呢?Creat Trigger Tri_table1
On table1 for update as if update
Begin
If field1=1 begin
field6=北京
End
If field2=1 begin
field6=field6+,上海
End
If field3=1
begin
field6= field6+,广州
End
If field4=1
begin
field6=field6+,重庆
End
end Creat Trigger Tri_table1
On table1 for update as if update
Begin
If field1=1 begin
field6=北京
End
If field2=1 begin
field6=field6+,上海
End
If field3=1
begin
field6= field6+,广州
End
If field4=1
begin
field6=field6+,重庆
End
end
On table1 for update as if update
Begin
If field1=1 begin
field6=北京
End
If field2=1 begin
field6=field6+,上海
End
If field3=1
begin
field6= field6+,广州
End
If field4=1
begin
field6=field6+,重庆
End
end Creat Trigger Tri_table1
On table1 for update as if update
Begin
If field1=1 begin
field6=北京
End
If field2=1 begin
field6=field6+,上海
End
If field3=1
begin
field6= field6+,广州
End
If field4=1
begin
field6=field6+,重庆
End
end
case when fields = 1 then field6='北京'
when fields = 2 then field6=field6+'上海'
...
end
On table_1 for update as if update
Begin
case when field1=1 then field6='上海'
end
end提示有错误