I don't think u could run query with record set object.(but don't take my 

word for it...)

Why don't u use SELECT INTO to store the result to temp table. that way u 

could run the query against that temp table.

Using cursor is another option.



BB.



> Is it possible to run SQL queries against Recordsets? e.g. (SELECT * 

FROM 

> rsObject) 

> In Foxpro I used to run SQL queries and store the results into a cusror. 

> Then I could do anything with this cursor including running an sql query