trigger

[prodadmin]

hi
is this trigger correct ,like i am trying to update if any value changes in the companies table to company table

please help
thanks

[slimdave]

Why not combine all the elsif conditions into the origianl if ...

if (condition1) or (condition2) ... etc?

[prodadmin]

slimdave ..
is this correct now.
Thank you for your help.much appreciated.

***********************

[slimdave]

Is it possible that any of these columns would change to or from a null? You'll need to take account of it, if you do, by coding appropriately, because (not_null <> null) is not true.

[jmodic]

Hey prodadmin,

Is there any special reason why you had to edit your posts (actually deleted all the relevant stuff) once you've got the solution? Don't you realize this forums are not one-to-one consultations? Many of members here might have problems simmilar to your's and don't you think they might be benefitting from slimdave's (or any other) suggestion? Now that you have deleted all the relevant stuff from your posts the thread is totaly meaningless.

IMHO:
This is very egoistic behavior and I realy hate it! The moment you've got the first ansver to your question the thread is no longer your's and your's only - from that moment on it became "freeware", "shareware", "open source", "grant select to public",.... And form that moment on you have no moral rights to modify it beyond recognition.

[slimdave]

That's a very good point. Maybe there should be a time-limit on post-editing, to help with this.

[stecal]

That's right. We can learn from bad code as well as from good code.

[prodadmin]

oops ..

I didn't mean to delete or ego etc etc.

All i did was removed the post because the code was long ..

any how as said i will keep the code in the near future.
let me find the code i will move back ..

come on guys ease on me..

Thanks for all your help(big one to Slimdave).much appreciated

thanks