Problem with Dots in Filenames and Lookups

[gcc at optonline.net]

----- Original Message -----
From: Mike Rathburn <mike at datadoit.com>
Date: Monday, March 28, 2005 12:19 pm
Subject: Problem with Dots in Filenames and Lookups

> fP ODBC v1 on Winderz
> 
> We did a conversion from UNIX to Windows, and now a specific 
> report will
> give a syntax error.  The report is being run from a file called 
> pr.trx.The syntax error is coming from the code below, putting the 
> pointer where
> the filename's dot is (as if it doesn't like the filename with a 
> dot in it).
> 
> This report still runs fine from the old 4.5 UNIX system.  Only 
> bombs on the
> fPODBC v1 Windows system.  What's weird is that apparently (so 
> far) there
> seems to be no other issues with filenames and dots in those 
> filenames.There are a gozillion other lookups in other processing 
> tables, input and
> output.
> 
>        	If:	
>        	Then:	lookup ap.initems  k=ud   i=e -ng
> loopdes	If:	not ap.initems
>        	Then:	return
>        	If:	ap.initems(1) ge ud+"100"
>        	Then:	return
>        	If:	
>        	Then:	ub(9,.2)=ap.initems(3)*ap.initems(5)
>        	If:	ap.initems(24) ne 1
>        	Then:	getnext ap.initems; goto loopdes
> 
> The syntax error looked like:
> 
> ap.initems(1) ge ud+"100"
>  ^
> 
> At any rate, I changed the lookup to:
> 
> lookup apinitems = ap.initems  k=ud   i=e -ng
> 
> and subsequent references to the lookup variable, and now all is well.
> There was one other lookup in this particular output processing 
> table that
> looked like:
> 
> lookup ap.po  k=6  i=e -nx
> 
> That I also had to change to a variable for the same reason.
> 
> Any idea as to why this particular lookup with a dot in the 
> filename would
> produce a syntax error?
> 
> -MikeR
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> 
Mike,

Do you actually have a file called "ap.initems"?

Windows is still looking for a 3 character extension.

Check your file names.  they should be filename.(ext), where ext is no more then 3 characters (except reserved characters or spaces).

Richard Kreiss
GCC Consulting