Not good approach.
Instead, use 'deferrable constraints, should work in your
situation.
Igor Neyman, OCP DBA<A
href="mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A title=dwagoner_at_arsenaldigital.com
href="mailto:dwagoner_at_arsenaldigital.com">David Wagoner
To: <A title=ORACLE-L_at_fatcity.com
href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L
Sent: Wednesday, November 28, 2001 11:24
AM
Subject: RE: Script to Disable
Constraint, Change Value, then Enable Const
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">I can see the
confusion here. The point is not
to let someone enter data<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">that would
violate the referential integrity.
Let me explain with an<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">example:<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'"><SPAN
style="mso-spacerun: yes"> <FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<P class=MsoNormal
style="MARGIN-LEFT: 42pt; TEXT-INDENT: -24pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo3; tab-stops: list 42.0pt"><FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">1.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">User wants to
update a primary key record in parent table<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<P class=MsoNormal
style="MARGIN-LEFT: 42pt; TEXT-INDENT: -24pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo3; tab-stops: list 42.0pt"><FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">2.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Dependent
data exists in a child table so the user gets an error while trying to perform
step 1<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<P class=MsoNormal
style="MARGIN-LEFT: 42pt; TEXT-INDENT: -24pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo3; tab-stops: list 42.0pt"><FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">3.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">It is
necessary to disable the FK constraint in order to update both
tables<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<P class=MsoNormal
style="MARGIN-LEFT: 42pt; TEXT-INDENT: -24pt; mso-layout-grid-align: none; mso-list: l0 level1 lfo3; tab-stops: list 42.0pt"><FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">4.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Enable the FK
constraint successfully<FONT face="Courier New" color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'"><SPAN
style="mso-spacerun: yes"> <FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'"><SPAN
style="mso-spacerun: yes"> <FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">Does that
make sense? This is a process we
have to do routinely and it has<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">happened in
the past that the FK was mistakenly not re-enabled, which<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT
face="Courier New" color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'">allowed
"illegal" data to be loaded later.
Thus the need for a script.<FONT face="Courier New"
color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Courier New'; mso-color-alt: windowtext">
<FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=blue
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail
Signature" <FONT
face=Arial color=blue size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">David
B. Wagoner
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Database
Administrator<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Arsenal
Digital Solutions Worldwide Inc.<FONT face=Arial
color=blue size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">4815
Emperor Blvd., Suite 110<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Durham,
NC 27703<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Tel.
(919) 941-4645<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Fax
(919) 474-0735<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; 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
face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Web
<SPAN
style="FONT-FAMILY: 'Times New Roman'">
http://www.arsenaldigital.com/<FONT
face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT
face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes">
<SPAN
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">***<SPAN
style="mso-spacerun: yes"> NOTICE<SPAN
style="mso-spacerun: yes"> ***<FONT face=Arial
color=blue size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<SPAN
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; 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
face=Arial color=blue size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<!---size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial'><SPAN
class=EmailStyle20><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT face=Tahoma color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original
Message-----From: Mark Leith
[mailto:mark_at_cool-tools.co.uk]<SPAN
style="FONT-WEIGHT: bold">Sent: Wednesday, November 28, 2001 5:20
AMTo: Multiple recipients of
list ORACLE-LSubject: RE:
Script to Disable Constraint, Change Value, then Enable
Constrain
<FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt">
<FONT face=Arial color=blue
size=2>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?<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Arial color=blue
size=2>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.. <SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face="Times New Roman"
color=black size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: black"> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT face=Arial color=blue
size=2>I
struggle to see why you would want to do this - do you have any more
info?<SPAN
style="COLOR: black; mso-color-alt: windowtext">
<P class=MsoNormal
style="MARGIN-BOTTOM: 12pt; MARGIN-LEFT: 1in; mso-margin-top-alt: auto"><FONT
face=Tahoma color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma">-----Original
Message-----From:
root_at_fatcity.com [mailto:root_at_fatcity.com]<SPAN
style="FONT-WEIGHT: bold">On Behalf Of David Wagoner<SPAN
style="FONT-WEIGHT: bold">Sent: 27 November 2001 21:30<SPAN
style="FONT-WEIGHT: bold">To: Multiple recipients of list
ORACLE-LSubject: Script to
Disable Constraint, Change Value, then Enable Constrain<FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Listers,
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Does
anyone have a script that will do the
following:
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<P class=MsoNormal
style="MARGIN-LEFT: 1.5in; TEXT-INDENT: -0.25in; mso-list: l1 level1 lfo1; tab-stops: list 1.0in"><SPAN
class=EmailStyle19><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">1.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Accept
user input for old data value<SPAN
style="COLOR: black"> <FONT face=Arial
color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<P class=MsoNormal
style="MARGIN-LEFT: 1.5in; TEXT-INDENT: -0.25in; mso-list: l1 level1 lfo1; tab-stops: list 1.0in"><SPAN
class=EmailStyle19><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">2.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Accept
user input for new data value<SPAN
style="COLOR: black"> <FONT face=Arial
color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<P class=MsoNormal
style="MARGIN-LEFT: 1.5in; TEXT-INDENT: -0.25in; mso-list: l1 level1 lfo1; tab-stops: list 1.0in"><SPAN
class=EmailStyle19><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">3.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Disable
table constraint<SPAN
style="COLOR: black"> <FONT face=Arial
color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<P class=MsoNormal
style="MARGIN-LEFT: 1.5in; TEXT-INDENT: -0.25in; mso-list: l1 level1 lfo1; tab-stops: list 1.0in"><SPAN
class=EmailStyle19><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">4.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Update
record with new data value<SPAN
style="COLOR: black"> <FONT face=Arial
color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<P class=MsoNormal
style="MARGIN-LEFT: 1.5in; TEXT-INDENT: -0.25in; mso-list: l1 level1 lfo1; tab-stops: list 1.0in"><SPAN
class=EmailStyle19><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">5.<FONT
face="Times New Roman" size=1><SPAN
style="FONT: 7pt 'Times New Roman'">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Enable
constraint
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">A
script like this would help ensure that constraints are not left "off" after
updates, allowing "illegal" data into the tables.<SPAN
style="mso-spacerun: yes"> Good user-proof script I would
think.
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">TIA,
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">david
<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">
<span
style="mso-spacerun: yes"> AUTOTEXTLIST \s "E-mail
Signature" <FONT
face=Arial color=blue size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">David
B. Wagoner
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Database
Administrator<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-STYLE: italic; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Arsenal
Digital Solutions Worldwide Inc.<FONT face=Arial
color=black size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">4815
Emperor Blvd., Suite 110<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Durham,
NC 27703<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Tel.
(919) 941-4645<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Fax
(919) 474-0735<SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; 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
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">Web
<SPAN
style="FONT-FAMILY: 'Times New Roman'">
http://www.arsenaldigital.com/<FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"> <FONT
face=Arial color=black size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt"><SPAN
style="mso-spacerun: yes">
<SPAN
style="mso-spacerun: yes"> <FONT
face=Arial color=black size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt">***<SPAN
style="mso-spacerun: yes"> NOTICE<SPAN
style="mso-spacerun: yes"> ***<FONT face=Arial
color=black size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT face=Arial color=black
size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; 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
face=Arial color=black size=1><SPAN
style="FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Arial; mso-color-alt: windowtext; mso-bidi-font-size: 12.0pt">
<FONT
color=black> <FONT
color=black><SPAN
style="COLOR: black; mso-color-alt: windowtext">
Received on Wed Nov 28 2001 - 11:20:38 CST