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.
If it's not broken, fix it until it is.
My Blog