>>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?
>
>Do you maybe have a field or cursor name that is a reserved word?
No, I don't think so, but I double check. All fields seem to be Ok, like yBalance, nAccounts, etc. no names conflicting with reserved words.
The cursor name was quite long
c_StatusSummary and c_StatusSummary_temp, but I don't think it should be a problem.
Can you try this syntax with these long cursor names please?
If it's not broken, fix it until it is.
My Blog