Re: SQR3 vs SQR2 problem.

[Mario Insigne <minsigne@CCSF.CC.CA.US>]

Ben,
 Remove the line  -- pdrbded_bdca_code   &ded_code    -- it will run ok.

Mario


On Fri, 21 Mar 1997, Ben Le wrote:

> <bold>I need to find out if any one is having this problem. We just
> upgraded SQR3.05 from SQR2.4.5. Here is the problem:
>
> </bold>
>
> BEGIN-PROCEDURE sel-deductions
>
> BEGIN-SELECT
>
> <bold>pdrbded_bdca_code</bold>   (,) on-break print=never
> before=report-heading after=next-page
>
> spriden_id          (+1,1)
>
> spriden_last_name   (,13)
>
> pdrbded_begin_date  (,35)
>
> pdrbded_end_date    (,46)
>
> <bold>pdrbded_bdca_code</bold>   &ded_code
>
> ptrbdca_long_desc   &ded_description
>
>
> From......
>
>
> ORDER BY <bold>pdrbded_bdca_code</bold>,spriden_last_name,spriden_id
>
> END-SELECT
>
> END-PROCEDURE
>
>
> <bold>The above query works well with SQR2.4.5 BUT NOT with SQR3.05. Here
> is the error message when run with SQR3.05:
>
> </bold>
>
> (SQR 5528) ORACLE OPARSE error -960 in cursor 12:
>
>    ORA-00960: ambiguous column naming in select list
>
> SQL:  select pdrbded_bdca_code, spriden_id, ....
>
> Error at:  pdrbded_bdca_code
>
>
> Error on line 296:
>
>    (SQR 3716) Error in SQL statement.
>
>
> Errors were found in the program file.
>
> SQR: Program Aborting.
>
>
> <bold>If you've noticed, the select clause has two same fields
> (pdrbded_bdca_code). And 'ORDER BY' by that field. This works fine under
> SQR2 but not SQR3.05. If I remove one of these fields from select clause
> then SQR3.05 runs OK. Or if I remove that field in 'ORDER BY' and leave
> these two fields in select clause then SQR3.05 runs OK too. Either cases,
> I don't want to remove any thing.
>
> I would appreciate for any clue about this. Thanks.
>
>
> Ben.</bold>
>
>
>
> <bold>------------------------------------------------------------------------
>
> Benjamin Le                                                             Phone: (503)-977-4970
>
> Portland Community College                              Fax:   (503)-977-4987
>
> ITS, System Development                                         E-mail: ble@pcc.edu
>
> PO Box 19000 Portland, OR. 97280-0990 U.S.A.    Web: http://www.pcc.edu
>
> ----------------------------------------------------------------------</bold>--
>