Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Year Function - Comparison's of Years
Thank You that seemed to work. So simple if you know how.- krbgrx
- Post #4
- Forum: Oracle: All versions
-
Year Function - Comparison's of Years
I am getting an error message in a Stored Procedure using the Line: and YEAR(APC.dtEffective) = EffectiveYear Effective year will have a year in it(Ex: 2000), and apc.dteffective is a date field from a table. The error message that I am getting is: PLS-00201: identifier "YEAR"...- krbgrx
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
automation error using 8.5 and RDO access database.
I am getting am Automation error with the following code. I am using CR 8.5 and a Access 98 MDB using ado. cr1.ReportFileName = App.Path & "\claim2.rpt" 'set the database password so crystal reports can access the data. cr1.Connect = gs_dbPassword 'set the...- krbgrx
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 4 Other topics
