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
Help-me - RefreshQuick
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.
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.
-
wesleytorres
- Posts: 3
- Joined: Mon 19 May 2008 11:01
Version
Mydac 5.50.0.34 for delphi 2007;
Delphi 2007 sp3
MySQL server version: 5.0.51a-community-nt
MySQL client version: Direct
Delphi 2007 sp3
MySQL server version: 5.0.51a-community-nt
MySQL client version: Direct