>I have an SQL statement where I'm using global variables as filters. When execute the select, it doesn't seem to recognize the values of the variables and does a general select.
>
>Ex:
>
>SELECT ass_l_ata,s_or_type FROM temp ;
>INTO CURSOR cleared ;
>WHERE s_status = 'Cleared' AND ass_l_dept = gcDeptNo ;
>AND mnemonic = gcProject AND ass_l_grp = gcGroup ;
>ORDER BY ass_l_ata
>
>SELECT ass_l_ata,s_or_type FROM temp ;
>INTO CURSOR outstanding ;
>WHERE ass_l_dept = gcDeptNo ;
>AND mnemonic = gcProject AND ass_l_grp = gcGroup ;
>AND NOT s_status = 'Cleared' ;
>ORDER BY ass_l_ata
>
>VFP doesn't seem to recognize the values of the variables.
>
>Perry
if it couldn't recognize the variables, then you would get error message. It might be, that you have problems with string comparisons.
Edward Pikman
Independent Consultant