RE: [sqr-users] From-Thru Dates

["radhika reddy" <radhika_05@hotmail.com>]

Thanks but i am getting the following error:-


SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 2:
   ORA-00904: "SEP": invalid identifier


In the select statement:

j.action_dt between 05-SEP-1988 and
      10-SEP-2004 ORDER BY J.EMPLID

Error on line 240:
   (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.


why is it so? do i have to change the format of j.action_dt. but it's 
working fine when i am giving the expression itself as j.action_dt between 
{Datein-Prefix}$FromDate{Datein-Suffix} and 
{Datein-Prefix}$ThruDate{Datein-Suffix}. but i am getting this error when i 
am using dyanamic variable.

Thanks,
Radhika

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to 
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


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