Found the problem. It was not a corrupt table. In all of my sql statements that select by a date range I use variables of startdate and enddate. I recently added a new field to the table (you guessed it) startdate. My sql statements were looking at the table startdate instead of the variable.

Example

select startdate;
from calls;
where calls.startdate >= startdate;
into cursor c1

I was under the assumption that if no table was given then the system looked vor a variable. OOPS.

Thanks for you advise.

Dennis