Re: SQR3 vs SQR2 problem.

[Nathan Treadway <nathant@ontko.com>]

> BEGIN-SELECT
> pdrbded_bdca_code   (,) 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)
> pdrbded_bdca_code   &ded_code
> ptrbdca_long_desc   &ded_description
>
> From......
>
> ORDER BY <bold>pdrbded_bdca_code</bold>,spriden_last_name,spriden_id
> END-SELECT
> END-PROCEDURE
>

You can move the "&ded_code" to the first time you select that column, as
shown below.  This may solve your problem.

BEGIN-SELECT
pdrbded_bdca_code   &ded_code (,) 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)
ptrbdca_long_desc   &ded_description
FROM ....

I'm not sure why the select would work with SQR v2 and not v3.  You may be
able to tell something by using the "-s" option when you run the program.
Perhaps the two versions of SQR send different SQL text to the database for
some reason.  (I'm assuming that you are running the two versions of SQR
against the same Oracle database. )

                                                Nathan
----------------------------------------------------------------------------
Nathan Treadway    | Ray Ontko & Co. | info@ontko.com (auto-reply server)
nathant@ontko.com  | Richmond, IN    | ftp.ontko.com, http://www.ontko.com/