Re: This is not trivia pursuit....

[Robert Stojkovic <robert.stojkovic@IO-CONSULTING.COM>]

Hi Sam

Your update has 2 issues.
1. The employees table has multiple rows for each employee and empl_rcd#
while employment has only 1 row per employee and empl_rcd#.
2. The employees table is updated by an Sqr you may have an employee that is
not in the employees table therefore it is trying to update with a blank
value for that employee. Have you modified the Sqr that populates the
employees table. All the data that is in employees should be coming out of
JOB, Personal data, and Employment. Why are you having to update a core
table with the values in a reporting table derived from the core tables.

Hope this helps

Robert Stojkovic
robert.stojkovic@io-consulting .com
visit our website www.io-consulting.com <http://www.io-consulting.com>
661 803 3178


> -----Original Message-----
> From: Discussion of SQR, Brio Technology's database reporting language
> [mailto:SQR-USERS@list.iex.net]On Behalf Of Sam Spritzer
> Sent: Thursday, January 06, 2000 1:48 PM
> To: SQR-USERS@list.iex.net
> Subject: This is not trivia pursuit....
>
>
> 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
>