ADO - StoredProc returning read/write recordset?

[BeanDog]

How can I get an ADO Stored Procedure command to return a cursor that I can write to or add new records to? For instance, here's my old code:

set cmd = Server.CreateObject("ADODB.Command&quot
cmd.CommandType = adCmdStoredProc
cmd.ActiveConnection = dbads
cmd.CommandText = "qrysClients"
cmd.Parameters.Append cmd.CreateParameter("@pMasterID", adInteger, adParamInput, 0, master)
set qryClients = cmd.Execute

then if I try to do qryClients.AddNew or change a value in qryClients's fields collection, I get errors. How can I resolve this, short of using dynamic SQL queries generated at runtime? The way the code is structured, it would be unrealistic to try to implement a stored procedure to do the updating.



~BenDilts( void );

~BenDilts( void );
benbeandogdilts@cs.com

http://www.geocities.com/benbeandogdilts

Long-time BASIC game programmer, Internet programmer and C++/DirectX of late.