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: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Creating Cursor with Fields from Table
Thread ID: 373801 Message ID: 373815 # Views: 44 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, March 27, 2013 10:39:22 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
>
> Peter,
> It is called kind of crosstab. There are actually many ways of doing that. One simple way would be:
>
>
Select Chrtran(Trim(cityName),space(1),'_'), 'C', 20, 0 from city into array laCities
> Create Cursor myCities from array laCities

>
>

> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> My Blog
>

> MongoDb Certified Developer
> MongoDb Certified DBA
>

> Support Wikipedia


Thank you so much Cetin. I am Trying each of the Samples and will let you know soon.

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