Article View: borland.public.interbase.sql
Article #11385Re: deactivate a constraint
From: Craig Stuntz TeamB
Date: Mon, 25 Nov 2002 19:44
Date: Mon, 25 Nov 2002 19:44
20 lines
1742 bytes
1742 bytes
In article <3de26bdd$1@newsgroups.borland.com>, sagoan@hotmail.com says... > I need to deactivate a constraint for changing some datas of a table.๏ฟฝis > it possible > with some sql command? > Not with SQL. To alter a constraint you use DDL. From an app, it looks the same, but from IB's point of view, it's very different (you can't do it in procedures or triggers, for example). The most important thing to realize is this: If you disable a constraint, that affects everyone using the DB at the time, not just your connection. HTH, -Craig -- Craig Stuntz [TeamB] ๏ฟฝ Vertex Systems Corp. ๏ฟฝ Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<MPG.184c40a22d9c1098a265@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3de26bdd$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,b11fe07474965114 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-11-25 12:07:36 PST From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> Newsgroups: borland.public.interbase.sql Subject: Re: deactivate a constraint Date: Mon, 25 Nov 2002 14:44:25 -0500 Message-ID: <MPG.184c40a22d9c1098a265@newsgroups.borland.com> References: <3de26bdd$1@newsgroups.borland.com> Organization: Vertex Systems Corporation X-Newsreader: MicroPlanet Gravity v2.60 NNTP-Posting-Host: 65.86.87.242 X-Trace: newsgroups.borland.com 1038253371 65.86.87.242 (25 Nov 2002 11:42:51 -0800) Lines: 20 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail