[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Dynamic hint error
- Subject: Re: [sqr-users] Dynamic hint error
- From: "世哲黄
" <eric.s.huang@gmail.com>
- Date: Wed, 20 Sep 2006 16:56:20 +1000
- Delivery-date: Wed, 20 Sep 2006 02:58:30 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;b=pdIs809jMB0yzGYt5pxKmeqx6VfLQoLlit+e+sLO9fQM/TFWrQBTZEmJ0L12IXxNT4acDUvZgff1ZTjImpVNQEPZmX8xxgwjhrMZY1oKeV59es0wg3z4TijI5K3GUauNy9sqqpdm2yg3EyiSdNk8RoeY1R6+fJbMhq/1kOLqazM=
- In-reply-to: <s5116d26.088@nwedengw7.orix.com.au>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- References: <s5116d26.088@nwedengw7.orix.com.au>
Thanks Ian, but if deleting &hint=char, it will bring another error
"(SQR 3743) Dynamic columns must have a &pseudonym."
Regards
Eric
On 9/20/06, Ian Mills <Ian.Mills@orix.com.au> wrote:
>
> Eric,
>
> Try deleting &hint=char
> Having this makes SQR think it is refering to a column named "/*+
> full(SFL)*/)"
>
> Regards,
> Ian
> ORIX Australia Corp Ltd
>
> >>> eric.s.huang@gmail.com 20/09/2006 4:19 pm >>>
> Hi,
>
> I am trying to use a dynamic hint in my SQR like this:
>
> if ($bill = 'S' or $bill = 'A')
> let $hint = ' /*+ full(SFL)*/)'
> else
> let $hint = ''
> end-if
>
> begin-select on-error=ERROR-DISPLAY
> [$hint] &hint=char
> SF.EXT_ORG_ID
> SF.CONTRACT_NUM
> SF.EMPLID
> FROM PS_ITEM_SF SF, PS_ITEM_LINE_SF SFL
> WHERE SF.BUSINESS_UNIT = $business_unit
> AND SF.BUSINESS_UNIT = SFL.BUSINESS_UNIT
> AND SF.ITEM_NBR = SFL.ITEM_NBR
> AND SFL.BILLING_FLAG <> 'Y'
> end-select
>
>
>
> When I set "bill = S or A" and run this SQR, it comes out an error:
> "DB-Error in C:\SQR\002.sqr at line 322: ORA-00936: missing expression"
> otherwise, it runs successfully.
>
> Does anybody help me out of it? Thanks a lot.
>
>
> Cheers
>
> Eric
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
> --
>
> This message from ORIX Australia might contain confidential and/or
> privileged information. If you are not the intended recipient, any use,
> disclosure or copying of this message (or of any attachments to it) is
> not authorised.
>
> If you have received this message in error, please notify the sender
> immediately and delete the message and any attachments from your
> system. Please inform the sender if you do not wish to receive future
> communications by email.
>
> ORIX handles personal information according to a Privacy Policy that is
> consistent with the National Privacy Principles. Please let us know if
> you would like a copy. It is also available at http://www.orix.com.au .
>
>
>
> _______________________________________________
> 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