How do I return a resultset(cursor)

[rombout]

How do I return a resultset(cursor) from an automation server(dll) made in Fox Pro. I call the dll with the createobject funtion. In the dll I retrieve the data from an SQL server database with SQL-pass through. There was data retrieved and a cursor created in the dll but when I am out the dll method I cant't find the cursor in any workarea.

Thanks and Greetings Rombout

 

[DSummZZZ]

Since the .dll is essentially another instance of a VFP app running, you would need to make the data available just as if you had VFP running twice with separate data sessions etc., like copying the file to an available table, or passing the reference to the temp table back.

Dave S.

 

[Mike Gagnon]

You would have to return a table, not a cursor.

 

[rombout]

How do I pass the reference to the temp table back. How does this reference look.

Thanks Rombout

 

[DSummZZZ]

After running the query, you could either do a COPY TO ... to a file that the app will know the name of, or send back the name of the cursor using something like:

SQLEXEC(handle, 'SELECT * FROM SomeTable', 'MyCursor')
STORE DBF('MyCursor') TO QryName

Then send back "QryName".

Dave S.

 

[rombout]

Thanks a lot. Greetings Rombout