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?
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.