Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ali Koumaiha
  Where is Ali Koumaiha?
 Farmington Hills
 Michigan - Lebanon
 Ali Koumaiha
 To: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 Tags
Subject: RE: Replace records
Thread ID: 416372 Message ID: 416373 # Views: 44 # Ratings: 3
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2014 3:03:23 PM         
   


>
> CREATE CURSOR recnaw ;
>  (sno N(5), Name Character(20), city C(30))
>  
>  INSERT INTO recnaw (name,city) VALUES ('khubaib','Lahore')
>   INSERT INTO recnaw (name,city) VALUES ('khubaib','pak')
>    INSERT INTO recnaw (name,city) VALUES ('khubaib','Hnd')
>     INSERT INTO recnaw (name,city) VALUES ('baba','Lahore')
>      INSERT INTO recnaw (name,city) VALUES ('baba','pak')
>      
>      now i want to record like this:first need name then city and need name only one time .
>      
>      khubaib
>      Lahore
>      pak
>      Hnd
>      baba
>      Lahore
>      pak
> 


Are you displaying this in a report? a grid?
Not clear what you want to do.

In a report, it's easy


create a report and add a group by name in the report.
put the name label in the group header and the city in the group detail.

then do this.

simply query your table:
example:
select name,city from recnaw order by name,city into cursor curTemp
select curTemp
report from YourReportName to printer prompt preview 


Ez Logic

ENTIRE THREAD

Replace records Posted by khubaib khalid @ 12/28/2014 2:49:43 PM
RE: Replace records Posted by Ali Koumaiha @ 12/28/2014 3:03:23 PM
RE: Replace records Posted by khubaib khalid @ 12/28/2014 3:35:20 PM
RE: Replace records Posted by Zia Mughal @ 12/28/2014 6:11:49 PM