Hi Joseph ---

Did I accidently get CCed with this or was it intentional. I don't mind either way....

What I have done in the past with a VFP front-end and VFP middleware is pass a tablename to the automation object and have the automation object send back a success code. If successful, I can assume that the automation object has created a table with the name I specified....of course, you may want to CLOSE the new table in the Automation object before returning control.

For example:

oSalesInfo = automation object instantiated on frontend
nSuccess=oSalesInfo.SalesbyState("statetemp")
IF nSuccess = 1
   USE statetemp IN 0 SHARED
ENDIF

As to passing back an entire temp cursor or view.....no idea.