Can't update result set returned from stored procedure using RDO 
Author Message
 Can't update result set returned from stored procedure using RDO

I have a select stored procedure that I execute from a RDO query
object.  The store procedure works fine and I then build a vaild result
set.  When I try to .Update the row after .edit ing it I get the error
40079 "can't find table to update"

When I use a regular SQL string in my query object instead of the store
procedure everything works fine.

Any ideas?



Mon, 20 Mar 2000 03:00:00 GMT
 Can't update result set returned from stored procedure using RDO

Recordsets based on sp's can never be updated Ever. They are just
snapshots...
--
Brian Moran
Chief Architect
Spectrum Techology Group
SQLServer MVP, MCSE, MCSD, MCT

Check out my monthly SQL column
in Windows NT Magazine!


Quote:
> I have a select stored procedure that I execute from a RDO query
> object.  The store procedure works fine and I then build a vaild result
> set.  When I try to .Update the row after .edit ing it I get the error
> 40079 "can't find table to update"

> When I use a regular SQL string in my query object instead of the store
> procedure everything works fine.

> Any ideas?



Thu, 23 Mar 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Can't update result set returned from stored procedure using RDO

2. Using oracle stored procedures/functions to return result sets

3. Returning a result set from a table using a stored procedure

4. Using Stored Procedure's results in a Stored Procedure

5. returning result sets from stored procedures

6. Returning result sets in oracle stored procedure (OLEDB)

7. return multiple result sets from a stored procedure

8. Returning result set from function to stored procedure is very slooooooooow

9. best way to return a paged result set from a stored procedure

10. Returning a result set from a Stored Procedure

11. returning result sets from stored procedures

12. How not to return multiple result sets from a stored procedure


 
Powered by phpBB® Forum Software