February 14, 2006, 11:59 AMMaria Tan
dynamic query for report painter
I have an text field in report painter and i need to retrieve it in my SQL report.
If $textField = 'XX'
Where country != 'UA'
where country like $textField.
Since i did everything through DevStudio, i don't know the focus language. Can you tell how can i write it in focus language.
Thanks in advance
February 14, 2006, 02:26 PMTerryW
Using the values you provided, the syntax would be something along the lines of:
WHERE ( $textField EQ 'XX' AND country NE 'UA' )
OR ( $textField NE 'XX' AND country LIKE $textField )
February 20, 2006, 01:56 PMKerry
Has this issue been resolved? Did Terry's suggestion help you?
I ran a quick search on Information Builders' online documents and came across the following topics which may be of interest:
How to pass a dynamic value to an Oracle stored procedure?http://techsupport.informationbuilders.com/ibi/sps_i/83521040.html
Dynamic WHERE with OR's do not get translated by FOCUShttp://techsupport.informationbuilders.com/sps/73121062.html
Hope this helps.