Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Boudewijn Lutgerink
  Where is Boudewijn Lutgerink?
 Hoonaardstraat, Driel
 Netherlands
 Boudewijn Lutgerink
 To: Raymond Wong
  
 
 
 Raymond Wong
 Tags
Subject: RE: string data type replacement
Thread ID: 50721 Message ID: 51035 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Wednesday, September 08, 2004 10:06:27 AM         
   


> > > Hi,
> > >
> > > I created a report variable, I think its of data type string.
> > > It has a length limit of 255 characters.
> > >
> > > Is there any other type that I can use to replace the string so I can achieve a longer length & how do I define it under report?
> > >
> > > Thanks,
> > > Raymond
> >
> >
> > You can use the memo data type...
> > in report, if you create a cursor or table---> create cursosr (field1 m)
> >
> >
> > Eye
>
> Thanks guys,
>
> Can I create a variable of type memo in the report itself (not from the form)?
> And how I utilize the memo in the report?
>
> Thanks,
> Raymond

Before running the report you can create a string variable that contains more than 255 chars.
what I did is this:

lcAlphabet = "abcdefghijklmnopqrstuvwxyz"
abc = replicate(lcAlphabet, 16) && 26*16 = 416

When creating the report simply drag a textbox from the report controls toolbar on the form and shape that asif it is a big field.
Rightclick the control and select properties.
In the expression field fill in the name of the variable,
eventually check the "stretch with overflow" checkbox making sure that the whole content of the variable is shown.

HTH

Boudewijn LutgeĀ®ink
There are 10 types of people: Those that do understand binary calculations and those that do not.

ENTIRE THREAD

string data type replacement Posted by Raymond Wong @ 9/5/2004 4:36:11 PM
RE: string data type replacement Posted by Wild Fire @ 9/6/2004 2:20:15 AM
RE: string data type replacement Posted by Paolo Aizon @ 9/6/2004 2:20:28 AM
RE: string data type replacement Posted by Raymond Wong @ 9/6/2004 5:50:59 AM
RE: string data type replacement Posted by Boudewijn Lutgerink @ 9/8/2004 10:06:27 AM
RE: string data type replacement Posted by Raymond Wong @ 9/11/2004 3:19:15 PM