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.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05