Re: How to deferre constraints during inserting in IB6

Article View: borland.public.interbase.sql

Article #11025

Back to borland.public.interbase.sql Previous Next

#11025

From: Bill Todd
Date: Thu, 26 Dec 2002 17:48

10 lines
1375 bytes

You cannot. Even if you could it would be a bad idea since you would
get an error if you ever tried to backup and restore the database due
to the constraint violation on restore.

If you need conditional constrainst the only way to have them is with
triggers.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Technical Details

Message-ID: <u4gm0vkeel5g485qkth0vii34q9uigmj9p@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e0b1b97$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,ddd774cf71b3ee9
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-26 09:54:26 PST
From: Bill Todd <bill@notthis.dbginc.com>
Newsgroups: borland.public.interbase.sql
Subject: Re: How to deferre constraints during inserting in IB6
Date: Thu, 26 Dec 2002 10:48:47 -0700
Message-ID: <u4gm0vkeel5g485qkth0vii34q9uigmj9p@4ax.com>
References: <3e0b1b97$1@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 216.207.211.57
X-Trace: newsgroups.borland.com 1040924927 216.207.211.57 (26 Dec 2002 09:48:47 -0800)
Lines: 10
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message