delphi and mysql important

Hi, friends there!

I try to use mysql with delphi 6. I downloaded and made all configurations for odbc and bde. But whenever I try to use query.refresh metod delphi gives a runtime error:

"operation not supported....... table is not uniquely indexed"

I made all indexes and primary key but what is that? I searched all over internet and found nothing. Please help me. Thanks.

What is the value of your Query object's RequestLive property (try setting the value to True). Also, not all database drivers support the Refresh method -- dBase and Paradox do, but I'm not sure about MySQL. Closing and Reopening the Query object might be your best bet here. Hope this helps

Hi, requestlive property is equal to true but still it gives runtime error. I don't understand! What a bad point is that? Everytime I want to refresh I have to reopen the query......... Isn't there some other way?