SQR 2.57

[PAULDP@SFITVA.CC.FITSUNY.EDU]

After migration to the Dec Alpha machine under banner 7.1.3,
we encountered a number of problems here at FIT when 
running SQR's that had been working previously:

1. When using a date substitution variable in the "where 
clause" of select statements, it had to be enclosed with a set
of quotation marks. When running this under 7.1.3, an error
message was received "a non numeric character was found where
a numeric was expected".  This was fixed when we took off the
quotes. For example, instead of ''''||$date||''', we are now
using $date.

2. An "include" file that had always been working fine was 
creating error messages. We moved the "include"
statement to an arbitrary different place in the SQR and it
worked.  Sorry we can't be more specific, but we don't have a better
handle of this.  If anyone can give us more information, it would be
greatly appreciated..

3. When using an outerjoin in a "where clause" in conjunction
with an "or" operator, the select statement fails . Example:
SPRIDEN_PIDM = SPRADDR_PIDM (+) OR...
is now not functioning. This is a change in ORACLE 7.

4. When selecting out the same column twice in the same
select clause, we got an error 'Ambiguous columns..'
This appears to happen when the select clause is large.  We don't
hit the error if there are only a few fields in the clause.  


Except for #3 which we know is an Oracle 7 "feature", we don't know if these
problems will be encountered on other platforms or operating systems.

ELLEN MEDINS
INTERNET ADDRESS ELLEN@SFITVA.CC.FITSUNY.EDU
Diane Paul
Fashion Institute of Technology
INTERNET ADDRESS PAULDP@SFITVA.CC.FITSUNY.EDU
212-760-7854