Hi all!

The following SQL was working fine in the previous version of visual forxpro and when migrate to vfp8.0 result with error "table has no index order set" I check some posting in the previous month and there some people having problem with this in vfp8.0 but nobody look like is getting a correct answer because all the thread are inconclusive.

Please review the followin SQL and give me some clues, BTW the grid that was in the form does not have any relation are plain cursor and there no relation in the code that can make us to think there a previous code that now is causing the problem.

select tcern.cjobid, tcern.cprocgrp, tcern.cpaytype, tcern.clvtype, 00000 as recnum, ;
		padr(iif(left(tcern.cerndesc,1) = "*", ;
				subs(tcern.cerndesc,2), tcern.cerndesc) ,19) as cerndesc, ;
		000000.00 as nernqty, 000000.00 as nernamt, ;
		round(000000.00 * 000000.00,2) as neamount, ;
		sum(round(tcern.nernqty * tcern.nernamt,2)) as nytd ;
	from (jckcomb), tcern, tcrec ;
	where left(tcern.cjobid,10) = &jckcomb..cemplid ;
		and tcern.cadjnum = 99 and tcern.stat # 'V' ;
		and tcern.nyear = thisform.payrollyear ;
		and tcern.ctctrannum not in (select distinct ctctrannum from (ttcrec)) ;
		and tcrec.ctctrannum = tcern.ctctrannum ;
		and tcrec.cjobid = tcern.cjobid ;
		and tcrec.cfrqcode = tcern.cfrqcode ;
		and tcrec.cadjnum = 99 ;
		and year(tcrec.dwrntdte) = year(sys_date) ;
		and tcrec.nyear = thisform.payrollyear ;
	into table (jckeytdtmp2a) ;
	group by 1, 2, 3, 4 ;
	order by 1, 2, 3, 4

Any help will be very well apreaciate, we are in the process of approve the use of vfp 8.0 and there a couple of issue that was resolve but this one is common in the previous posting but nobody got a correct answer that bring other help to resolve the problem.