General information
Forum:
Microsoft SQL Server
Category:
Database management
Thanks for the congrats. Everybody is doing great.
Something else must be in play here. The SET NOCOUNT didn't make a difference, I'm still not seeing a result cursor in VFP. I've tried the following cases in the same context, and all return a result set in VFP as expected:
1. simple select from table with result set
2. Single batch command resulting in multiple results
SQLEXEC(nHandle, "exec sp_help_maintenance_plan plan_name", 'csrResult')
3. multiple batch command resulting in multiple results
SQLEXEC(nhandle, "exec select * from table1;select * from table2", 'csrResult')
For some reason this other command is not returning a result set. If it's not obvious, I'll play with it awhile to see if I can figure it out.
thanks again.
jim
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only