Hello,
I am having a problem where I use the data environment to execute a stored procedure that returns a recordset but the data environment doesn't show those fields. It treats it as a command instead.
I am using VB6 SP5
I am using SQL Server 2000
I have found that if the stored procedure that I am executing uses a temporary table, then the data environment treats it as a non-recordset returning command. Can anyone tell me what I can do to make it return the recordset and fields so I can use it in Crystal Reports designer (which requires the data environment to have the fields)
If I run the stored procedure in SQL Server, it does return a result set.
I am having a problem where I use the data environment to execute a stored procedure that returns a recordset but the data environment doesn't show those fields. It treats it as a command instead.
I am using VB6 SP5
I am using SQL Server 2000
I have found that if the stored procedure that I am executing uses a temporary table, then the data environment treats it as a non-recordset returning command. Can anyone tell me what I can do to make it return the recordset and fields so I can use it in Crystal Reports designer (which requires the data environment to have the fields)
If I run the stored procedure in SQL Server, it does return a result set.