Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

Refreshing ADO not the Greed !!!

Hi

I am getting a live streaming data in an SQL7 Database table every 1sec.

And I have to desplay this streaming data on a Data greed control without refreshing the control but only the ADO Recordset!!!!!!!

A-  What is it best to use :
      1- the Recordset.Resync method or the
      2- the Recordset.Requery method  or
      3-  any  other method?????

How do i do that...?????

Have you any suggestion..........on refreshing ADO and not the Control !!!!!
I am dealing for the fist time with this Methods
0
papaioannou
Asked:
papaioannou
  • 2
1 Solution
 
wsh2Commented:
From MSDN:
--------------------------------------
Use the Resync method to resynchronize records in the current Recordset with the underlying database. This is useful if you are using either a static or forward-only cursor but you want to see any changes in the underlying database.

Use the Requery method to refresh the entire contents of a Recordset object from the data source by reissuing the original command and retrieving the data a second time. Calling this method is equivalent to calling the Close and Open methods in succession. If you are editing the current record or adding a new record, an error occurs.


0
 
papaioannouAuthor Commented:
Is it possible to write a small code example ???
0
 
papaioannouAuthor Commented:
have you any code example?????
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now