This errors has been hitting me in the following sequel statement:
SELECT bcdata.*, employee.lastname, ;
employee.firstname, employee.cell, routerd.desc, routerd.esthrs, ;
routerd.wcenter ;
FROM bcdata, employee, routerd ;
WHERE employee.empno = bcdata.empno ;
AND STR(routerd.wo,9,2) + STR(routerd.seqno,5,0) = STR(bcdata.wo,9,2) + STR(bcdata.seqno,5,0) ;
AND bcdata.datein BETWEEN m.startdate AND m.enddate ;
ORDER BY bcdata.datein, bcdata.timein, bcdata.wo, bcdata.seqno ;
INTO CURSOR ltalldwo

The only variables are the m.startdate and m.enddate. The query does work when the date range is 6/10/1999 through 6/14/1999 but not when the start date is 6/1/1999. Set century is on and set date is American and set strictdate = 1. I know this is supposedly a video error, but I haven't any idea why it would crop up here. I ran dSalvage on all the tables and no errors were reported. I reindexed all tables too. Still reports the error.
Anybody have any clues as to what could be wrong?

TIA, Susan