Hi!
Just put the result into temporary TABLE, close it, then using {32-character key} + FileToStr(DBF file) + {32-character key} + FileToStr(FPT file) return it as a string (after deleting temorary DBF). At the client side, using 32-character key, separate DBF anf FPT files, write them to disk into temporary file and open as usual DBF. Clean up it after work.
You can also convert cursor into ADO record set that is also very good fr passing data sets across COM boundaries.
HTH.
>Hello all,
>
>I have a Custom Public OLE server with a method exacuting many SQL statements and at the end is preparing a final cursor ready for reporting.
>
>What is the best method returning cursor results to the client computers?
>
>What I am doing now, I write the results in a DBF file on the Server conmputer.
>
>Note : I cannot return cursor because the result is very big.
>
>
>Thanks in advance
>Petros
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.