Article View: borland.public.interbase.sql
Article #872Re: Changing column default values
From: Bill Todd
Date: Thu, 14 Jun 2007 03:22
Date: Thu, 14 Jun 2007 03:22
7 lines
1109 bytes
1109 bytes
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:
<4670b488$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<46709339$1@newsgroups.borland.com> <4670989e$1@newsgroups.borland.com> <4670a776@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: "Bill Todd" <no@no.com>
Subject: Re: Changing column default values
Newsgroups: borland.public.interbase.sql
References: <46709339$1@newsgroups.borland.com> <4670989e$1@newsgroups.borland.com> <4670a776@newsgroups.borland.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <4670b488$1@newsgroups.borland.com>
Date: 13 Jun 2007 20:22:48 -0700
X-Trace: newsgroups.borland.com 1181791368 216.207.211.19 (13 Jun 2007 20:22:48 -0700)
Lines: 7
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail