Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Roland Nyberg
  Where is Roland Nyberg?
 SODERTALJE
 Sweden
 Roland Nyberg
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: Variable don´t accept content
Thread ID: 228344 Message ID: 228538 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: General VFP Topics
Date: Tuesday, May 19, 2009 6:05:41 PM         
   


> You cannot create literal strings over 255 characters. However, you can create a big string as a string variable by concatenating multiple strings.
>
>
cString1 = 'This is a string literal - anything included between quotes or square brackets'
> cString2 = 'This would be a long string that is over 255 characters'+;
> ' in length. We can't do that having the big string between a pair'+;
> ' of quotes or square brackets. We need to divide it into pieces like in this sample '+;
> ' and concatenate to create the big string variable. We don't even need'+;
> ' to count if we have exceeded 255 characters limit.'+;
> 'Using text ... endtext is another way and it generally is more practical as in the next sample.'
> 
> TEXT TO pcSearchUnivStr NOSHOW
> (UPPER(Tbldocintr.intrid) = '' and 
> (UPPER(Tbldocintr.intrtype) = 'GRP')) and 
> UPPER(tblAccDocs.accessCode) = '1' and 
> UPPER(tblextfiles.filename) LIKE UPPER(m.pcSrchStrUniv+'%') 
> and 
> (?m.pnGrpOnlyMineValue = 0 and 
> ?m.pnGrpArchValue = 0 and 
> tblDocIntr.intrarch = 0 and 
> ...
> ENDTEXT
> 
> pcSearchUnivStr = CHRTRAN(m.pcSearchUnivStr,CHR(13)+CHR(10),' ')

>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)

Thank you Cetin and Stefan!
Concatenating multiple strings works just fiine.

Best regards
Roland

ENTIRE THREAD

Variable don´t accept content Posted by Roland Nyberg @ 5/18/2009 12:03:35 PM
RE: Variable don´t accept content Posted by Cetin Basoz @ 5/18/2009 12:19:36 PM
RE: Variable don´t accept content Posted by Roland Nyberg @ 5/19/2009 6:05:41 PM
RE: Variable don´t accept content Posted by Stefan Wuebbe @ 5/18/2009 12:25:17 PM
RE: Variable don´t accept content Posted by Cetin Basoz @ 5/18/2009 12:31:56 PM
RE: Variable don´t accept content Posted by Stefan Wuebbe @ 5/18/2009 12:46:49 PM