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_IDENTIF IER" 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_yie lds_null on
set quoted_identifi er on
set ansi_nulls on
set ansi_padding on
set ansi_warnings on
set numeric_roundab ort 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.cbmar q=inserted.cbma rq
end
end
if you ave an idea...
thanks
philned