Hi!

Well, with query wizard - probably not a problem, but anyway, when command processed, lines
WHERE Factgrostete.invnumb = INV;
INTO CURSOR QUERY1

concatenated into

WHERE Factgrostete.invnumb = INVINTO CURSOR QUERY1

that causes an error.
This was in VFP 5, I don;t know exactly if this problem exists in newer versions of VFP.

Did you solved you problem?

>>>>>>>>>>>>>>
>Hi!
>
>Try to take INV in query into '()' and add 'm' - for case if you have such field in current table (VFP takes field value even when memory variable exists).
>In addition, put space before each semicolon, otherwise you risk to have even syntax error:
>
>STOR ALLT(THISFORM.INVNUMB1.VALUE) TO INV
>SELECT * ;
>FROM transactions!factgrostete INNER JOIN transactions!factgros ;
>ON Factgrostete.invnumb = Factgros.invnumb ;
>WHERE Factgrostete.invnumb = (m.INV) ;
>INTO CURSOR QUERY1
>>>>>>>>>>>>
>Realy? Space before the semicolon? I just used the query Wizard. Can you explain why I would get a syntax error?