ALTER Field - How can I avoid dependencies ? - Thread - go-pugleaf

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by qWin Thu, 17 Jul 2008 19:39

ALTER Field - How can I avoid dependencies ?

#182

Author: qWin
Date: Thu, 17 Jul 2008 19:39

13 lines
1222 bytes

Hi,

I need to ALTER MyField
TYPE Decimal(8,2) to TYPE Decimal(10,2)
but there are dependencies.

I would have to drop quite a few other things 1st
Then only make my desired change
.. and then recreate all the other dropped stuff again

Is there not a way to avoid all that?

Thanks q

Re: ALTER Field - How can I avoid dependencies ?

#183

Author: qWin
Date: Thu, 17 Jul 2008 21:21

22 lines
1538 bytes

I had wanted to cheat the integrity mechanism
anyway I did the change the longwinded way
would still be interested to know if there is a way ....
q


"qWin" <ZuluData@hotmail.com> wrote in message 
news:487f9ff9@newsgroups.borland.com...
> Hi,
>
> I need to ALTER MyField
> TYPE Decimal(8,2) to TYPE Decimal(10,2)
> but there are dependencies.
>
> I would have to drop quite a few other things 1st
> Then only make my desired change
> .. and then recreate all the other dropped stuff again
>
> Is there not a way to avoid all that?
>
> Thanks q
>

Re: ALTER Field - How can I avoid dependencies ?

#184

Author: Bill Todd [TeamB]
Date: Thu, 17 Jul 2008 21:54

8 lines
1009 bytes

qWin wrote:

> Is there not a way to avoid all that?

No.

-- 
Bill Todd (TeamB)

Re: ALTER Field - How can I avoid dependencies ?

#185

Author: Pavel Kutakov
Date: Fri, 18 Jul 2008 17:42

25 lines
1719 bytes

Only some third-party tools (our IBStudio for example) can build the script 
to do this. This script contains several statements to drop dependend 
objects, make changes in the table and recreate deleted object again. Of 
course, this will work only when you are doing change to compatible datatype 
so your existing SPs will not fail.

-- 
Best regards.
Pavel Kutakov
SQLLY Development
http://www.sqlly.com


> I need to ALTER MyField
> TYPE Decimal(8,2) to TYPE Decimal(10,2)
> but there are dependencies.
>
> I would have to drop quite a few other things 1st
> Then only make my desired change
> .. and then recreate all the other dropped stuff again
>
> Is there not a way to avoid all that?
>
> Thanks q
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads