Or is it possible to fire the trigger when openenig an article is there such a function, just when I consult It?

thx

Still get error near the keyword from and that I cannot use inserted in stored proc?

thx

Sorry for all thes questions but I am a really newbie to sql language and I do not see very well how it wil work now,

I pasted the code...

Hey

Was my last excel well explained about what the trigger has to do?

Greetings

Ken

Thank's a lot for helping me out

Greetz

Ken

Hello,

So I explained all in an excel sheet in attachment

Could you please help me because I cannot get any result

Thank you very very much

Can I upload an excel file or send you an email where I putted in al the data and explain what I want this trigger to do.

Thx

Ken

Hi,

From the moment I put a where clause in my trigger I get an empty value, so I think I cannot reach my declared values as I need them in...

It looks like I cannot reach my declared values in order to use them

thx

I get an empty value.

When I do the sum of all document lines It works and it makes a sum of all doc lines, but when I specify the select...

Thank's for helping me out

When I update an article it has to go do the table where all the documents are in F_docligne, take all the lines for that article...

Maybe I'am a bit confused ok but I thought If some fields were updated I could sent a print to te screen to tell other fields also have be filled...

some trigger with a Print clause in it??

Thx

ken

Isn't there any possibility???