David,
The View Designer in VFP 7.0 is still the same awful rudimentary tool that appeared in 3.0. Except for truly simple one-table views, it is largely useless.
A better tool is Stephen Sawyer's "View Editor", available for download from
www.stephenswyer.com.
You can use it to design a query and simply clip and paste the resulting query code into your own function, method or whatever.
Regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.