Re: Help on views

I tried and the second value is inserted (Ben). Makes no error.

hth

Yann

B. Schiller a écrit dans le message <9o0c9l$6du$03$1_at_news.t-online.com>...
>Hallo,
>
>I have a question on views.
>
>If I have a table e.g.
>table a: id,name,street (NULL-Values allowed)
>
>and I create a view like this:
>create view test1 as
>select name n1, name n2 from a;
>
>(Well, maybe this makes no sense)
>
>Question: What happens when I insert into the view values like this:
>
>insert into test1 (n1,n2) values('George','Ben') ;
>
>What will be inserted into table a?
>Only 'George'?
>nothing (error-message) ?
>
>Thanks for help!
>
>
Received on Tue Sep 18 2001 - 06:52:48 CDT