Hi, Yuri,

Thank you the reply.

Yes, I do. I rely on it everyday. I should have mentioned that I had that option set.

I know it should be: "select a, b,c,d from mydb!table1 into cursor curjjj" after the code is corrected.
Let me rephrase my question: Why didn't the compiler catch this syntax error while the prg was being compiled?

I also like the verticle style as it is more readible for a programmer as opposed to a long, one line SQL statement.

Any other thoughts?

Dawa

>Most likely you did not set the Edit Ptroperties to "Compile before saving".
>Should be:
>
>select a, b,c,d from mydb!table1 into cursor curjjj
>
>See for proper comma positions.