Re: Changing column default values

Article View: borland.public.interbase.sql

Article #875

Back to borland.public.interbase.sql Previous Next

#875

From: Bob
Date: Fri, 15 Jun 2007 03:10

22 lines
1865 bytes

Was able to do this by creating a temporary field.
Changing domain didn't work.

But all good now.

"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
news:467154b3$1@newsgroups.borland.com...
> Bob wrote:
>> Have done this.
>> Still no happinness.
>> Even in the IBOConsole it indicates that the default value for this
>> field is still 'Y'
>
> Then either the alter statement failed (check the metadata for the table 
> and make sure it reports the type of that field to be the new domain and 
> double check the domain definition), or there are still open transactions. 
> Worse case, stop and restart the database.
>
> -- 
> Wayne Niddery - Winwright, Inc (www.winwright.ca)
> "In a tornado, even turkeys can fly." - unknown
>

Technical Details

Message-ID: <46720316@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<46709339$1@newsgroups.borland.com> <4670989e$1@newsgroups.borland.com> <4670a776@newsgroups.borland.com> <4670b488$1@newsgroups.borland.com> <4670be42@newsgroups.borland.com> <467154b3$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,afb0f728c721965f
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bob" <Bob@Bob.com>
Newsgroups: borland.public.interbase.sql
References: <46709339$1@newsgroups.borland.com> <4670989e$1@newsgroups.borland.com> <4670a776@newsgroups.borland.com> <4670b488$1@newsgroups.borland.com> <4670be42@newsgroups.borland.com> <467154b3$1@newsgroups.borland.com>
Subject: Re: Changing column default values
Date: Fri, 15 Jun 2007 13:10:14 +1000
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 203.206.159.118
Message-ID: <46720316@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181877014 203.206.159.118 (14 Jun 2007 20:10:14 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message