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
 Tags
Subject: Replace records
Thread ID: 416372 Message ID: 416372 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2014 2:49:43 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


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