Help: Editing field values of ADO recordset from SQL db 
Author Message
 Help: Editing field values of ADO recordset from SQL db

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 appriciate 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 ADO recordset from SQL db

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 appriciate 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
 
 [ 2 post ] 

 Relevant Pages 

1. Help:Editing field values of an ADO recordset returned from SQL SP

2. Editing a field value in a ADO Recordset

3. Help with ADO Recordset when field value contains quotes

4. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

5. Assigning Null value to field of ADO Recordset

6. How to get fields value from ado recordset?

7. Count values from field in ADO Recordset

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

9. cannot read long varchar field values from ADO Recordsets

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

11. Help: Finding Error Field in a DB Insert/Update/Edit Exception

12. HELP: Problem with Recordset->Fields(index)->Value


 
Powered by phpBB® Forum Software