Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Peter Dzuya
  Where is Peter Dzuya?
 Mombasa
 Montana - Kenya
 Peter Dzuya
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: Creating Cursor with Fields from Table
Thread ID: 373801 Message ID: 373803 # Views: 46 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 9:31:18 AM         
   


> > Hi Experts,
> >
> > I wish to know if it is possible to create a cursor and assign the field names from another table. For Example I Have a Remote View Named 'City' that contains three records namely 'Mombasa', 'Nairobi', and 'Kisumu'. Now I want to create a cursor and assign the field names from the remote view 'City'. What would be an alternative if this is not possible.
> >
> >
> > Thanks
> > Peter Dzuya
>
> Select * from yoursource where .F. into cursor yourcursor readwrite




Won't I be getting the contents of The table 'City' In MyCursor. What I need Is, to create Mycursor using 'Mombasa','Nairobi','Kisumu' as Field names from The Table 'City'.

Regards
Peter Dzuya

ENTIRE THREAD

Creating Cursor with Fields from Table Posted by Peter Dzuya @ 3/27/2013 8:18:40 AM
RE: Creating Cursor with Fields from Table Posted by Tore Bleken @ 3/27/2013 8:24:22 AM
RE: Creating Cursor with Fields from Table Posted by Peter Dzuya @ 3/27/2013 9:31:18 AM
RE: Creating Cursor with Fields from Table Posted by Tore Bleken @ 3/27/2013 9:36:37 AM
RE: Creating Cursor with Fields from Table Posted by Peter Dzuya @ 3/27/2013 10:08:05 AM
RE: Creating Cursor with Fields from Table Posted by Jun Tangunan @ 3/27/2013 11:39:05 PM
RE: Creating Cursor with Fields from Table Posted by Vladimir Radjenovic @ 3/27/2013 10:05:47 AM
RE: Creating Cursor with Fields from Table Posted by Peter Dzuya @ 3/27/2013 10:25:37 AM
RE: Creating Cursor with Fields from Table Posted by Cetin Basoz @ 3/27/2013 10:24:20 AM
RE: Creating Cursor with Fields from Table Posted by Peter Dzuya @ 3/27/2013 10:39:22 AM