deactivate a constraint

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by sago Mon, 25 Nov 2002 18:31

#11381

Author: sago
Date: Mon, 25 Nov 2002 18:31

9 lines
1062 bytes

Hi, my name is Sago

    I need to deactivate a constraint for changing some datas of a table.�is
it possible
with some sql command?

I use interbase 6.0

thanks

Re: deactivate a constraint

#11382

Author: Martijn Tonies
Date: Mon, 25 Nov 2002 19:15

28 lines
1519 bytes

Hi Sago,

No, constraints cannot be disabled.


>
>     I need to deactivate a constraint for changing some datas of a table.�is
> it possible
> with some sql command?



--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Re: deactivate a constraint

#11385

Author: Craig Stuntz TeamB
Date: Mon, 25 Nov 2002 19:44

20 lines
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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads