RE: Script to Disable Constraint, Change Value, then Enable Const

From: Hallas John <John.Hallas_at_btcellnet.net>
Date: Wed, 28 Nov 2001 03:36:42 -0800
Message-ID: <F001.003CEAEB.20011128031027@fatcity.com>

Well
said Mark.
David,
you could also re-able the constraint 'novalidate' if you wanted to ignore the validity of any new input.
If
that was the case then why have an integrity constraint in the first place?

John

-----Original Message-----From: Mark Leith [mailto:mark_at_cool-tools.co.uk]Sent: 28 November 2001 10:20To: Multiple recipients of list ORACLE-LSubject: RE: Script to Disable Constraint, Change Value, then Enable Constrain
 How
 could this be user proof? You are essentially disabling the constraint that WILL enforce data integrity, then letting the user input whatever rubbish he wants to, and are then going to try and enable the constraint afterwards?
 
 Not
 a good approach.. How can you ensure that the user hasn't put a duplicate value in (unique constraint) or something else that might break the constraint rule? The only way you are going to know is when you try and re-enable the constraint it will fail..
 
 I
 struggle to see why you would want to do this - do you have any more info?

-----Original Message-----From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of David WagonerSent: 27 November 2001 21:30To: Multiple recipients of list ORACLE-LSubject: Script to Disable Constraint, Change Value, then Enable Constrain

Listers,

Does anyone have a script that will do the following:


      <LI class=MsoNormal 
      style="COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN 
      class=EmailStyle15><SPAN
      style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Accept 
      user input for old data value 
      <LI class=MsoNormal 
      style="COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN 
      class=EmailStyle15><SPAN
      style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Accept 
      user input for new data value 
      <LI class=MsoNormal 
      style="COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN 
      class=EmailStyle15><SPAN
      style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Disable 
      table constraint 
      <LI class=MsoNormal 
      style="COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN 
      class=EmailStyle15><SPAN
      style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Update 
      record with new data value 
      <LI class=MsoNormal 
      style="COLOR: black; mso-list: l0 level1 lfo1; tab-stops: list .5in"><SPAN 
      class=EmailStyle15><SPAN
      style="FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">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

<spans

tyle="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail Signature" <FONT

color=blue face=Arial size=2>David B. Wagoner
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-STYLE: italic; mso-bidi-font-size: 12.0pt">Database Administrator
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; FONT-WEIGHT: bold; mso-bidi-font-size: 12.0pt">Arsenal Digital Solutions Worldwide Inc.
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">4815 Emperor Blvd., Suite 110
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Durham, NC 27703
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Tel. (919) 941-4645
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Fax (919) 474-0735
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Email
<FONT

 face="Times New Roman"><SPAN

    style="FONT-FAMILY: 'Times New Roman'">mailto:dwagoner_at_arsenaldigital.com<FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt">Web
<SPAN

    style="FONT-FAMILY: 'Times New Roman'">http://www.arsenaldigital.com/<FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"> <FONT 
    color=black face=Arial size=2><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<SPAN

style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 10pt; mso-bidi-font-size: 12.0pt"><SPAN

    style="mso-spacerun: yes">

<SPAN

    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt">***<SPAN 
    style="mso-spacerun: yes">  NOTICE<SPAN 
    style="mso-spacerun: yes">  ***<FONT color=black

face=Arial size=1>
<SPAN

 style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt">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.<SPAN

    style="mso-spacerun: yes">  Thank you.<FONT
    color=black face=Arial size=1><SPAN 
    style="COLOR: black; FONT-FAMILY: Arial; FONT-SIZE: 8pt; mso-bidi-font-size: 12.0pt; mso-color-alt: windowtext">

<FONT

    color=black><SPAN 
    style="COLOR: black"> <FONT 
    color=black><SPAN 
    style="COLOR: black; mso-color-alt: windowtext">

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Received on Wed Nov 28 2001 - 05:36:42 CST