On 7 nov, 11:57, steph <stepha..._at_yahoo.de> wrote:
> On 7 Nov., 11:01, eliot06 <p.hi..._at_gmail.com> wrote:
>
>
>
> > hi,
> > someone could help me :
> > I have create a vue :
>
> > CREATE OR REPLACE VIEW MARKETING.VUE_JEULST026
> > (
> > NUCLI,
> > TYNOM,
> > NULST,
> > NOLST,
> > PRLST,
> > ANNAISLST,
> > MONAISLST,
> > JONAISLST,
> > NUCLI_MRK,
> > NUCLI_ENT,
> > COMPTE,
> > NAME_ID,
> > NUCLI_CARDEX,
> > CD_CLIENT,
> > ID_CLI,
> > NUCLI_DEPOT,
> > NUTIT
> > )
> > AS
> > SELECT
> > "NUCLI","TYNOM","NULST","NOLST","PRLST","ANNAISLST","MONAISLST","JONAISLST","NUCLI_MRK","NUCLI_ENT","COMPTE","NAME_ID","NUCLI_CARDEX","CD_CLIENT","ID_CLI","NUCLI_DEPOT","NUTIT"
> > FROM marketing.jeulst026
> > /
>
> > And i can't update or insert or delete !!! anything
>
> > Why
>
> Hi,
>
> Update or insert into a view is only working under certain
> circumstances. Maybe you should offer the information of your Oracle
> version. And maybe consultation of the manuals is also helpful
> (obviously ...).
>
> cheers,
> stephan
I connect the oracle vue with odbc onto access and it's ok, i can
upade delete insert but ni cannot with toad !!!!
Received on Wed Nov 07 2007 - 05:28:18 CST
