Hi jeff

could you tell why this will wait until all updates are notified? i know it does i just dont understand why :w00t:

what is the SELECT @msg = ISNULL purpose?

cheers for that jeff! will come in useful im sure

sure i can 😀

create trigger TestStock on dbo.mal_test After insert as

declare @StockCode varchar(10)

declare @Description varchar(10)

set @StockCode =(select StockCode from Inserted)

set @Description =(select Description from Inserted)

begin

declare @msg varchar(500)

set @msg...

oh yes i see now! thanks for that

i take it small triggers like these have little impact on performance so trying to make one larger trigger willl save little ?

hi Lowell

im trying to see how your trigger loops looking for multiple lines? but dont see how it does!

can you point out the obvious to me? 😉

the spaces are getting padded automatically somehow when i post !

sorry misunderstanding i think

i am getting

New Item created with a Product Code"PT123 "and a description"testpart ".

where the field placeholders are giving me...

cheers, thats it!

only thing now, if i have the fields defined as eg varchar(10)

i get

New Item created with a Product Code"PT123 "and a description"testpart ...

sorry one more question!

in the trigger i am setting the email body as below

set @msg = 'New Item created with a Product Code' "+ @StockCode +" ' and a description'...

its ok, iv got it working !

thanks all for your help!

i must keep in mind what you say about multiple records tho!

oh sorry i understand now

should not be a problem as you can only create or delete a product one at a time!

how can i check if a mail account has...

really?

my thinking was the trigger would only be activated upon a new entry being CREATED?

why would i want to loop through all the records when i only want the...

hi Vidya

i actually only want to email on a create and delete. It is a stock table so really it should not have that many creates or deletes.

i am...

ill try that and see how we get on

thanks grant for your help

yea document looks good, it should give me a clearer idea what im looking at

currently the cost threshold is set at 5 - i have no idea what that is...