OT: foxPro

Richard Kreiss rkreiss at verizon.net
Tue Apr 24 07:56:27 PDT 2012



> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Tuesday, April 24, 2012 10:15 AM
> To: Stanley - stanlyn-com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Getting left and right expression values
> 
> On 4/23/2012 10:30 PM, Stanley - stanlyn-com wrote:
> > Hi Ken,
> >
> >> Use MID(), which is the equivalent of your substr() example.
> > OK, yes I see that, and thanks...
> >
> > Now, what about the left and right functions?  How would you get those
> > parts out of a string?
> [...]
> 
> "left()" is simply "mid()" starting at position 1.
> 
> "right()" is a smidge more involved, but you can use len() to get the
length of
> the field, and use length-n as the mid() starting position to get the
rightmost
> "n" characters.
> 
> --
> Kenneth Brody

The only feature of FoxPro that I would like to see in filepro has to do
with how they treat a memo field.  You can limit its size.  This allows for
placement on a form with the proper size and location and no chance for the
user to put in too much data.

In one of my applications, this would have worked better than a multiline
(fields) that I had to use.  


Richard Kreiss
GCC Consulting

Office: 410-653-2813








More information about the Filepro-list mailing list