[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Dynamic hint error

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