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.