By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 2,004 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

How to check which record in the datagrid or recordset has been modified ??

P: 1
I am trying to use VB6 as a middleware between two 3rd party applications.

"App. A" ----> VB6 ------> "App B"



i am having no trouble sending data from VB to the "App B".

But i am having some trouble in reading data from "App A".

I am using a select query to get the recordset of a table in App A in VB. now i am displaying that recodset in a datagrid.

i added a timer which would keep a count on the number of records in the recordset or datgrid and when there is an increment, the last row in the datagrid is inserted into the App B ( provided the datagrid does not display the records alphabetically). This is for the new record addition part.



But how to check which record in the datagrid or recordset has been modified ??

Suppose a record is modified in App A, then the recordset display in the datagrid will change...so how to know which record/row has its data changed? So that i can pick up that row data and insert/overwrite the already available record in App B.



Can anbody help?



Thanks...



with Regards,

Sumit Sinha
Sep 27 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.