[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] sql-status return -1 in sqr vSQR V6.1.4



Hi
 
Need some, already send an email prior to this on this topic, but I did some
further testing.
 
This is the sqr program I run
begin-program
 
begin-sql on-error=sql-error( 'insert into yp_temp values
(12345,1-feb-2003)')
insert into yp_temp values ('12345','01-feb-2003')
end-sql
 
begin-select on-error=sql-error('select emplid,effdt from yp_temp')
emplid
to_char(effdt,'ddd-dag-yyyy') &effdt
  show 'emplid:' &emplid ' ' &effdt
from yp_temp
end-select
 
begin-sql on-error=sql-error('insert into yp_temp values (12345,100)')
insert into yp_temp values ('12345',100)
end-sql
end-program
 
begin-procedure sql-error($msg)
  show $msg
  show $_sql-error
  show #_sql-status
  show #_return-status
end-procedure
 
I've setup this table:
CREATE TABLE YP_TEMP (EMPLID VARCHAR2(10 BYTE),EFFDT DATE)
CREATE UNIQUE INDEX YP_TEMP ON YP_TEMP (EMPLID, EFFDT)
 
and insert this row:
INSERT INTO YP_TEMP VALUES('12345','01-FEB-2003')
commit
 
When I run this with sqr V6.1.4 it returns this:
SQR V6.1.4
Copyright (C) Brio Technology 1994-2000.  All Worldwide Rights Reserved.
 
insert into yp_temp values (12345,1-feb-2003)
ORA-00001: unique constraint (SYSADM.YP_TEMP) violated
-1.000000
0.000000
select emplid,effdt from yp_temp
ORA-01821: date format not recognized
-1.000000
0.000000
insert into yp_temp values (12345,100)
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
-1.000000
0.000000
 
SQR: End of Run.

When I now run it with sqr V8.45.09, it returns this:
SQR for PeopleSoft V8.45.09
insert into yp_temp values (12345,1-feb-2003)
ORA-00001: unique constraint (SYSADM.YP_TEMP) violated
1.000000
0.000000
select emplid,effdt from yp_temp
ORA-01821: date format not recognized
1821.000000
0.000000
insert into yp_temp values (12345,100)
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
932.000000
0.000000
 
SQR for PeopleSoft: End of Run.

The problem I'm having that some sqc where developed with the understanding
of -1 as sql-error. I'm trying to find out what the cause of this is, the
sqr? or the environmetn?
 
Please provide any feedback you have
 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users