Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compiler does not catch this syntax error, bug?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00901990
Message ID:
00901993
Views:
22
Most likely you did not set the Edit Properties to "Compile before saving".
Should be:

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

Look for comma proper positions.

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform