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

RE: [sqr-users] SQR V8.1 and Timestamp fields in Oracle 9i

I had the same issue when we converted to a new version of ADP and the
Audit Stamp date fields changed to a timestamp field - when I selected
the field as follows:
 {DateTimeOut-Prefix}AP.AUDIT_STAMP{DateTimeOut-Suffix} &AP.AUDIT_STAMP 

Then I was able to use the to_char Oracle function on that field.  I
have had to use the {DateTimeOut-Prefix} and {DateTimeOut-Suffx} in all
my selects on the new Stamp fields.


Tracy Stieglitz
Lead Systems Analyst
Menasha Corporation
Phone: (920) 751-1100
Email: tracy.stieglitz@menasha.com
 

-----Original Message-----
From: sqr-users-bounces+tracy.stieglitz=menasha.com@sqrug.org
[mailto:sqr-users-bounces+tracy.stieglitz=menasha.com@sqrug.org] On
Behalf Of John Czekaj
Sent: Monday, December 19, 2005 8:37 AM
To: sqr-users@sqrug.org
Cc: patricia_corey@adp.com
Subject: [sqr-users] SQR V8.1 and Timestamp fields in Oracle 9i

Are there any known issues (or bugs) with SQR V8.1 and Oracle 9i
TIMESTAMP datatype fields?  I have an SQR that selects a timestamp field
on one line and tries to do an Oracle to_char to that same field on the
next line.  When the first select on this timestamp field is commented
out, the program runs, however, when both are in the select statement,
the following error is received:
   
  (SQR 1305) CMPSQL: Unknown data type in database:  187
   
  SQR:  Program Aborting
   
  (SQR 1305)  CMPSQL : Unknown data type in database: 187
   
  SQR:  Program Aborting
   
  Any assistance would be greatly appreciated.  Thanks to all who
respond. BTW, Oracle 9i is running on a Windows 2000 Server machine.
   
  Regards,
   
   
  John Czekaj, Consultant
  ADP National Accounts - Professional Services

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com 

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

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