Matthew,
Have you checked the help files for DataTable.Select? It returns an array of DataRows instead of a DataSet, but it might work faster than going back and forth between xml and Fox functions.
Hope that helps,
---J
>If I create a DataSet with a command like:
>
>DataSet dsOrders = this.GetDataSet("SELECT * FROM orders WHERE conditions")
>
>Is it possible to then run a second SQL against the resulting DataSet? I can accomplish this in SQL Server with the following:
>
>CREATE VIEW dsOrders AS
>SELECT field1, field2 FROM myTable WHERE conditions
>
>SELECT field1, field2 FROM dsOrders WHERE moreconditions
>
>I have a complex query that returns a DataSet that I would then like to run several other queries against. Thanks in advance for any suggestions.
>
>Kind Regards,
>
>Mat