Hi, all,

I just noticed this. If I have a SQL stement as follows:

select a, ;
 b, ;
 c ;
 d, ;
 from mydb!table1 ;
 into cursor curjjj 

When I save the prg, it does not tell me that there is a syntax error. But when this line gets excuted I get
"Command contains unrecognized phrase/keyword." message. I am using VFP 7. Is this a bug in the compiler? If so, is it fixed in VFP 8? It would be more productive if VFP told me that there is a comma missing or there is an extra comma, then I can fix it right on the spot. Instead I have to debug, get an error, stop the debugger, find my prg, find the line, then look for the syntax that caused the error. It's time consuming when I have alot of fields, in the above like statements, to go through the process. On the other hand, once discovered, it is easily fixed in the code.

Any tips or comments will be appreciated,

Dawa