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
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.