If the old and new data are both intended to be valid
- why do you need to disable the constraint?
If its a referential integrity issue - maybe a
deferrable constraint (8.0+) is what you are after.
hth
connor
- David Wagoner <dwagoner_at_arsenaldigital.com>
wrote: > Listers,
>
> Does anyone have a script that will do the
> following:
>
> 1. Accept user input for old data value
> 2. Accept user input for new data value
> 3. Disable table constraint
> 4. Update record with new data value
> 5. Enable constraint
>
> A script like this would help ensure that
> constraints are not left "off"
> after updates, allowing "illegal" data into the
> tables. Good user-proof
> script I would think.
>
>
> TIA,
>
> david
>
> David B. Wagoner
> Database Administrator
> Arsenal Digital Solutions Worldwide Inc.
> 4815 Emperor Blvd., Suite 110
> Durham, NC 27703
> Tel. (919) 941-4645
> Fax (919) 474-0735
> Email <mailto:dwagoner_at_arsenaldigital.com>
> mailto:dwagoner_at_arsenaldigital.com
> Web <http://www.arsenaldigital.com/>
> http://www.arsenaldigital.com/
>
>
> *** NOTICE ***
> This e-mail message is confidential, intended only
> for the named
> recipient(s) above and may contain information that
> is privileged, work
> product or exempt from disclosure under applicable
> law. If you have
> received this message in error, or are not the named
> recipient(s), please
> immediately notify the sender at (919) 941-4645 and
> delete this e-mail
> message from your computer. Thank you.
>
>
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music
Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Nov 28 2001 - 05:21:22 CST