Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mustapha Bihmouten
  Where is Mustapha Bihmouten?
 Casablanca
 Morocco
 Mustapha Bihmouten
 To: dcNiko Vujke
  Where is dcNiko Vujke?
 Belgrade
 Serbia
 dcNiko Vujke
 Tags
Subject: RE: Text display of grid column
Thread ID: 289199 Message ID: 289398 # Views: 36 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Grids
Date: Friday, December 31, 2010 2:28:55 PM         
   


> Hi Marc,
>
> problem occurs when expression:
>
> "ICASE(cStatus=[A], [Active], cStatus=[I], [Inactive], cStatus=[R], [Ready], [WTF])"
>
> have more than 255 characters. In this case I get error message.
> Is there a way to use a expression longer then 255 characters?
>
> Regards,
> Nikola.

Hello Nikola

use Textmerge capability to pass the 255 limit see Text ...EndText command in help file

Text to m.lcStatus TextMerge NoShow PreText 7
  ICASE( cStatus ="A", "Active", cStatus ="I", "Inactive", 
         cStatus ="R", "Ready", ...
         ...
         ...
EndText

then in your grid :
Grid.Column.ControlSource = m.lcStatus


Notes :
Don't use ";" to terminate line : we use PreText values
Pretext values are additive
1 Eliminate spaces before each line.
2 Eliminate tabs before each line.
4 Eliminate carriage returns, for example, blank lines, before each line.

so 7 will use all values 1 + 2 + 4

Regards
Mustapha Bihmouten

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