too right!

cheers Jon...

yogiberr

hi, does this mean that it is better to write a separate trigger for type of operation that is performed on a table?

eg

trig1 =INSERT

trig2 =DELETE

trig3 = UPDATE

cheers,

yogi

Hi Bill,

as it happens, I don't need the data that is in the old columns..still, it's good to get as many options as were suggested.

thanks all.

yogi.

Hi,

Yes it is isql that i am trying to connect to.I'll give the config file a bash.

cheers,

yogi.

never thought of that.

nice one.

yogi

righto.

Thanks Frank.

yogi

good question.

some of the columns in the table are now less important than they were when I created them.so, when i go to QA, i'd like to return all the...

Cheers Jonathan.

livin and learnin..

yogi

Good tip.

thanks all.

yogi

thanks folks,

So, would I be best to:

1) use "sp_depends" on the table that I am about to alter (to find out which other db objects the column name-change...

cheers for the reply.

I tried to login using:

isql -E

However, I get a login problem:

"DB-Library:Unable to connect:Sql server is unavaliable or does not exis.

Unable to connect:Sql server is unavaliable or...

Hi Noel.

I understand now.

Thanks bud.

yogi

Hi Noel,

I see your point about the cascade updates being largely superfluous..good one.

When you mention the fact that the application has to be controlled, do you mean that eg...

hello, thanks all , for taking the time.

I appreciate it.

yogiberr

Hi Jonas.

Right enough.Thanks bud.

yogi