Page 1 of 1
Help-me - RefreshQuick
Posted: Tue 03 Jun 2008 13:16
by wesleytorres
I execute refreshquick(false) in my program in a timer every 60 seconds and returned an error UNIQUE KEYSFIELD REQUIRED. But, i have timestamp field and unique key field in my table on mysql. In my keyfield, I use GUID ( 848264F9-2020-4615-BEBB-63962EA3C25C ) and not is always the error occurs.
Tanks
Posted: Thu 05 Jun 2008 10:58
by Antaeus
I could not reproduce the problem.
Please send me a complete small sample at mydac*crlab*com to demonstrate it, including script to create and fill table.
Also supply me the following information:
- the exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- the exact version of your IDE;
- the exact version of SQL server and client. You can see it in the Info sheet of TMyConnection Editor.
Version
Posted: Thu 05 Jun 2008 12:47
by wesleytorres
Mydac 5.50.0.34 for delphi 2007;
Delphi 2007 sp3
MySQL server version: 5.0.51a-community-nt
MySQL client version: Direct
Posted: Fri 06 Jun 2008 12:54
by Antaeus
Did you send the test sample and the script to the e-mail specified in my previous post? I have not received it yet.