>In my method dataenvironment.beforeopentables VFP6 works very strange. The first time I created the form I put the following code in it:
>
>cRappFile = sys(2023) +'\'+ sys(3)
>
>create table &cRappFile free (idnr, rad i, artikelnr c(20), artnamn c(50), antal n(8,2), enhet c(10), pris y, rabatt n(5,2), summa y)
>
>As you can see and as I noticed the first time I run the form it gave me an syntax error. No strange with that. But here starts the strange things to happend... I've corrected the error and now the code looks like this (this code works in the command window):
>
>cRappFile = sys(2023) +'\'+ sys(3)
>
>create table &cRappFile free (idnr c(10), rad i, artikelnr c(20), artnamn c(50), ;
> antal n(8,2), enhet c(10), pris y, rabatt n(5,2), summa y)
>
>Now I thoungt everything was fine and I builded my application again and tried... The same error. VFP still thoungt I have the wrong code... I went back to the form and opened it two check if I have forgotten to save, but no the right code was there, so I closed the form and build it again now with the "Recompile all files". Tried the application and STILL get the same error. Now I started to get angry!!! So I removed all code from the dataenvironment.beforeopentables and build it again. The error message disaperad. I went back and put the right code in the method thinking that I must have "cleared-out" the wrong code lying somewhere messing upp my app. Builded it and tried again. The error is back. And in the error-message it's still show the code I first put there, who hasn't been there for ages...
>
>What is wrong? Is there a VFP6 bug messing with me or am I doing something wrong?
>
>/Mårten Törnquist

In all probability you're being bitten by LFNS or an embedded space in the path. Because of this, avoid using macro substitution for path specification at all times. Try this instead:

cRappFile=sys(2023) +'\'+ sys(3)
create table (cRappFile) free (idnr c(10), rad i, artikelnr c(20), artnamn c(50), ;
antal n(8,2), enhet c(10), pris y, rabatt n(5,2), summa y)