Re: Changing column default values

Article View: borland.public.interbase.sql

Article #873

Back to borland.public.interbase.sql Previous Next

#873

From: Bob
Date: Thu, 14 Jun 2007 04:04

22 lines
1615 bytes

Have done this.
Still no happinness.
Even in the IBOConsole it indicates that the default value for this field is 
still 'Y'

getting no where fast.
I can't even determine with SQL's what the default value is meant to be, 
really struggling here.

Kind Regards,

Robert.

"Bill Todd" <no@no.com> wrote in message 
news:4670b488$1@newsgroups.borland.com...
> After the ALTER TABLE you need to disconnect and reconnect to make sure
> your transaction sees the new version of the metadata. Trust me, it
> does work. :)
>
>
> -- 
> Bill Todd (TeamB)

Technical Details

Message-ID: <4670be42@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!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>

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>
Subject: Re: Changing column default values
Date: Thu, 14 Jun 2007 14:04:19 +1000
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 203.206.159.118
Message-ID: <4670be42@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1181793858 203.206.159.118 (13 Jun 2007 21:04:18 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!proxad.net!feeder1-2.proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message