[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Issue with convert function in Hyperion 8.5
- Subject: Re: [sqr-users] Issue with convert function in Hyperion 8.5
- From: maddy <madhudvm@gmail.com>
- Date: Tue, 23 Oct 2007 09:27:13 -0400
- Delivery-date: Tue, 23 Oct 2007 09:32:32 -0400
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;bh=58a7b5khaXxD0cg39UaoMiEoB6SihAXZeiTyR3WmwEs=;b=VzSA6le5pSxQdF2QE/s80XrH9FoarZI1Mefsd/b59KobB5/aOzMN7m7LVlsw7qpQ0jcgf5t6EHmRUQATyddEOiU+5Poyqna+0E2Uk5FEXGEnQtUkPFgU67Lk/HUEd1D5J6v3D/1g5tZPltgCIaMSmlYhMzsvOMDiPDo/Ubmv/F4=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;b=qd3Z7W1WEHvJDyu57R36WJyY8lrNFgwU3x4wOYdhGcu4hLthoHzQoEgXwrd2h4w5nutWoZOTQCkb0LfFATUozdnFCY10OtO5kIpE8lHjXdHvQxLGUQwa1IXI9RwDBGZAzlZwgCNvOi6d22tnDRU+Nva/3SHhGpRm+PjBKnQ1k6w=
- In-reply-to: <20071023063854721.00000004828@PBURTON2>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <f09cef0f0710221503qfc8092fxe626bc71da3e7ea0@mail.gmail.com><20071023063854721.00000004828@PBURTON2>
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