mid statement

[Kenneth Brody]

Quoting Joe Chasan (Fri, 18 Nov 2005 08:31:23 -0500):
[...]
> > > > mid(dtl[30],"1","7") = "WC80597"
[...]
>   MESGBOX "You were born in the year" < mid(InfoFile[5],"7","4")
>
>     The above line gets 4 characters starting in position 7 from
>     field 5 in the file named InfoFile."
>
> to me says that it should be possible and having duplicated it
> seems to me to be a bug.
[...]

One is an rvalue and the other is an lvalue.

This used to be not permitted at all, but a new 5.0 feature was:

    MID()
        When used as an r-value, can take an expression as the first
        parameter.  Remember that if a "real" expression is used that
        the result is not necessarily in the format that you might
        expect [ie: "1"/"2" returns a (25,F) formatted field].  Mostly,
        the purpose is to allow any field, such as lookup fields, as the
        first parameter.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com