>I can see some people have been having problems with something that I would like to do. These are the steps:
>1. Use a VFP MTDLL COM object as the database engine for my ASP web application (not asp.net, just classic asp).
>2. Call the COM object from my ASP app and have it do the database i/o, ultimately producting a VFP cursor, which may be the end result of several subqueries, etc.
>3. Convert the cursor to an ADO recordset with minimal overhead
>4. Pass the recordset reference back to the ASP application
>
>CursorAdapter does not go in this direction. Only RStoCursor. So what's the best way to do this? Thanks very much!
Check SetResultSet in VFP9.
Also ASP can use ADO directly if you save resulting data to a temp table and return its name. With this approach you might even get more complex structures like hierarchical recordsets which CursorToRS and RSToCursor cannot handle - maybe updated version does, I don't know- (saving few related resultsets into temp tables). XML of course is an option but would be slower IMHO.
Cetin