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?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.