#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0

    Thumbs down 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.
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,642
    Rep Power
    4247
    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
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    2
    Rep Power
    0
    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?

IMN logo majestic logo threadwatch logo seochat tools logo