>Is there no advantage to CALCULATE in the middle-tier? I can see getting a set of child records in a middle tier, using CALCULATE for SUMS, Standard Deviation, etc. and returning a record set via XML to the client. But then again, I am new to n-tier development.
<

Sure, if you use cursors. But a lot of people are moving toward objects - ADO Recordsets. Look, it does not take a lot of effort to find a way to employ a new features. Certainly, you can use VFP to scan a cursor and generate XML. Not a damn thing wrong with that. My point is that the IN clause, when you get down to it, is not all that significant.