I would try to recreate indexes on the Xcaller table. If it doesn't help, than table itself may got corrupted. Try to browse it and look for strange (binary) characters.
> I have a simple select statement on a table that just continues to error out on me(Fatal Error: Exception Code C0000005), but the SQL Statement is soooo simple, it just doesnt make any sense at all! Here is the SQL Statement:
>SELECT ;
> slsv, ;
> Notes, ;
> AcctNum, ;
> Buyer,;
> Call1AGt, ;
> Call2Agt, ;
> Call3Agt, ;
> Call4Agt, ;
> Call5Agt, ;
> Status, ;
> LastCall, ;
> Phone1, ;
> Phone2 ;
> FROM Xcaller ;
> WHERE Between(CallDate,(date()-nDaysback), Date()) ;
> INTO TABLE C:\TEMP\CALLTMP1
>Nothing crazy in there, pretty straight forward, right?? so what am I missing Guys?(and Gals ofcourse)
--sb--