Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 To: Tahir Iqbal
  Where is Tahir Iqbal?
 Lahore
 Pakistan
 Tahir Iqbal
 Tags
Subject: RE: Devide Rows
Thread ID: 373581 Message ID: 373582 # Views: 49 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Saturday, March 23, 2013 5:46:26 PM         
   


> I have following data
>
>
> Create Cursor diary (names c(10), mobile c(3))
> 
> Insert Into diary Values("A","123")
> Insert Into diary Values("F","128")
> Insert Into diary Values("C","147")
> Insert Into diary Values("E","654")
> Insert Into diary Values("X","258")
> 
> 

>
> I want to show this data into diary2 as
>
> Create Cursor diary2 (names c(10))
>
> A
> 123
> F
> 128
> C
> 147
> E
> 654
> X
> 258
>
> First column will be first row and second column will be second row.


Create Cursor diary2 (names c(10))

SELECT diary 
Scan
	Scatter Memv
	Insert Into diary2 Values(m.names)
	Insert Into diary2 Values(m.mobile)
Endscan

SELECT diary2 
Brow


_______________________________
Impossible is not a fact. Its an opinion.

ENTIRE THREAD

Devide Rows Posted by Tahir Iqbal @ 3/23/2013 5:19:50 PM
RE: Devide Rows Posted by Tariq Mehmood @ 3/23/2013 5:46:26 PM
RE: Devide Rows Posted by Anders Altberg @ 3/23/2013 8:20:38 PM