pb with "QUOTED_IDENTIFIER"

From: philned (philned_at_wanadoo.fr)
Date: 11/02/04 

Date: Tue, 02 Nov 2004 13:54:55 +0100

hello,

I've a problem with a trigger :
this trigger update a file with an index field but it's return an error
: UPDATE stop because the Set option : "QUOTED_IDENTIFIER" return bad
parameters

for information, this is my trigger :

CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS
     SET NOCOUNT ON
     set arithabort on
     set concat_null_yields_null on
     set quoted_identifier on
     set ansi_nulls on
     set ansi_padding on
     set ansi_warnings on
     set numeric_roundabort off
     declare @code varchar(17)
     select @code=ar_ref from inserted
     begin
*/ replace if reference = 0 */
     if @code='0'
         begin

             update f_article set ar_ref='test' from f_article join
inserted on f_article.cbmarq=inserted.cbmarq
         end
     end

if you ave an idea...
thanks
philned

Relevant Pages

  • pb with a trigger
    ... I've a problem with a trigger: ... this trigger update a file with an index field but it's return an error ... if you ave an idea... ...
    (microsoft.public.sqlserver.server)
  • pb with a trigger
    ... I've a problem with a trigger: ... this trigger update a file with an index field but it's return an error ... if you ave an idea... ...
    (microsoft.public.sqlserver.programming)
  • Re: The method connection.execute does not return error ?
    ... This is because trigger executes in a different process, ... ADO connection. ... > on error goto MyError ... > - This trigger update other tables. ...
    (microsoft.public.vb.database.ado)
  • Re: pb with a trigger
    ... Perhaps the trigger was created with SET QUOTED_IDENTIFIER OFF. ... > this trigger update a file with an index field but it's return an error:> UPDATE stop because the Set option: "QUOTED_IDENTIFIER" return bad> parameters ... > CREATE TRIGGER COOP_article ON F_ARTICLE FOR insert AS> SET NOCOUNT ON ... > set arithabort on ...
    (microsoft.public.sqlserver.server)
  • Re: Triggers on replicated tables making Updates tough.
    ... Does your trigger update the same row that causes it to fire ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)