>>For some reason when I use set order to on my table I am getting an extra >>row of data when I browse my table. The field is a numeric field that I >>have the data in. Has anyone else seen this problem its happening on >>windows XP.

Are you issuing a LOCATE or doing a SEEK() after your set order?

Have you tried a PACK or REINDEX just to check you don't have an index corruption (they do happen!)

Or is it possible you have a filter condition in the index setup?


Gary.