You shou prefix all your memory variables with 'm.'. It will prevent problem like that in the future.

>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