September 10th, 2003, 04:29 PM
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.
September 11th, 2003, 05:54 PM
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
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo
September 13th, 2003, 07:47 AM
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?