I have a fairly complicated piece of SQL select that I need to make available to an outside party (who will be using, AFAIK, Access, of all things). Since the ODBC dbf driver is hopelessly stuck in the XX century (supports VFP6 features and wasn't updated since), I tried OleDB. It should be something that Access people should be familiar with.

However, the select involves two levels of subquery, or just one if I break it into two pieces (or none, if I break it even further). The trouble is how to persist the temporary cursors across calls, or how to issue multiple statements in one oConn.Execute (lcScript ) call. Neither works; I'm either getting syntax error or missing clause error.

After searching UT, Sergey's and the wiki, I'm no smarter than before. The examples everywhere go as far as "select * from customer", and show maybe how to update the customer table. None of the examples involve subqueries, or temp cursors being reused in the next select... so, am I the first to do this?

I hope not, and that someone will tell me where's the switch to turn this on.