Re: update a vie

sorry

my view is

CREATE FORCE VIEW
 users ( id, name, password, group_id )
AS
 SELECT
  student_no,
  student_name,
  password,
  group_id
 FROM
  student
 UNION
 SELECT
  teacher_no,
  teacher_name,
  password,
  group_id
 FROM
  TEACHER
;

"iim" <lianghs_at_163.net> 写入消息新闻:ao2s5k$2k4i$1_at_mail.cn99.com...
> When i update data from a view, i got the following error. how can i
correct
> it ?
>
> 01732, 00000, "data manipulation operation not legal on this view"
> // *Cause:
> // *Action:
> /export/home/
>
>
>
Received on Wed Oct 09 2002 - 22:33:45 CDT