473,396 Members | 1,871 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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
0 1716

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

Similar topics

20
by: | last post by:
If I need to check if a certain value does exist in a field, and return either "yes" or "not" which query would be the most effestive?
17
by: Danny J. Lesandrini | last post by:
The following code works with a standard MDB to navigate to a particluar record (with a DAO recordset, of course) but it's giving me problems in an ADP I'm working on. Dim rs As ADODB.Recordset...
1
by: Jordan Marton | last post by:
Two questions here. 1) Is it possible to make a vertically setup datagrid. Basically, i am populating the grid with only information from one record, and I want it to list downwards as opposed...
3
by: mike | last post by:
I'm writting a q&a chat application and hae a small refeshing IFRAME to check if there has been a new or modified chat item written, if so the main chat window refreshes and the datagrid gets...
4
by: Rico | last post by:
Hi All, Just wondering, in vb code, how to if the last record on a cascading form is the current record? Thanks!
1
by: Tom Bianchi | last post by:
Hi, I am using VS2005. I have a form that I use both to insert new records and modify existing records. I want that if the user tries to close the form, the application asks the user to save...
6
by: San | last post by:
Hey, I need to create a form with several text boxes in which users type in key words, press a command button on the form and it opens a matching record. Thanking you in advance.
8
by: Iona | last post by:
Hi Allan, I'm using a nifty piece of code you put on here some time back to do a duplicate entry check as below. I'm using to check for duplicate names. However I am getting an error message on...
3
by: Kosmos | last post by:
Hey ya'll...I can't seem to figure out why I'm getting this error message, but it all started when I added the new line of code with the recSet5.AddNew --- when I ran the first line, the logic worked...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.