Re: Changing column default values

Article View: borland.public.interbase.sql

Article #874

Back to borland.public.interbase.sql Previous Next

#874

From: Wayne Niddery [TeamB]
Date: Thu, 14 Jun 2007 14:46

14 lines
1790 bytes

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: <467154b3$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.251.MISMATCH!news-out.readnews.com!transit4.readnews.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>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,afb0f728c721965f
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
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>
Subject: Re: Changing column default values
Date: Thu, 14 Jun 2007 10:46:09 -0400
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <467154b3$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181832371 69.17.170.228 (14 Jun 2007 07:46:11 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!198.186.194.251.MISMATCH!news-out.readnews.com!transit4.readnews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message