Why am I getting a syntax error?

[Jeff Harrison]

--- Kenneth Brody <kenbrody at bestweb.net> wrote:

> Quoting Dan Coutu (Wed, 08 Feb 2006 13:23:52 -0500):
> [...]
> > So I store the name of the filePro file in a
> declared variable called
> > FileName, simple enough. It seemed reasonable to
> want to have a gosub
> > that did a lookup of an existing record like this:
> >
> > lookup fil=(Filename) r=(RecordNo) -ex
> 
> That's perfectly reasonable.
> 
> > (Naturally I had also stored the filePro record
> number to be updated in
> > the declared variable RecordNo.) Well, this
> doesn't work because you
> > can't use a variable for the name of the lookup
> file. Bummer.
> 
> Excuse me?  I use the above all the time, as I'm
> sure do 90% of the
> regulars on this list.
> 
> Can you define "doesn't work"?
> 
[snip]

Perhaps the problem is that there are trailing spaces
within the variable.

Try the following instead:

lookup fil=(Filename{"") r=(RecordNo) -ex

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com