Re: Changing column default values

Article View: borland.public.interbase.sql

Article #870

Back to borland.public.interbase.sql Previous Next

#870

From: Bill Todd
Date: Thu, 14 Jun 2007 02:22

14 lines
1581 bytes

Bob wrote:

> Thank you for the solutions, thats great.
> By the way, We have been using default values for a long time
> successfully in IB6 and above without ever specifying NOT NULL I
> wonder where you got the idea that you had to specify NOT NULL?

Try inserting a new row and specifying null as the value for one of
your fields with a default. You will find that the value of the field
will be null, not the default. If you do not include the field in the
INSERT statement then you will get the default.

-- 
Bill Todd (TeamB)

Technical Details

Message-ID: <4670a653$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.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> <4670a0a0$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: "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> <4670a0a0$1@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: <4670a653$1@newsgroups.borland.com>
Date: 13 Jun 2007 19:22:11 -0700
X-Trace: newsgroups.borland.com 1181787731 216.207.211.19 (13 Jun 2007 19:22:11 -0700)
Lines: 14
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.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