Hi;

I have an text field in report painter and i need to retrieve it in my SQL report.

If $textField = 'XX'
Where country != 'UA'
else
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

-M

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 )

Hi Maria,

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 FOCUS
http://techsupport.informationbuilders.com/sps/73121062.html

Hope this helps.

Cheers,

Kerry