Erik,
I'm sure, that this line causes an error, because I surrounded this code with susp. Also this code shows in debugger.
>>
>>select a.*, b.fullname as FName, " " as ntflag, .f. as currmnth, .f. as recap ;
>> from &lcSourceTbl a, Towns b;
>> where &lcWhere and;
>> a.price >= 1000 and !deleted() ;
>> into table &lcTempTable
>>
>>
>>It works fine in VFP6.0 and in FPD2.6 I really think it's a VFP5.0 bug...
>>Can somebody else confirm it?
>
>You are sure that this line is causing the error? What are the contents of lcWhere when this statement executes.
>
>This is usually not the type of situation that causes this error...
See my last reply to Fred about lcWhere. I'm in a hole here :(
BTW, now I'm working on another problem, which also put me in a hole... I'll try more, and if nothing works, start another thread...
If it's not broken, fix it until it is.
My Blog