Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: khubaib khalid
  Where is khubaib khalid?
 HaroonAbad
 Pakistan
 khubaib khalid
 To: Ali Koumaiha
  Where is Ali Koumaiha?
 Farmington Hills
 Michigan - Lebanon
 Ali Koumaiha
 Tags
Subject: RE: Replace records
Thread ID: 416372 Message ID: 416374 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2014 3:35:20 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
in report.....

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