Why am I getting a syntax error?

Nancy Palmquist nlp at vss3.com
Wed Feb 8 14:56:50 PST 2006


Dan Coutu wrote:
> Kenneth Brody 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
>

Dan,

It has been my experience that two variables don't work but that might 
be an old bug, that I never noticed was fixed.

I might suggest another solution, use a dummy variable for the record 
number, then the filename will work just fine. (Just did this today for 
an app.)

rn(8,.0)=RecordNo

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

(it may be true as Ken suggests that a filePro lookup will work without 
the {"" but an EXPORT or IMPORT does not.  I just get in the habit to do 
it and save myself issues.)

Nancy


-- 
Nancy Palmquist 		MOS & filePro Training Available
Virtual Software Systems	Web Based Training and Consulting	
PHONE: (412) 835-9417		   Web site:  http://www.vss3.com



More information about the Filepro-list mailing list