>I don't know then because I copied your code out and created a table with the fields you have in the index and the only time I get it to error out is if the select is 100% optimized.
>
>Good luck


hmmm, interesting, any way to tell vfp6 to create a temp-dbf no matter what (other then 'un-optimizing the querry)?