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?
>Actually, it's better to find the source of the error. It might be questionable whether this set of conditions qualifies as an error or not, but the fact that you don't know where it is coming from implies that how your program is working, in ways you don't know about.
>
>
>> Thanks for reply, so, I'd better set talk off. I set it on in order to see termometer during SQL execution. Very strange bug... I spent ~2 hours trying to solve the problem. What should I do without UT? :)
>>
>>Fred, Ed, thanks to all of you too.
>>
>>>>>3) In my SQL I have an error:
>>>>> Cannot access characters beyond string (Error 62). What should I do?
>>>>>
>>>>
>>>>Look for a function where you reference an offset in a string; this error indicates that the number is bigger than the length of the string, or is negative.
>>>
>>>I might add also that, strangely, this error only menifests itself when SET TALK is ON. Otherwise, the function that tried to access the extra characters just returns an empty string. I call that a bug.