tanman1975
MIS
I have temporary table created within a stored procedure that I'd like to pass back to a program written in VB 6.0
I know that you could pass cursors out of a stored procedure, but then how would you handle it on the VB side via a DataEnvironment command?
earlier in the program I was able to connect an ADODC control to a stored procedure where the stored procedure only contained a select statement. That worked fine. but when I tried to do the same thing in a stored procedure where data was being massaged in a temp table before the Select statement, of course, it failed. any ideas would be appreciated. Thank you.
I know that you could pass cursors out of a stored procedure, but then how would you handle it on the VB side via a DataEnvironment command?
earlier in the program I was able to connect an ADODC control to a stored procedure where the stored procedure only contained a select statement. That worked fine. but when I tried to do the same thing in a stored procedure where data was being massaged in a temp table before the Select statement, of course, it failed. any ideas would be appreciated. Thank you.