Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: dcNiko Vujke
  Where is dcNiko Vujke?
 Belgrade
 Serbia
 dcNiko Vujke
 Tags
Subject: RE: Text display of grid column
Thread ID: 289199 Message ID: 289204 # Views: 55 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Wednesday, December 29, 2010 1:36:56 PM         
   


> Hi fox(f)i(gh)ters,
> one more question from me.
>
> If value of table column contain characters 'A', 'I' etc.
> can they be displayed as 'Active','Inactive' etc.
> Can this be done without of changing table contents?
> If can, how to set this column values?
>
> Regards,
> Nikola.


CREATE CURSOR xx (kk c(1),otherfield i AUTOINC )
INSERT INTO xx (kk) VALUES ('A')
INSERT INTO xx (kk) VALUES ('I')
INSERT INTO xx (kk) VALUES ('A')
INSERT INTO xx (kk) VALUES ('O')
SELECT CAST(ICASE(kk='A','Active',kk='I','Inactive',kk='O','Overactive') as c(12)) as ss,otherfield FROM xx

Regards
Samir

ENTIRE THREAD

Text display of grid column Posted by dcNiko Vujke @ 12/29/2010 10:21:22 AM
RE: Text display of grid column Posted by Samir H. @ 12/29/2010 1:36:56 PM
RE: Text display of grid column Posted by Marc Lyon @ 12/29/2010 2:10:57 PM
RE: Text display of grid column Posted by dcNiko Vujke @ 12/29/2010 5:18:01 PM
RE: Text display of grid column Posted by dcNiko Vujke @ 12/31/2010 2:04:21 PM
RE: Text display of grid column Posted by Mustapha Bihmouten @ 12/31/2010 2:28:55 PM
RE: Text display of grid column Posted by Samir H. @ 12/31/2010 4:21:50 PM
RE: Text display of grid column Posted by dcNiko Vujke @ 1/4/2011 10:33:18 AM
RE: Text display of grid column Posted by Rahul Moudgill @ 1/4/2011 11:01:21 AM