From the helpfile:
A subquery, referred to in the following arguments, is a SELECT within a
SELECT and must be enclosed in parentheses. You can have one subquery in the
WHERE clause (see that section of the arguments). Subqueries can contain
multiple join conditions.
Also, there is a 9-join limit in VFP SELECT statements.
I see your issue here; my experience is with using a VFP Com server in .NET, so .NET can gain the full advantage of VFP, in terms of businessrules etc. that are integrated into the framework we (Frank Camp, who adapted the framework and did the .NET stuff, and I) use.
Hank
>
> VFP8's cursoradapter>
>I should clarify: the environment in which my associate and I are working is .ASPX and ADO.NET, so I don't think the new CursorAdapter class would work -- unless you have any ideas?
>
>Also, the backend in this case
is VFP. <g> We're using ADO.NET to connect to the VFP7 OLEDB Provider (we'll be upgrading soon to VFP8's OLEDB).
>
>By chance are you able to confirm the limitation? I suppose I could work up a quick test sample, but I'm taking a chance you might happen to know right off the top of your head.