>Hi Sergey,
>
>I tried to delete the index file datacenter.cdx and remove the index in the table structure. Then rebuilt the database file. After that, I tried to configure the ODBC Connection and tried to execute the command. Now, it displays the correct data. I am confused with this, How come the index needs to be deleted and rebuilt before the sql syntax will execute appropiately?

Hi Mike,

If foxpro can it will use index to speed up query. If index is corrupted than query result could be incorrect. For how foxpro uses Rushmore to Speed Data Access see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgusing_rushmore_to_speed_data_access.asp.