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: k doc
  Where is k doc?
 Chicago
 Illinois - United States
 k doc
 Tags
Subject: RE: How to 'refresh' a cursor?
Thread ID: 373302 Message ID: 373305 # Views: 81 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 4:18:22 AM         
   


> 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.

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