Help:Editing field values of an ADO recordset returned from SQL SP 
Author Message
 Help:Editing field values of an ADO recordset returned from SQL SP

I'm using ADO to get a recordset back from a SQL server stored procedure. I
need to edit the contents of some of the fields in the recordset before the
data is passed up to the client.

Opening the recordset as dynamic allows field values to be edited, but
stored procedure calls then fail giving error "cant open a cursor on a
stored procedure that has anything other than a single select statement in
it" . The stored procedures only have one select statement that returns
data, but have others to assign values to local variables. If the recordset
is opened in a read only mode, the error doesn't occur, but then I can't
edit the values.

Would appreciate any help on how I can work around this error, or edit
values of recordsets some other way.


Cheeers,
 William



Sun, 12 Nov 2000 03:00:00 GMT
 Help:Editing field values of an ADO recordset returned from SQL SP

If your recordset isn't too big, and you're using ADO 1.5, using a recordset
.CursorLocation of adUseClient will avoid this error.

--
Bob Pfeiff
MCSD, MVP
Spectrum Technolgy Group, Inc.



Mon, 13 Nov 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Help: Editing field values of ADO recordset from SQL db

2. Editing a field value in a ADO Recordset

3. ADO return Date Format for a recordset field value (VC++)

4. ADO return Date Format for a recordset field value (VC++)

5. Help with ADO Recordset when field value contains quotes

6. Help: Returning a value to Access from a SQL sp

7. Wrong Identity field returned from an ADO Recordset quering SQL - Causes

8. Returning ADO Recordset from SP Temp table

9. Returning ADO Recordset from SP Temp table

10. VB6 ADO CMD object for Sp returning a recordset

11. SP w/ADO not returning recordset

12. SP not return value when using ADO...


 
Powered by phpBB® Forum Software