In your first post you mentioned "when I save the program". Could you compile it after that to see whether something is wrong with the compilation?

>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.