Update a recordset when opened using a stored procedure in ADO  
Author Message
PaulaReno





PostPosted: Wed May 11 04:08:50 CDT 2005 Top

SQL Server Developer >> Update a recordset when opened using a stored procedure in ADO

Hi,

How do you add or update a recordset when you have opened it using a stored
procedure in ADO?
I'm making a program where the user sees a recordset in a grid (using an
ActiveX Grid component).
The user can edit cells. The grid would then normaly call automatically the
Update method of the recordset but since it is a stored procedure it is not
able to do it.
There is also no option to manually set an update string in ADO like in
ADO.NET.

The only way to do it seems to use the RecordChangeComplete Event and then
write my own update query but I just wonder if there isn't a better way.

Thanks a lot
Patrick

----------------------------------------------------------------------------------------
Environment: WinXP / SQL Server 2000 (Integrated Authentication) /
Access 2003 / ADP Access Project / VBA

SQL Server296  
 
 
Patrick





PostPosted: Wed May 11 04:08:50 CDT 2005 Top

SQL Server Developer >> Update a recordset when opened using a stored procedure in ADO Hi,

i might have found my own answer:

How To Intercept UpdateBatch and Call a Stored Procedure
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q191793&ID=KB;EN-US;Q191793

I still have trouble though since I use a function instead of a stored
procedure and get the
"insufficient base table information for updating or refreshing" error on
Recordset.Resync.

If anyone has some ideas on this I would be grateful

Thanks
Patrick