>>>That is usually happened to me when I copy the query from SSMS (MS SQL Server) and pasted it in VFP. Then all Unicode chars than is not English ones become question marks :-)
>>
>>I use the ?pcParameter for the parameters, and checked all just in case, so they are all correct.
>
>Checked all parameters or all question marks? A question mark in the comments was the cause when it happened to me. Parser doesn't disregard the SQL comments, it just parses the whole command.
Yes indeed, in my case it was also a questionmark in a comment. Good to know that this causes an error which is difficult to understand at first.
Christian Isberner
Software Consultant