>Hi everybody,
>
>I created a little project, which worked fine in VFP6.0 SP3. Unfortunately, my manager asked me to check, that this project works also in VFP5.0. Ok, I tried to recompile in VFP5.0. I found:
>1) IndexSeek(), VarType(), ALINE() - are new functions in VFP6.0
> So, I modified my code and classes appropriately
>2) I tried to use Words() and WordNum() functions from FoxTools() and keep getting an error: unknown Words()
> Ok, just ignore this error.
>3) In my SQL I have an error:
> Cannot access characters beyond string (Error 62). What should I do?
>
> I can say, that after VFP6.0 VFP5.0 is very unpleasant :(
>
> BTW, there is the code, which causes this error:
>
>

>if lbYearToDate && Need the whole year
>	select a.*, lcIssueMonth as issuenum, " " as ntflag, ;
>		between(iif(val(extryear)<10,'20','19')+extryear+extrweek, lcBeginWeek, lcEndWeek) as currmnth,;
>		b.fullname as FName, lbYearToDate as recap ;
>		from  (lcDBF1) a, Towns b;
>		where &lcWhere ;
>		into table (lcTempTable)
>else
>	select a.*, lcIssueMonth as issuenum, " " as ntflag, .f. as currmnth,;
>		b.fullname as FName, lbYearToDate as recap ;
>		from  (lcDBF1) a, Towns b;
>		where &lcWhere ;
>		union;
>		select c.*, lcIssueMonth as issuenum, " " as ntflag, .f. as currmnth,;
>		d.fullname as FName, lbYearToDate as recap ;
>		from  (lcDBF2) c, Towns d;
>		where &lcWhere2 ;
>		into table (lcTempTable)
>endif
>

>
> Thanks in advance.

Check your SET TALK setting. In VFP5, if TALK is ON, you'll get your "beyond string" errors. You won't get them with SET TALK OFF, of with either setting in VFP6.