Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select
Message
 
To
05/05/2006 13:59:43
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Re: Select
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
01119685
Message ID:
01119781
Views:
17
Thanks every one for all of your hard work and help.

I was able to solve this.

This is what I need up doing:
*//Master Cursor
SELECT regno, ccstatus, ;
      IIF(Inlist(Alltrim(ccstatus),'A','P'),.T.,.F.)  as lPrnt;
      FROM cTemp;
      ORDER BY regno ;
      Into Cursor cRegno

*//Invalid
  SELECT regno from cRegno ;
 	where lPrnt = .F. ;
	Group by regno order by regno into Cursor cInvalid

*//Valid
  SELECT regno from cRegno ;
  where regno not in (select regno from cInvalid);
  Group by regno order by regno ;
  Into Cursor cValid
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform