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.