>Hi everybody,
>
>We found a strange problem which I believe is a bug in VFP compilator.
>
>This code
>
>INSERT INTO myCursor_Name (field1, field2, ...) SELECT * from myCursor_Name_temp
>
>would not compile.
>
>This variation
>
>INSERT INTO myCursor_Name (field1, field2, ...) SELECT field1, field2, etc. from myCursor_Name_temp
>
>would not compile either in the form's method.
>
>We had to use APPEND from syntax instead.
>
>Do you see what can be wrong with the above statements?
>
>Thanks in advance.

I don't see anything wrong with it from the shorthand description. Any chance you can post the exact code?

What compiler error did you get?