Re: [sqr-users] Dynamic hint error

["Ian Mills" <Ian.Mills@orix.com.au>]

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