Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Tamar Granor
  Where is Tamar Granor?
 Elkins Park
 Pennsylvania - United States
 Tamar Granor
 Tags
Subject: RE: How to 'refresh' a cursor?
Thread ID: 373302 Message ID: 373441 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 6:55:57 AM         
   


> >
> >
> > Requery method:
> >
> >
Thisform.combo1.Requery()
> > 

> >
> > It will fetch the latest set of records based on your SQL SELECT.
>
> But only if the query itself is the RowSource. It sounded like he runs the query once and then uses the resulting cursor as the RowSource.
>
> Tamar


If that is the case, then either perform an SQL SELECT again on the combobox or create a method for that SQL SELECT requirement so he can simply call it again? I prefer though RowSourceType = 3 over others because it is easier to control plus will work on a simple .Requery() for fetching the new sets.


http://sandstorm36.blogspot.com
http://weblogs.foxite.com/sandstorm36

ENTIRE THREAD

How to 'refresh' a cursor? Posted by k doc @ 3/21/2013 3:39:34 AM
RE: How to 'refresh' a cursor? Posted by Jun Tangunan @ 3/21/2013 4:18:22 AM
RE: How to 'refresh' a cursor? Posted by Tamar Granor @ 3/21/2013 9:29:36 PM
RE: How to 'refresh' a cursor? Posted by Jun Tangunan @ 3/22/2013 6:55:57 AM
RE: How to 'refresh' a cursor? Posted by Tamar Granor @ 3/21/2013 9:30:17 PM