>I know this is may not the an issue with vfp9, however my client is using vfp6 and I cannot tell them to upgrade. I need to a way using vfp 6.
Mahmood,
try this
CLOSE DATABASES ALL
CREATE CURSOR Test (Regno I)
FOR m.prom1 = 1 TO 50
INSERT INTO Test VALUES (m.prom1)
INSERT INTO Test VALUES (m.prom1)
NEXT
CREATE CURSOR myfilter (kod I)
INSERT INTO myfilter VALUES (12)
INSERT INTO myfilter VALUES (41)
INSERT INTO myfilter VALUES (50)
INSERT INTO myfilter VALUES (51)
SELECT Test.regno;
from Test;
LEFT JOIN myfilter ON Test.Regno = myfilter.kod;
Where ISNULL(myfilter.Kod);
group by Test.Regno order by Test.Regno
HTH
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
