RE: [sqr-users] Issue with convert function in Hyperion 8.5

["Peter Burton" <peter.burton@oracle.com>]

Maddy,

This is an ODBC driver issue.  I tested 8.5.0.3 under Linux and got the 
following error message when trying my test case ..  Looks like things have 
changed from the ODBC driver used with SQR 6.2 ...


Hyperion SQR Server - 8.5.0.3.0.581
Copyright (c) 1994-2007 Hyperion Solutions Corporation.  All Rights Reserved.

(SQR 5528) ODBC SQL dbsql: SQLPrepare error 7332 in cursor 1:
   [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The untyped 
variable ? is allowed only in in a WHERE clause or the SET clause of an UPDATE 
statement or the VALUES list of an INSERT statement


SQL: SELECT convert(datetime, substring(convert(char(10), dateadd(mm, -1,
     ?),101),1,3) + '01' + substring(convert(char(10), dateadd(mm, -1,
     ?),101),6,5))  from dual 

Error on line 14:
   (SQR 3716) Error in SQL statement

Peter

-----Original Message-----
From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of maddy
Sent: Tuesday, October 23, 2007 9:27 AM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: Re: [sqr-users] Issue with convert function in Hyperion 8.5

Hyperion 8.5 installed on Windows XP professional

Thanks

On 10/23/07, Peter Burton <peter.burton@oracle.com> wrote:
> Maddy,
>
> What platform are you running on?
>
> Peter
>
> -----Original Message-----
> From: sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of maddy
> Sent: Monday, October 22, 2007 6:04 PM
> To: This list is for discussion about the SQR database reporting language 
>from Hyperion Solutions.
> Subject: [sqr-users] Issue with convert function in Hyperion 8.5
>
> (SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 102 in cursor 28:
>   [DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]Incorrect
> syntax near '?'.
> Error on line 1629:
>   (SQR 3716) Error in SQL statement.
> Errors were found in the program file.
> SQR: Program Aborting.
>
>
> Iam getting the above error while executing a SQR program using Hyperion 8.5.
>
> convert(datetime,substring(convert(char(10), dateadd(mm, -1, $_gsTo_Date),101
> + '01' + substring(convert(char(10), dateadd(mm, -1,
> $_gsTo_Date),101),6,5)) &FROM_DT
>
>
> The same code works fine in Brio 6.2 . What could be the issue ? Why
> is the above code working when I replace $_gsTo_Date with getdate().I
> couldn't find the general syntax for convert () function in Hyperion
> 8.5.  Please advice.
>
>
> Thanks!
> Maddy
>
> _______________________________________________
> 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
>

_______________________________________________
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