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: 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: 373391 # Views: 60 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 9:30:17 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?
>

You could use a local view instead and then REQUERY() the view. Or just run the query again and then Requery() the comboboxes.

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