Hello All! Please heeeelp!
I'm having problems on updating simple, as I think, view;
Also note: In view, there are labels which are in russian text, in UNICODE.
create table A1.Person (
id serial primary key,
firstname varchar(64) unicode not null,
secondname varchar(64) unicode,
surname varchar(64) unicode not null,
date_of_insert timestamp not null default timestamp )
//
create table A1.Student (
id fixed(10) primary key references A1.Person(id) on delete
cascade )
//
create or replace view A1.students_view as
select A1.Person.id,
A1.Person.firstname as "Имя",
A1.Person.secondname as "Отчество",
A1.Person.surname as "Фамилия",
A1.Person.address as "Адрес",
A1.Person.tel as "Телефон"
from A1.Person,A1.Student where A1.Person.id = A1.Student.id
Now while updating second column of view (labeled "Отчество" )
update A1.students_view set "Отчество" = 'тест' where id = 7
returns error: -5001 POS(8) Missing privilege:UPDATE
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
