Re: This is not trivia pursuit....

[Rick_Creel@AONCONS.COM]

I strongly AGREE with what John Ferguson has said.......  no purpose was served
in ridiculing the question or the intelligence of the person asking the
question.





John Ferguson <jferguson@INETNOW.NET> on 01/06/2000 05:08:21 PM

Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Rick Creel/IT/Aon Consulting)

Subject:  Re: This is not trivia pursuit....



I thought the whole purpose of this group was to help each other out. Not
everyone can be a smart as you think you are. It would have served everyone
better if you just pointed out the mistake instead of making a joke about it.

If you remember back to when you started coding, I'm sure you didn't have all of
the answers. Think about that next you consider any question stupid or people as
clueless.

John

Sam Spritzer wrote:

> Don't you just love it when clueless users make a request that, in their
world, makes perfect sense to them within the realm of their logic and common
> sense.....hence, take a look at the following.
>
> I am trying to update a varchar(30) column from one table with a varchar(30)
column from another table. I have already tested both columns for null
> values....and there aren't any. Can any of you shed any light in this?
>
>             *********************************************
> SQL*Plus: Release 3.3.2.0.2 - Production on Thu Jan 06 16:26:11 2000
>
> Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
> Connected to:
> Oracle7 Server Release 7.3.4.3.0 - Production
> With the distributed, replication, parallel query and Spatial Data options
> PL/SQL Release 2.3.4.3.0 - Production
>
> SQL> update ps_employment a
>    2 set a.business_title = (select b.jobtitle
>    3 from ps_employees b
>    4 where a.emplid = b.emplid);
> from ps_employees b
>      *
> ERROR at line 3:
> ORA-01407: cannot update mandatory (NOT NULL) column to NULL
>             ****************************************
>
> SQRly yours,
> Sam