[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Issue with convert function in Hyperion 8.5
- Subject: [sqr-users] Issue with convert function in Hyperion 8.5
- From: maddy <madhudvm@gmail.com>
- Date: Mon, 22 Oct 2007 18:03:49 -0400
- Delivery-date: Mon, 22 Oct 2007 18:05:56 -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:mime-version:content-type:content-transfer-encoding:content-disposition;bh=S/u2kba+ZnRRk8rwZkNkSxo6I5Bg62/gsXiejvQkxmg=;b=hc+S4HqdjHG6y2P8/xWfj4qjur/kErpfexiVMmxZDycI5jI9pqzAAr2XckVdO0wa0U3mEQD4Ux9ZBtCBl3lg4YiFmawsW7HLMy9vtg7RXfHHdlAJraq9h7xKDOVHOBWeExLxCnYaNCYdx6dL8PyI1EJtJL/nJFfWDlPZX7JvmFI=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;b=Y91fxuOPdgNUKY2+LTiUflMQI52i+E7sK1y7xm/0PQUyN7oyHYALRXiaGOBYQ9VJsrnmUTXfa3dZnNEn34Do42wOJhKd9a+iNTfrIRvku9XlJfYuW0vJPsANi2+ThM7y6Ei78oHCNkCKfLUB663D50oMVLX2Rq6oTSntbybRRTc=
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
(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