Problem with Dots in Filenames and Lookups
Mike Rathburn
mike at datadoit.com
Mon Mar 28 09:19:26 PST 2005
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
More information about the Filepro-list
mailing list