syntax error message

[Richard Kreiss]

Laura,

Thanks for the quick response.

Richard

> -----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 Laura
Brody
> Sent: Wednesday, March 10, 2010 12:52 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: syntax error message
> 
> Quoting Richard Kreiss <rkreiss at gccconsulting.net>:
> 
> > For the following code where <L> is the last element of the array
> > who to use when the listbox is displayed,
> >
> > dim who(6) on line 10.
> >
> > <L> can be from 3-6 in value
> [...]
> > Following error message
> >
> >
> > *** A filePro Error Has Occurred ***
> >
> > Line Number: 306
> >
> >         3=mid(who[sl],"1","4");sa=mid(who[sl],"6","30");RETURN
> >                   ^
> > Process contains a syntax error at position indicated.
> >
> > SL is cast in auto process as sl(1,.0)
> >
> > Changed the braces to parentheses and still got the error.
> >
> > Anyone see the error?
> 
> Yes.
> 
> The problem is that MID() does not allow arrays. Assign
> who[sl] to a dummy field and then use the dummy field in
> the MID() statement.
> 
> 
> 
> --
> Laura Brody
> +------------- Hudson Valley Computer Associates, Inc ----------+
> | PO Box 859; 120 Sixth Street   http://www.hvcomputer.com      |
> | Verplanck, NY 10596-0859       Voice mail: (914) 739-5004     |
> +------ PC repair locally, filePro programming globally --------+
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list