Michael,
You can return multiple cursors from one stored procedure.. In the example
below calling the SP osp_SelectThingsBySSN, the return cursor that I named
curThings will increment if there are multiple selects inside the SP on the
server. (ie.. curThings.. curThings1, etc..)
You will just have to remember which order they are processed.
sParamList = "'" + lcSSN + "'"
nReturn = SQLExec(fhEdge, "Execute osp_SelectThingsBySSN" + sParamList,
'curThings')
** Inside the SP, you could have these two selects:
select * from claimant where ssn = @ssn
select * from invoice where ssn = @ssn
The first select will return curThings.dbf and the second select will
return curThings1.dbf
Hope that answers your question..
Tommy
At 11:10 AM 8/3/2006 -0400, you wrote:
Is it possible to write a stored proc to return multiple cursors to a VFP
call? I've only returned one always in my past dealings with SS.
--
Thanks,
--Michael
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
