Question re updating status of a single record 
Author Message
 Question re updating status of a single record

Using a disconnected ADO recordset, is there any way to update the Status of
a single record so that it becomes adRecUnmodified? (Without connecting to
the database and issuing rs.UpdateBatch, or otherwise updating the
database).

You can do this for the whole recordset by rs.UpdateBatch, but I need to do
it for one record.

You can't update the Status property, and you can't directly update
.OriginalValue.

Any ideas on how to accomplish this would be greatly appreciated.



Thu, 21 Aug 2003 01:17:53 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Updating a single OLE link for a record OR updating existing database

2. How to avoid single quotes present in fld name while updating a record

3. Deleting all records then adding new ones in a single update

4. Tools/Options/Calculation/Updating task status updates resource status

5. Question on imbedded single quotes in Record Find stat

6. Question on imbedded single quotes in Record Find stat

7. Acc97 - Merging Multiple Records into a Single Record

8. Module-level multiple-record recordset vs temp single-record recordset

9. Module-level multiple-record recordset vs temp single-record recordset

10. VB6 ADO and Multiple Records/Single Records

11. question re getting updated record count

12. Newbie Question about updating records

 

 
Powered by phpBB® Forum Software