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


> > Hi,
> >
> > I have created a cursor from a parent database as follows:
> >
> > select 0
> > select fielda,fieldb from masterdatabase into cursor mycursor readwrite
> >
> > Once the cursor mycursor is created, it is used as an data source for multiple combo boxes on the form.
> >
> > However, the masterdatabase.dbf can change very frequently and I want to be able to 'refresh' the cursor mycursor using a command to get the latest data from the masterdatabase into mycursor without creating any data instability in the combo boxes that rely on the mycursor. Is there any easy way to do that?
> >
> > Thanks
> >
> > Zoom
>
>
> 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

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