How to Synchronize Disconnected Recordset with Datbase Changes?
- From: "Joseph Geretz" <jgeretz@xxxxxxxxxx>
- Date: Tue, 21 Jun 2005 12:26:21 -0400
VB6, n-Tier, ADO 2.7.
I have a disconnected recordset at the UI. The user makes changes; adding,
deleting and modifying records in this recordset. When it comes time to save
these changes, the recordset is marshalled up to the database tier and batch
updated. Since the nature of the application dictates that the user is the
only one who can be modifying the records involved, I don't bother bringing
the recordset back to the UI since the UI already has the most up-to-date
data.
However, the problem is that the recordset at the UI is now marked with
adds, deletes and modifications which have already been committed to the
database. How do I mark all these changes, in the disconnected recordset at
the UI tier, as having been committed to the database?
Thanks,
- Joe Geretz -
.
- Prev by Date: Unable to Update Data table in Access Database via ADO
- Next by Date: Re: escaping semi colon in connectionstring
- Previous by thread: Unable to Update Data table in Access Database via ADO
- Next by thread: Easiest way to query Dataset and return a Dataset
- Index(es):
Relevant Pages
|
|
